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

Posted to dev@hive.apache.org by "John Sherman (Jira)" <ji...@apache.org> on 2023/01/12 16:24:00 UTC

[jira] [Created] (HIVE-26938) Investigate SMB Map Join for FULL OUTER

John Sherman created HIVE-26938:
-----------------------------------

             Summary: Investigate SMB Map Join for FULL OUTER
                 Key: HIVE-26938
                 URL: https://issues.apache.org/jira/browse/HIVE-26938
             Project: Hive
          Issue Type: Improvement
          Components: HiveServer2
            Reporter: John Sherman
            Assignee: John Sherman


HIVE-18908 added FULL OUTER Map Join support but this work did not add support for SMB Map Joins for FULL OUTER.

We should investigate if we can safely support SMB Map Join for this scenario and implement it if so.

This is the area in which it gives up conversion, if we modify this line to pass a 2nd argument  of true to getBigTableCandidates to enable isFullOuterJoinSupported - it does successfully convert (but we need to verify that execution does the correct thing).

[https://github.com/apache/hive/blob/03ad025ada776c0d359124c6342615f1983c1a94/ql/src/java/org/apache/hadoop/hive/ql/optimizer/ConvertJoinMapJoin.java#L482]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)