[ https://issues.apache.org/jira/browse/HIVE-8531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan updated HIVE-8531: ----------------------------------- Status: Open (was: Patch Available) > 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.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)