[HIVE-11044] Some optimizable predicates being missed by constant propagation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0
• Component/s: Query Planning
• Assignee: Jason Dere
• Reporter: Jason Dere
• Created: 18/Jun/15 17:34
• Updated: 16/Feb/16 23:51
• Resolved: 23/Jun/15 18:53

Description

Some of the qfile explain plans show some predicates that could be taken care of by running ConstantPropagate after the PartitionPruner:

index_auto_unused.q:

filterExpr: ((12.0 = 12.0) and (UDFToDouble(key) < 10.0)) (type: boolean)

join28.q:

predicate: ((11.0 = 11.0) and key is not null) (type: boolean)

bucketsort_optimize_insert_7.q ("is not null" is unnecessary)

predicate: (((key < 8) and key is not null) and ((key = 0) or (key = 5))) (type: boolean)

Issue Links

• relates to: HIVE-11028 Tez: table self join and join with another table fails with IndexOutOfBoundsException