By using AWS re:Post, you agree to the Terms of Use
/Query Id: ddfe7caf-be98-4c33-a2f1-b50502a22961/

Query Id: ddfe7caf-be98-4c33-a2f1-b50502a22961

0

My query is showing time out error in athena I want list of s3 objects in csv format from my bucket

asked 4 months ago3 views
2 Answers
1

You need to consider the volume of data you're trying to scan - not just the amount you expect to retrieve, but how much data will have to be scanned to gather the retrieved data. If you have a lot of data you'll need to partition it and limit your query to target less partitions to avoid timeouts and long queries. As an example, see this blog post about using Partition Projection for Athena queries on CloudTrail logs in S3 - https://www.linkedin.com/pulse/using-athena-partition-projection-query-cloudtrail-other-kinsman/?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_post_details%3Brq0yhJ20SQKlSN9blwev9g%3D%3D

answered 4 months ago
EXPERT
reviewed 24 days ago
0

Hi, if you want to understand some specific information on a query execution, your best option is to open a support case.

Athena has a default timeout set to 30 minutes, you can submit a request to change it if you expect the query to run longer that.

Please, clarify the type of Query, possibly sharing it and the DDL of the table as well, if you would like a more precise answer.

Also, please refer to the answer to your other question considering Amazon S3 Inventory , if that could help in your use case.

EXPERT
answered 4 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions