By using AWS re:Post, you agree to the Terms of Use

Intenal Errors in AWS Athena

0

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

OR

Enter image description here

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

1 Answers
2

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.

profile picture
answered 15 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions