[
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
