Spark SQL Joins - Left Anti Join

2022-05-31 sparkspark-sql

This diagram shows Left Anti Join type in Spark SQL. An anti join returns returns values from the left relation that has no match with the right. It is also called left anti 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]
4
[Not supported by viewer]
X
[Not supported by viewer]
2022-01-04
[Not supported by viewer]
B
[Not supported by viewer]
A
[Not supported by viewer]