Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to analyze poor performance of Hive query?

avatar
Contributor

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

1 REPLY 1

avatar
Expert Contributor

@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...