How to analyze poor performance of Hive query?

[#1]

If a query in Hive is running slow, how to analyze poor performance of Hive query? Is there any explain plan for the query to get the execution method of query?

Please advise.

Thank you,

Sachin A

[#2]

@Sachin Ambardekar

Yes you can take explain plan for your hive query by running

Syntax : EXPLAIN [EXTENDED|DEPENDENCY|AUTHORIZATION] query

You can read more about hive tuning here,

https://www.slideshare.net/HadoopSummit/how-to-understand-and-analyze-apache-hive-query-execution-pl...