[
https://issues.apache.org/jira/browse/HIVE-23903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Panagiotis Garefalakis reassigned HIVE-23903:
---------------------------------------------
Assignee: Panagiotis Garefalakis (was: mahesh kumar behera)
> Support "not-in" for bloom filter
> ---------------------------------
>
> Key: HIVE-23903
> URL: https://issues.apache.org/jira/browse/HIVE-23903
> Project: Hive
> Issue Type: Bug
> Reporter: mahesh kumar behera
> Assignee: Panagiotis Garefalakis
> Priority: Major
>
> In case of anti join, bloom filter can be created on left side also ("IN
> (keylist right table)").But the filter should be "not-in" ("NOT IN (keylist
> right table)") as we want to select the records from left side which are not
> present in the right side. But it may cause wrong result as bloom filter may
> have false positive and thus simply adding not is not correct, special
> handling is required for "NOT IN".
> [https://github.com/jmhodges/opposite_of_a_bloom_filter/]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
