title: Hive query stuck at 99%
body: <p>I am inserting records using left joining in Hive.When I set limit 1 query works but for all records query get stuck at 99% reduce job.</p>
  
  <p>Below query works</p>
  
  <pre><code>   Insert overwrite table tablename select a.id , b.name from a left join b on a.id = b.id limit 1; 
  </code></pre>
  
  <p>But this does not</p>
  
  <pre><code>    Insert overwrite table tablename select table1.id , table2.name from table1 left join table2 on table1.id = table2.id;
  </code></pre>
  
  <p>I have increased number of reducers but still it doesn't work.</p>