Intenal Errors in AWS Athena

Question

Running below standard query:

*****SELECT table_name, COUNT(*)
FROM   information_schema.columns AS columns_number
where table_name like '%appl%'
GROUP BY  table_name
ORDER BY 1 desc ;*****

It gives different errors as shown below :-
![Enter image description here](https://repost.aws/media/postImages/original/IMhZ5KB9U2QZChfsorzaRt7A)

OR

![Enter image description here](https://repost.aws/media/postImages/original/IMuiC2kkx5T6-veiH8vnj6gg)

It is giving these different set of errors for S3 based SQL Service - AWS Athena.

Answer

Hi,

Please ensure your table names, schemas, database names, and column names are all correct.

The “HIVE_INVALID_METADATA” happens when the AWS Glue table schema contains duplicate column names or columns with the same name as partition columns.
To resolve the error please follow the steps in the documentation here:

https://aws.amazon.com/premiumsupport/knowledge-center/athena-hive-invalid-metadata-duplicate/

As for the “GENERIC_INTERNAL_ERROR” there could be several different things causing this. Please refer to the following documentation that describes the different error cases and steps to resolve:

https://aws.amazon.com/premiumsupport/knowledge-center/athena-generic-internal-error/

Hope this helps.

Intenal Errors in AWS Athena

Relevant content