outer join in sql column data from tables where no matching rows were found code example
Example: Returns all the records as a list of Row
# Returns all the records as a list of Row
df.collect()
# [Row(age=2, name=u'Alice'), Row(age=5, name=u'Bob')]