[jira] [Created] (HIVE-8907) Partition Condition Remover doesn't remove conditions involving cast on partition column

["Ashutosh Chauhan (JIRA)" <ji...@apache.org>]

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)