[ https://issues.apache.org/jira/browse/HIVE-8531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan updated HIVE-8531: ----------------------------------- Resolution: Fixed Fix Version/s: 0.15.0 Status: Resolved (was: Patch Available) Added comments & committed to trunk. [~vikram.dixit] ok 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)