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)

Reply via email to