Spark SQL Joins - Full Outer Join

This diagram shows Full Join type in Spark SQL. It returns all values from both relations, appending NULL values on the side that does not have a match. It is also called full outer join.

References

JOIN - Spark 3.2.1 Documentation (apache.org)