[
https://issues.apache.org/jira/browse/HIVE-8531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14180431#comment-14180431
]
Vikram Dixit K commented on HIVE-8531:
--------------------------------------
+1 for 0.14
> 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
> Fix For: 0.15.0
>
> 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)
