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)

Reply via email to