The error message you received indicates that the named_struct function is not registered in Athena

Please provide more information so we can help you - what were you trying to do, what have you set up, what command did you execute and where, and what is the full error and response info you received?

hi am trying to create a table from exernal data which is in the S3 bucket.

the table was created, so now the error came after i've tried to insert data into the table:

so with the initial error i sorted that with replacing 'named_struct" with 'row'

But now am getting another problem - error message: "TYPE_MISMATCH: Insert query has mismatched column types: Table: [varchar, row(timestamp varchar, region varchar, products array(row(name varchar, price integer, payment_method varchar))), row(cashier varchar, manager varchar), array(row(technician varchar, shift_start varchar))], Query: [varchar(6), row(varchar(24), varchar(20), array(row(varchar(7), varchar(13), varchar(5), integer, varchar(7), varchar(11))), row(varchar(9), varchar(5), varchar(10), varchar(5))), array(row(varchar(14), varchar(7), varchar(16), varchar(24)))]. If a data manifest file was generated at 's3://updatedround/Unsaved/2023/04/10/9fd0889f-b0a9-44e8-80cb-d2731a352500-manifest.csv', you may need to manually clean the data from locations specified in the manifest. Athena will not delete data in your account."