title: Hive query getting stuck in the middle of execution
body: <p>Colleagues, </p>
  
  <p>I'm facing with an issue while execution of bash file with sql script in hive  - it always stuck at the same place map=100%, reduce=67%</p>
  
  <p>I tried to play with mappers and reducers number with different variations and other tunning characteristics:</p>
  
  <pre><code>SET hive.exec.parallel=true;
  SET hive.default.fileformat=RCFILE;
  SET hive.stats.autogather=false;
  SET hive.exec.compress.output=true; 
  SET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec; 
  SET mapred.output.compression.type=BLOCK;
  SET hive.input.format=org.apache.hadoop.hive.ql.io.CombineHiveInputFormat;
  </code></pre>
  
  <p>But result still the same - it continuously return 67% of reducing progress.</p>
  
  <p>Hive version - 0.13.0.2.X.X.X</p>
  
  <p>SQL contains table creation from several source - simple join of several tables.</p>
  
  <p>Any ideas how to tune this?</p>
  
  <p>Any help will be appreciated.</p>