Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to analyze poor performance of Hive query?

How to analyze poor performance of Hive query?

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

Re: How to analyze poor performance of Hive query?

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

Don't have an account?
Coming from Hortonworks? Activate your account here