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

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