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)