title: RIGHT/LEFT OUTER JOIN perform differently in HIVE?
body: <p>Does "RIGHT OUTER JOIN" and "LEFT OUTER JOIN" perform differently in HIVE?</p>
  
  <p>For example, Table A is a small table. Table B is much larger and partitioned on col2.</p>
  
  <p>Query 1:
  <code>SELECT * 
  FROM A RIGHT OUTER JOIN B on (A.col=B.col)
  WHERE B.col2&gt;20131001</code></p>
  
  <p>Query 2:
  <code>SELECT * 
  FROM A LEFT OUTER JOIN B on (A.col=B.col)
  WHERE B.col2&gt;20131001</code></p>
  
  <p>Query 1 only scans a small number of partitions, but Query 2 scans all partitions of Table B. Is it a bug or I miss something?</p>
  
  <p>Thanks!</p>