You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "mahesh kumar behera (Jira)" <ji...@apache.org> on 2020/07/23 05:22:00 UTC

[jira] [Created] (HIVE-23904) Update TestMapJoinOperator for adding anti join test cases.

mahesh kumar behera created HIVE-23904:
------------------------------------------

             Summary: Update TestMapJoinOperator for adding anti join test cases.
                 Key: HIVE-23904
                 URL: https://issues.apache.org/jira/browse/HIVE-23904
             Project: Hive
          Issue Type: Bug
            Reporter: mahesh kumar behera
            Assignee: mahesh kumar behera


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)