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)