Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

AWS Athena - explain query plan

Can I use 'explain' statement in AWS Athena? (For reviewing query's plan) I tried to use explain statement in Athena, but I met below error message.

Your query has the following error(s):

Queries of this type are not supported (Service: AmazonAthena; Status Code: 400; Error Code: InvalidRequestException

like image 592
dbacrom Avatar asked Jun 18 '26 17:06

dbacrom


2 Answers

As per this EXPLAIN statements are not supported in Athena as of now.If you want to perform the same then you can do it in EMR-Presto by integrating it with AWS Glue catalog.

like image 191
Prabhakar Reddy Avatar answered Jun 20 '26 09:06

Prabhakar Reddy


EXPLAIN statement is now supported by Athena. You can find more information in AWS documentation.

like image 37
David Greenshtein Avatar answered Jun 20 '26 08:06

David Greenshtein



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!