title: hive left outer join long running
body: <p>Hortonworks HDP 2.3.0 - Hive 0.14</p>
  <p><code>Table T1 ( partition on col1, no bucket, ORC )</code>  app 120 million rows &amp; 6GB datasize
  <code>Table T2 ( partition on col2, no bucket, ORC )</code> app 200 M rows &amp; 6MB datasize</p>
  <pre><code>T1 left outer join on t2 ( t1.col3 = t2.col3 )
  </code></pre>
  <p>The above query is long running in the last reducer phase in both tez &amp; mr mode.
  I also tried auto convert true / false &amp; explicit mapjoin.</p>
  <p>Still the query is running in the last reducer phase, never ending.</p>
  <p>FYI - If data size of T2 is either 9k or 1GB, the query finishes.</p>