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

phani_sub — Fri, 16 Sep 2022 11:41:47 GMT

Hi,

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

Regards,

Phaneendra

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

egarelnabi — Fri, 02 Jun 2017 22:06:29 GMT

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-plan-for-performance-debugging

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.

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

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

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