title: Are Hive's implicit joins always inner joins?
body: <p>The <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins" rel="nofollow noreferrer">join documentation</a> for Hive encourages the use of implicit joins, i.e.</p>
  
  <pre><code>SELECT * 
  FROM table1 t1, table2 t2, table3 t3 
  WHERE t1.id = t2.id AND t2.id = t3.id AND t1.zipcode = '02535';
  </code></pre>
  
  <p>Is this equivalent to</p>
  
  <pre><code>SELECT t1.*, t2.*, t3.*
  FROM table1 t1
  INNER JOIN table2 t2 ON
    t1.id = t2.id 
  INNER JOIN table3 t3 ON
    t2.id = t3.id
  WHERE t1.zipcode = '02535'
  </code></pre>
  
  <p>, or will the above return additional records?</p>