title: Multiple Joins with same table in HIVE
body: <p>In the query below, I am joining table T1 to multiple tables based on same key. I am wondering in this case do I need to specify the conditions</p>
  
  <pre><code> AND a.ds = '2014-12-10'
   AND a.org_id IS NULL
  </code></pre>
  
  <p>for every join ? What is the rationale for not doing this ?</p>
  
  <pre><code>INSERT OVERWRITE TABLE tab1
          PARTITION(ds='2014-12-10')
      SELECT
          a.var1
          , b.var2
          , c.var3
          , d.var4
  
      FROM T1 a
      LEFT OUTER JOIN T2 b
          ON a.var1 = settings.var1
  
          AND a.ds = '2014-12-10'
          AND a.org_id IS NULL
  
      LEFT OUTER JOIN T3 c
          ON a.var1 = bmid.var1
          AND c.ds = '2014-12-10'
  
          AND a.ds = '2014-12-10'
          AND a.org_id IS NULL
  
      LEFT OUTER JOIN T4 d
          ON a.var1 = daa.var1
          AND d.ds = '2014-12-10'
  
          AND a.ds = '2014-12-10'
          AND a.org_id IS NULL
  </code></pre>