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

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.14.0
• Component/s: Logical Optimizer
• Assignee: Ashutosh Chauhan
• Reporter: Ashutosh Chauhan
• Created: 18/Nov/14 21:30
• Updated: 11/Apr/15 00:25

Description

e.g,

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

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