Ashutosh Chauhan created HIVE-8531:
--------------------------------------
Summary: Fold is not null filter if there are other comparison
filter present on table
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
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)