[HIVE-6934] PartitionPruner doesn't handle top level constant expression correctly

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.14.0
• Component/s: Logical Optimizer, Query Processor
• Assignee: Hari Sankar Sivarama Subramaniyan
• Reporter: Harish Butani
• Created: 18/Apr/14 19:03
• Updated: 13/Nov/14 19:41
• Resolved: 21/Oct/14 18:30

Description

You hit this error indirectly, because how we handle invalid constant comparisons. Consider:

create table x(key int, value string) partitioned by (dt int, ts string);

-- both these queries hit this issue
select * from x where key = 'abc';
select * from x where dt = 'abc';

-- the issue is the comparison get converted to the constant false
-- and the PartitionPruner doesn't handle top level constant exprs corrcetly

Thanks to hsubramaniyan for uncovering this as part of adding tests for HIVE-5376

Issue Links

• blocks: HIVE-8490 Constant folding should happen before partition pruning
• is related to: HIVE-7417 select count(1) from ... where true; fails in optimizer
• relates to: HIVE-5376 Hive does not honor type for partition columns when altering column type
• links to: Review board