[
https://issues.apache.org/jira/browse/HIVE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13815285#comment-13815285
]
Eugene Koifman commented on HIVE-5583:
--------------------------------------
Doesn't SQL use 3-valued logic when dealing with NULLs?
1 = null is UNKNOWN, so that NOT(1 = null) is UNKNOWN but if you take 1 = null
to mean FALSE, then NOT(1 = null) is TRUE. So removing all NULLs from IN
clause list would affect the result if no non-null values from the list matched.
> Implement support for IN (list-of-constants) filter in vectorized mode
> ----------------------------------------------------------------------
>
> Key: HIVE-5583
> URL: https://issues.apache.org/jira/browse/HIVE-5583
> Project: Hive
> Issue Type: Sub-task
> Components: Query Processor
> Affects Versions: 0.13.0
> Reporter: Eric Hanson
> Assignee: Eric Hanson
> Fix For: 0.13.0
>
> Attachments: HIVE-5583.1.patch.txt, HIVE-5583.3.patch,
> HIVE-5583.4.patch
>
>
> Implement optimized, vectorized support for filters of this form:
> column IN (constant1, ... constantN)
--
This message was sent by Atlassian JIRA
(v6.1#6144)
