For the most recent update on ongoing service disruptions affecting the AWS Middle East (UAE) Region (ME-CENTRAL-1), refer to the AWS Health Dashboard. For information on AWS Service migration, see How do I migrate my services to another region?
How do I resolve "query timeout" errors when I import data from Athena to Quick Suite SPICE?
2 minute read
0
After I import data from Amazon Athena to Amazon Quick Suite SPICE, I receive a "query timeout" error.
Resolution
The "query timeout" error occurs when an Athena DML query reaches its maximum allowed runtime quota. To resolve the error, you can either submit a service quota request to increase the query's maximum allowed runtime or reduce time to run the query from Athena.
Increase the query runtime for Athena
Complete the following steps:
- Check your recent Athena queries to find the query that Quick Suite generated.
- Check the query's runtime duration before it fails.
- If the runtime is close to the maximum DML query timeout quota in minutes, then submit a service quota increase request.
Reduce query runtime from Athena
Take the following actions:
- Use partition projection to divide your table into parts and keep related data together.
- Compress files or split them. For more information, see Use compression in Athena.
- Optimize file sizes.
For more information, see How do I resolve "Query Timeout" errors in Athena?
Related information
- Language
- English
AWS OFFICIALUpdated 4 months ago
No comments
Relevant content
- asked 2 years ago
asked 6 years ago- AWS OFFICIALUpdated 4 months ago
- AWS OFFICIALUpdated 4 months ago
