[jira] [Commented] (HIVE-11044) Some optimizable predicates being missed by constant propagation

["Ashutosh Chauhan (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-11044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14594078#comment-14594078 ] 

Ashutosh Chauhan commented on HIVE-11044:
-----------------------------------------

+1

> 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, HIVE-11044.2.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)