hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Dere (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-11044) Some optimizable predicates being missed by constant propagation
Date Thu, 18 Jun 2015 20:37:01 GMT

     [ 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)

Mime
View raw message