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/24 03:57:00 UTC

[jira] [Created] (HIVE-23921) Support HiveJoinProjectTransposeRule for Anti Join

mahesh kumar behera created HIVE-23921:
------------------------------------------

             Summary: Support HiveJoinProjectTransposeRule for Anti Join
                 Key: HIVE-23921
                 URL: https://issues.apache.org/jira/browse/HIVE-23921
             Project: Hive
          Issue Type: Bug
            Reporter: mahesh kumar behera
            Assignee: mahesh kumar behera


 If we have a PK-FK join that is only appending columns to the FK side, it basically means it is not filtering anything (everything is matching). If that is the case, then ANTIJOIN result would be empty. We could detect this at planning time and trigger the rewriting.

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)