hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-8531) Fold is not null filter if there are other comparison filter present on same column
Date Wed, 22 Oct 2014 14:59:33 GMT

    [ https://issues.apache.org/jira/browse/HIVE-8531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14179990#comment-14179990
] 

Harish Butani commented on HIVE-8531:
-------------------------------------

lgtm +1
only thing, could you add a comment explaining the new behavior in ConstantPropagation.

> 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.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)

Mime
View raw message