I want to understand the interpretation of Explain plan of Hive queries and identify the target areas for tuning.
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:
This one explains how Hive Joins would appear in Explains:
As always, if you find this post helpful, don't forget to "accept" answer.
View solution in original post