Review Request: HIVE-2497 partition pruning prune some right partition under specific conditions

[bin lijin <bi...@gmail.com>]

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/2355/
-----------------------------------------------------------

Review request for hive and Yongqiang He.


Summary
-------

We found partition pruning would incorrectly prune some partitions the MR job needs by running a sql like below

 
select user_id 
from
(
  select 
    cast(key as int) as user_id,
    case when (value like 'aaa%' or value like 'vvv%') 
      then 1 
      else 0 
      end as tag_student
  from src3
) sub
where sub.tag_student > 0;

The patch should fix this problem.


Diffs
-----

  http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/ppr/ExprProcFactory.java 1180775 

Diff: https://reviews.apache.org/r/2355/diff


Testing
-------


Thanks,

bin