Spark SQL Joins - Right Outer Join

2022-05-31 sparkspark-sql

This diagram shows Right Join type in Spark SQL. It returns all values from the right relation and the matched values from the left relation, or appends NULL if there is no match. It is also called right outer join.

References

JOIN - Spark 3.2.1 Documentation (apache.org)

Customer ID
[Not supported by viewer]
Type Code
[Not supported by viewer]
Register Date
[Not supported by viewer]
1
[Not supported by viewer]
I
[Not supported by viewer]
2022-01-01
[Not supported by viewer]
2
[Not supported by viewer]
O
[Not supported by viewer]
2022-01-02
[Not supported by viewer]
3
[Not supported by viewer]
I
[Not supported by viewer]
2022-01-03
[Not supported by viewer]
4
[Not supported by viewer]
X
[Not supported by viewer]
2022-01-04
[Not supported by viewer]
Type Code
[Not supported by viewer]
Type Name
[Not supported by viewer]
I
[Not supported by viewer]
Individual
[Not supported by viewer]
O
[Not supported by viewer]
Organization
[Not supported by viewer]
U
[Not supported by viewer]
Unknown
[Not supported by viewer]
Table A
[Not supported by viewer]
Table B
[Not supported by viewer]
Merged Table C
[Not supported by viewer]
Customer ID
[Not supported by viewer]
Type Code
[Not supported by viewer]
Register Date
[Not supported by viewer]
Type Name
[Not supported by viewer]
1
[Not supported by viewer]
I
[Not supported by viewer]
2022-01-01
[Not supported by viewer]
Individual
[Not supported by viewer]
2
[Not supported by viewer]
O
[Not supported by viewer]
2022-01-02
[Not supported by viewer]
Organization
[Not supported by viewer]
3
[Not supported by viewer]
I
[Not supported by viewer]
2022-01-03
[Not supported by viewer]
Individual
[Not supported by viewer]
NULL
[Not supported by viewer]
U
[Not supported by viewer]
NULL
[Not supported by viewer]
Unknown
[Not supported by viewer]
A
[Not supported by viewer]
B
[Not supported by viewer]