https://community.cloudera.com/t5/Support-Questions/Adding-nodes-will-improve-performance/m-p/53469#M5489 <P>I would say just Adding nodes would not result good performance all the time &nbsp;, as you said there are some parameters thats needs to be take care . I would consider doing few things like Optimized joins , making the large table in the query as last when performing join or use hint like Streamtable . Enabling the Local mode , mainly tuning the number of mappers and reducers , JMV reuse and finally using the good old Index &nbsp;,sometimes help speed up the group by query in hive . &nbsp; I also agree with&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/18441">@saranvisa</a>&nbsp;and&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/18127">@mbigelow</a>&nbsp;on their thoughts .&nbsp;</P> Tue, 11 Apr 2017 06:24:28 GMT csguna 2017-04-11T06:24:28Z