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

Reply via email to