[HIVE-17247] HoS DPP: UDFs on the partition column side does not evaluate correctly

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Spark
• Target Version/s: 3.0.0
• Assignee: Sahil Takiar
• Reporter: Sahil Takiar
• Created: 04/Aug/17 00:40
• Updated: 23/May/18 00:00
• Resolved: 08/Aug/17 04:05

Description

Same problem as HIVE-12473 and HIVE-12667.

The query below (uses tables from spark_dynamic_partition_pruning.q) returns incorrect results:

select count(*) from srcpart join srcpart_date on (day(srcpart.ds) = day(srcpart_date.ds)) where srcpart_date.`date` = '2008-04-08';

It returns a value of 0 when DPP is on, when it is disabled it returns 1000

Issue Links

• links to: RB