Bug in generating partition pruner expression ---------------------------------------------
Key: HIVE-1292 URL: https://issues.apache.org/jira/browse/HIVE-1292 Project: Hadoop Hive Issue Type: Bug Affects Versions: 0.6.0 Reporter: Zheng Shao The logic for generating the in GenericFuncExprProcessor has a problem. None of the partitions passed the pruner in the following query: {code} SELECT * FROM mytable a WHERE pcol0 = '2010-04-03' AND CASE WHEN ((col0 ='a') OR (col0 = 'b')) THEN 'a' ELSE NULL END IS NOT NULL; {code} While the partition '2010-04-03' did pass the pruner in the following query: {code} SELECT * FROM mytable a WHERE pcol0 = '2010-04-03' AND CASE WHEN (col0 ='a') THEN 'a' ELSE NULL END IS NOT NULL; {code} The logic for generating the pruner condition is here: org.apache.hadoop.hive.ql.optimizer.ppr.ExprProcFactory.GenericFuncExprProcessor.process(...) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.