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?
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,