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