hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-8907) Partition Condition Remover doesn't remove conditions involving cast on partition column
Date Tue, 18 Nov 2014 21:31:34 GMT
Ashutosh Chauhan created HIVE-8907:
--------------------------------------

             Summary: Partition Condition Remover doesn't remove conditions involving cast
on partition column
                 Key: HIVE-8907
                 URL: https://issues.apache.org/jira/browse/HIVE-8907
             Project: Hive
          Issue Type: Improvement
          Components: Logical Optimizer
            Reporter: Ashutosh Chauhan
             Fix For: 0.14.0


e.g,
{code}
create table partition_test_partitioned(key string, value string) partitioned by (dt string)
 explain select * from partition_test_partitioned where cast(dt as double) >=100.0 and
cast(dt as double) <= 102.0
{code}

For queries like above, although {{PartitionPruner}} is able to prune partitions correctly,
filter is still not optimized away by PCR, where it could.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message