https://community.cloudera.com/t5/Support-Questions/Hive-query-error-with-Vertex-failed-on-partitioned-table-by/m-p/209144#M171101 <P>Finally, I found the solution. </P><PRE> set hive.auto.convert.join.noconditionaltask = true; set hive.auto.convert.join.noconditionaltask.size = 2000000; </PRE><P>By playing with <STRONG>hive.auto.convert.join.noconditionaltask.size</STRONG> got adequate performance. Low value provides performance degradation. </P><P>Next parameters also might be helpful:</P><PRE>set hive.auto.convert.sortmerge.join=true set hive.optimize.bucketmapjoin=true set hive.optimize.bucketmapjoin.sortedmerge=true set hive.auto.convert.sortmerge.join.noconditionaltask=true set hive.auto.convert.sortmerge.join.bigtable.selection.policy=org.apache.hadoop.hive.ql.optimizer.TableSizeBasedBigTableSelectorForAutoSMJ</PRE> Tue, 10 Oct 2017 22:34:46 GMT yevgen_shramko 2017-10-10T22:34:46Z