hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "bin lijin" <binli...@gmail.com>
Subject Review Request: HIVE-2497 partition pruning prune some right partition under specific conditions
Date Wed, 12 Oct 2011 10:45:54 GMT

-----------------------------------------------------------
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


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message