Spark SQL Joins - Inner Join

2022-05-31 sparkspark-sql

This diagram shows Inner Join type in Spark SQL. It returns rows that have matching values in both tables (relations).

References

JOIN - Spark 3.2.1 Documentation (apache.org)

A
[Not supported by viewer]
B
[Not supported by viewer]
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]
3
[Not supported by viewer]
I
[Not supported by viewer]
2022-01-03
[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]
1
[Not supported by viewer]
I
[Not supported by viewer]
2022-01-01
[Not supported by viewer]
Individual
[Not supported by viewer]