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

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.2.1, 1.3.0, 2.0.0
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: Tez
• Target Version/s: 2.0.0
• Assignee: Sergey Shelukhin
• Reporter: Gopal Vijayaraghavan
• Created: 19/Nov/15 23:33
• Updated: 16/Feb/16 23:52
• Resolved: 14/Dec/15 20:59

Description

Related to HIVE-12462

select count(1) from accounts a, transactions t where year(a.dt) = year(t.dt) and account_id = 22;

$hdt$_0:$hdt$_1:a
  TableScan (TS_2)
    alias: a
    filterExpr: (((account_id = 22) and year(dt) is not null) and (year(dt)) IN (RS[6])) (type: boolean)

Ends up being evaluated as year(cast(dt as int)) because the pruner only checks for final type, not the column type.

    ObjectInspector oi =
        PrimitiveObjectInspectorFactory.getPrimitiveWritableObjectInspector(TypeInfoFactory
            .getPrimitiveTypeInfo(si.fieldInspector.getTypeName()));

    Converter converter =
        ObjectInspectorConverters.getConverter(
            PrimitiveObjectInspectorFactory.javaStringObjectInspector, oi);

Issue Links

• is related to: HIVE-12667 Proper fix for HIVE-12473