Failed Athena query due to "internal error" and "exhausted resources"

Question

Hi all,

We are having two queries fail on Athena. Here's a message that was in the Query Results section. Please let me know what additional information you need from me to resolve the issues. Thanks!

Only 50-60MB of data is scanned. For some reason, the run time is 10-13 minutes. Queries that scan more data usually have shorter run times.

We've tried to re-run the queries many times over several days. We've been having these issues since 9/17/23.

To confirm, the queries are running on Athena engineer version 3.

**First Query Result**
> Amazon Athena experienced an internal error while executing this query. Please try submitting the query again, and if the issue reoccurs, contact AWS support for further assistance. We apologize for the inconvenience.
This query ran against the "default" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: 0cfb4f14-11a9-4d3d-82f3-dbdd4a7712be

**Second Query Result**
>Query exhausted resources at this scale factor. This query ran against the "default" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: dee4ffc6-1c1d-4dd3-a7c0-7c81a5da1ea5

Answer

Hello Mardo, we are also facing this issue in our company. We reported it in this post

It was recommended that we open a ticket, but we haven't done so due to the required cost.

We are still without solutions and monitoring the threads.

It was recommended that we open a ticket, but we haven't done so due to the required cost.

We are still without solutions and monitoring the threads.

Failed Athena query due to "internal error" and "exhausted resources"

Relevant content