apache-sparkapache-spark-sql

Is there a difference between OUTER & FULL_OUTER in Spark SQL?

Spark SQL documentation specifies that join() supports the following join types:

Must be one of: inner, cross, outer, full, full_outer, left, left_outer, right, right_outer, left_semi, and left_anti.

Spark SQL Join()

Is there any difference between outer and full_outer? I suspect not, I suspect they are just synonyms for each other, but wanted to get clarity.

Solution

  • There is no difference between outer and full_outer - they are the same. See the following answer for a demonstration: What are the various join types in Spark?