Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

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 :-

OR

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

Topics
AnalyticsDeveloper Tools
Tags
AWS GlueS3 SelectDeveloper ToolsAmazon Athena
Language
English

asked 4 years ago808 views

1 Answer
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.

AWS

answered 4 years 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.

Relevant content