Re: Interpreting explain plan in hive

2013-08-23 Thread Edward Capriolo
The only bad plan would be a plan that ends up producing the wrong result, or throwing an exception. generally I look to see if there is a way to have less map/reduce stages, the best plan is usually the one that does the job in a single map reduce, or even better a single map only job. On Fri, A

Interpreting explain plan in hive

2013-08-22 Thread pandees waran
Hi, What are the key areas we need to check in the explain plan generated in Hive? I have checked the documentation, it's not detailed about the above question. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Explain I have similar kind of question asked in our forum, which is unan