Gopal V created HIVE-12462:
------------------------------

             Summary: DPP: DPP optimizers need to run on the TS operators not 
FIL 
                 Key: HIVE-12462
                 URL: https://issues.apache.org/jira/browse/HIVE-12462
             Project: Hive
          Issue Type: Bug
          Components: Tez
            Reporter: Gopal V
            Assignee: Gopal V
            Priority: Critical


HIVE-11398 + HIVE-11791, the partition-condition-remover became more effective.

This removes predicates from the FilterExpression which involve partition 
columns, causing a miss for dynamic-partition pruning if the DPP relies on 
FilterDesc.

The TS desc will have the correct predicate in that condition.

{code}
$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)
    Filter Operator (FIL_20)
      predicate: ((account_id = 22) and year(dt) is not null) (type: boolean)
      Select Operator (SEL_4)
        expressions: dt (type: date)
        outputColumnNames: _col1
        Reduce Output Operator (RS_8)
          key expressions: year(_col1) (type: int)
          sort order: +
          Map-reduce partition columns: year(_col1) (type: int)
          Join Operator (JOIN_9)
            condition map:
                 Inner Join 0 to 1
            keys:
              0 year(_col1) (type: int)
              1 year(_col1) (type: int)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to