title: No partition predicate found for Alias even when the partition predicate in present in the query
body: <p>I have a table pos.pos_inv in hdfs which is partitioned by yyyymm. Below is the query:</p>
  
  <pre><code>select DATE_ADD(to_date(from_unixtime(unix_timestamp(Inv.actvydt, 'MM/dd/yyyy'))),5), 
         to_date(from_unixtime(unix_timestamp(Inv.actvydt, 'MM/dd/yyyy'))),yyyymm 
     from pos.pos_inv inv 
        INNER JOIN pos.POSActvyBrdg Brdg ON Brdg.EIS_POSActvyBrdgId = Inv.EIS_POSActvyBrdgId 
        where to_date(from_unixtime(unix_timestamp(Inv.nrmlzdwkenddt, 'MM/dd/yyyy'))) 
         BETWEEN DATE_SUB(to_date(from_unixtime(unix_timestamp(Inv.actvydt, 'MM/dd/yyyy'))),6) 
          and DATE_ADD(to_date(from_unixtime(unix_timestamp(Inv.actvydt, 'MM/dd/yyyy'))),6) 
          and inv.yyyymm=201501
  </code></pre>
  
  <p>I have provided the partition value for the query as 201501, but still i get the error"    </p>
  
  <pre><code> Error while compiling statement: FAILED: SemanticException [Error 10041]: No partition predicate found for Alias "inv" Table "pos_inv"
  </code></pre>
  
  <p>(schema)The partition, yyyymm is int type and actvydt is date stored as string type.</p>