Intenal Errors in AWS Athena
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.
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.
Relevant questions
Got a validation error for the tableName, but can't figure out what it is
Accepted Answerasked 3 years agoAthena throws an error on auto-generated queries by Quicksight
asked 16 days agoAdditional Costs for running query in Athena on S3
Accepted Answerasked 2 years agoAthena: encounter errors when update Iceberg table
asked 23 days agoDoes Athena support ORDER BY in ARRAY_AGG ?
Accepted Answerasked 2 years agoAthena queries against mongodb
asked a day agoIntenal Errors in AWS Athena
asked 16 days agoDynamoDB updateItem: validation errors in params definition (novice here)
asked 3 years agoInvalid S3 request when creating Iceberg tables in Athena
asked 3 months agoError msg when running query in aws athena
asked 4 months ago