The 30-minute DDL query limit is a soft limit, and an increase can be requested in the Service Quotas console.
Also in case it helps I know that people often end up with very long queries because they haven't partitioned their data and limited how many partitions their queries scan. See https://www.linkedin.com/pulse/using-athena-partition-projection-query-cloudtrail-other-kinsman for example.
Thanks. Appreciate the link on the use of partition projections in Athena. On further analysis, the user was trying to aggregate 37 Billion rows of data on a group of columns that made each rows unique. :-)
Athena permission error running a queryasked 4 months ago
How can I find the Query ID for an Athena Saved Query on AWS console?asked 5 months ago
Can I use the ID of my saved query to start query execution in Athena SDK?asked a month ago
Retrieving Athena Query History dataasked 3 years ago
INVALID_INPUT in Athena Queryasked 5 months ago
Athena federated query on PostgresSQLasked 18 days ago
Athena Query timeoutasked 2 months ago
Quicksight - Create data set (Athena) - Table query times out when trying to create data setasked a month ago
Charge for Athena query timeoutAccepted Answerasked 4 years ago
I cannot use current_date + interval in Athena boto3 query in LambdaAccepted Answerasked 4 months ago