You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2014/10/21 03:22:34 UTC
[jira] [Updated] (HIVE-8531) Fold is not null filter if there are
other comparison filter present on table
[ https://issues.apache.org/jira/browse/HIVE-8531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan updated HIVE-8531:
-----------------------------------
Attachment: HIVE-8531.patch
> 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
> 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)