Left Outer Join

Spark SQL Left Outer Join (left, left outer, left_outer) returns all rows from the left…