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

Harish Butani commented on HIVE-8531:
-------------------------------------

lgtm +1
only thing, could you add a comment explaining the new behavior in 
ConstantPropagation.

> Fold is not null filter if there are other comparison filter present on same 
> column
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-8531
>                 URL: https://issues.apache.org/jira/browse/HIVE-8531
>             Project: Hive
>          Issue Type: New Feature
>          Components: Logical Optimizer
>    Affects Versions: 0.14.0
>            Reporter: Ashutosh Chauhan
>            Assignee: Ashutosh Chauhan
>         Attachments: HIVE-8531.1.patch, HIVE-8531.1.patch, HIVE-8531.patch
>
>
> e.g., select * from src where key = '86' and key is not null;
> is equivalent to
> select * from src where key = '86';
> we can short circuit is not null filter and avoid its evaluation for every 
> row at runtime.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to