Athena Query Internal Error

The issue may cause by having the reserved keywords when you run the query, here is a link to the reserved keywords and examples to run it. https://docs.aws.amazon.com/athena/latest/ug/reserved-words.html

Also, please check your Athena engine version(https://docs.aws.amazon.com/athena/latest/ug/engine-versions-changing.html) as Athena keep releasing new engine for better performance, some syntax may not work with newer version, here is more details about the new engine improvements.(https://docs.aws.amazon.com/athena/latest/ug/engine-versions-reference.html)

Please post your query here for further investigate.

Thanks,

Immediate Checks:

Verify you have the correct permissions for this specific database Check if other queries against this database work Confirm the table(s) you're querying exist in this database using:

SHOW TABLES IN pc_slc_smtt_sustainability_db_prod;

Database-Specific Checks:

Verify the database location in S3 Check if any partitions need to be refreshed:

MSCK REPAIR TABLE yourtablename;

Try a simple SELECT on the table:

SELECT * FROM yourtablename LIMIT 5;

Query-Specific Actions:

Share your query for review (you can redact sensitive information) Try breaking down the query into smaller parts Check for any special characters or encodings that might cause issues Next Steps:

Document the Query ID: 3e3e22c7-76c9-46fb-9d66-2d464a2b67a3 Contact AWS Support with: The full query The database name: pc_slc_smtt_sustainability_db_prod Any recent changes to the database or tables The error message and Query ID