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)
