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.

I would like to understand how to interpret Hive Explain plan and identify the target area for tuning

SOLVED Go to solution
Highlighted

I would like to understand how to interpret Hive Explain plan and identify the target area for tuning

New Contributor

Hi,

I want to understand the interpretation of Explain plan of Hive queries and identify the target areas for tuning.

Regards,

Phaneendra

1 ACCEPTED SOLUTION

Accepted Solutions

Re: I would like to understand how to interpret Hive Explain plan and identify the target area for tuning

@Phaneendra S

Like debugging, this is a broad topic that is more an art than a science. To get you started, below are some links that provide insights on what you can look for.

This one is a presentation showcasing the "new" version of Explain and walks through a debugging example:

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

This one explains how Hive Joins would appear in Explains:

http://www.openkb.info/2014/11/understanding-hive-joins-in-explain.html

As always, if you find this post helpful, don't forget to "accept" answer.

1 REPLY 1

Re: I would like to understand how to interpret Hive Explain plan and identify the target area for tuning

@Phaneendra S

Like debugging, this is a broad topic that is more an art than a science. To get you started, below are some links that provide insights on what you can look for.

This one is a presentation showcasing the "new" version of Explain and walks through a debugging example:

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

This one explains how Hive Joins would appear in Explains:

http://www.openkb.info/2014/11/understanding-hive-joins-in-explain.html

As always, if you find this post helpful, don't forget to "accept" answer.