How to Fix AWS Athena Query Stuck Loading Results for 24 Hours

Select Language:

If you’re facing an issue where an Athena query has been stuck for 24 hours and the console isn’t responding, don’t worry — there are steps you can take to fix this problem.

First, your query might be running into an internal error on Athena’s side, known as an INTERNAL_ERROR_QUERY_ENGINE. This kind of problem isn’t caused by your input but by a glitch within Athena. Sometimes, this causes your query to freeze or stall.

Another common reason could be data or query complexity. Even if your query is simple, like selecting the first 10 rows, the underlying data might be causing the issue. Large files, complex data structures, or non-optimized formats can slow things down or lead to errors.

Sometimes, the console itself might be unresponsive. It could be a browser issue rather than a problem with Athena.

To fix this, start by trying a different browser or open the console in incognito mode. This can help determine if browser cache or cookies are causing the problem. If that doesn’t work, try accessing Athena using the AWS Command Line Interface (CLI). Running or cancelling the query through CLI often bypasses console issues.

You can also check the query status without the console by using AWS CLI commands or SDKs. If the query is still stuck or you can’t cancel it, it might be time to contact AWS Support. They can investigate if there’s an internal system issue causing the problem.

Next, make sure your data is formatted correctly. Verify that your CSV files aren’t too large or poorly structured. Using optimized file formats like Parquet or ORC can improve performance and reduce potential errors.

Finally, check that your AWS Identity and Access Management (IAM) permissions are set correctly. Your role should have access to both Athena and the AWS Glue Data Catalog.

Once your environment is up and running again, consider best practices like partitioning your data and choosing efficient storage formats. These steps can help prevent similar issues in the future and improve query speed.

If you want more detailed information, resources from AWS community forums and support documents offer helpful guidance on troubleshooting Athena errors and performance issues.