hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jitendra Nath Pandey (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4575) In place filtering in Not Filter doesn't handle nulls correctly.
Date Fri, 17 May 2013 22:33:16 GMT

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

Jitendra Nath Pandey commented on HIVE-4575:
--------------------------------------------

bq. I think the repro here in our code is that you'd get 1 & NULL and 3 & NULL returned.

Yes.

Another point is that output of

  select * from t where NOT (a >= 2);

should be same as

  select * from t where (a < 2);

In our current implementation first query will return row 1 and 4, while second will return
only row 1.


                
> In place filtering in Not Filter doesn't handle nulls correctly.
> ----------------------------------------------------------------
>
>                 Key: HIVE-4575
>                 URL: https://issues.apache.org/jira/browse/HIVE-4575
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Jitendra Nath Pandey
>            Assignee: Jitendra Nath Pandey
>
>  The FilterNotExpr evaluates the child expression and takes the compliment of the selected
vector. Since child expression filters out null values, the compliment includes the nulls
in the output. This is incorrect because not(null) = null.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message