Hello, I'v been trying to join ( left_outer) dataframes by two columns, and the result is not as expected.
I'm doing this
dfo1.get.join(dfo2.get,
dfo1.get.col("Col1Left").equalTo(dfo2.get.col("Col1Right")).and(dfo1.get.col("Col2Left").equalTo(dfo2.get.col("Col2Right")))
, "left_outer").head(10).foreach(println)
the result is not the same than sql join, some tuples cant be matched on
right
So I don't know if the way to do the join is the correct.
Regards.
--
Ing. Ivaldi Andres
