[
https://issues.apache.org/jira/browse/HIVE-11044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jason Dere updated HIVE-11044:
------------------------------
Attachment: HIVE-11044.1.patch
Initial patch, running ConstantPropagate one additional time after
PartitionPruner during Optimizer.initialize().
The qfile updates show removal of unnecessary predicates, either (constant =
constant), or (column is not null) when there are additional predicates on the
column, along with updated stats due to the removal of the predicates.
Will need to update this patch for test explainuser_2.q, once HIVE-11028 is
committed.
> Some optimizable predicates being missed by constant propagation
> ----------------------------------------------------------------
>
> Key: HIVE-11044
> URL: https://issues.apache.org/jira/browse/HIVE-11044
> Project: Hive
> Issue Type: Bug
> Components: Query Planning
> Reporter: Jason Dere
> Assignee: Jason Dere
> Attachments: HIVE-11044.1.patch
>
>
> 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:
> {noformat}
> filterExpr: ((12.0 = 12.0) and (UDFToDouble(key) < 10.0)) (type: boolean)
> {noformat}
> join28.q:
> {noformat}
> predicate: ((11.0 = 11.0) and key is not null) (type: boolean)
> {noformat}
> bucketsort_optimize_insert_7.q ("is not null" is unnecessary)
> {noformat}
> predicate: (((key < 8) and key is not null) and ((key = 0) or (key = 5)))
> (type: boolean)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
