title: Hive join query not reading all tables
body: <p>While Running JOIN query in HIVE</p>
  
  <pre><code>SELECT c.id_double, o.id_double 
  FROM hive_testQ1 c JOIN hive_testQ2 o 
  ON (c.id = o.id) limit 3;
  </code></pre>
  
  <p>Output I am getting is:</p>
  
  <blockquote>
    <p>1.2  1.2</p>
    
    <p>2.2  2.2</p>
    
    <p>3.2  3.2</p>
  </blockquote>
  
  <p>but first table has values <strong><em>.1</strong> and second table has values <strong></em>.2</strong></p>
  
  <p>No of mapred jobs being launched is only 1.</p>
  
  <p>Why values from only second table are read?`</p>
  
  <p>First Table is:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>+------+-----------+---------+------+
  | id   | id_double | names   | test |
  +------+-----------+---------+------+
  |    1 |       1.2 | Frank   |    4 |
  |    2 |       2.2 | Jamie   |    5 |
  |    3 |       3.2 | Dale    |    6 |
  |    4 |       4.2 | Eric    |    7 |
  |    5 |       5.2 | Felipa  |    8 |
  |    6 |       6.2 | Eric    |    9 |
  |    7 |       7.2 | Betty   |   10 |
  |    8 |       8.2 | Lena    |   11 |
  |    9 |       9.2 | Scott   |   12 |
  |   10 |      10.2 | Juanita |   13 |
  +------+-----------+---------+------+</code></pre>
  </div>
  </div>
  </p>
  
  <p>second table:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>+------+-----------+---------+
  | id   | id_double | names   |
  +------+-----------+---------+
  |    1 |       1.1 | Rueben  |
  |    2 |       2.1 | Anthony |
  |    3 |       3.1 | Nancy   |
  |    4 |       4.1 | Sandra  |
  |    5 |       5.1 | Ann     |
  |    6 |       6.1 | Myra    |
  |    7 |       7.1 | Donna   |
  |    8 |       8.1 | Ron     |
  |    9 |       9.1 | Allen   |
  |   10 |      10.1 | Jose    |
  +------+-----------+---------+</code></pre>
  </div>
  </div>
  </p>