[jira] Created: (HIVE-1292) Bug in generating partition pruner expression

["Zheng Shao (JIRA)" <ji...@apache.org>]

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.