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
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.
EXPLAIN statement is now supported by Athena. You can find more information in AWS documentation.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With