Ahh, My mistake I'm think, as the data came from SQL, one of the column is
char(7) but not all characters are occuped, and the join was with a column
varchar(30), so what what append was the comparison looks like "xx
"=="xx", apply trim to char column works.
On Thu, Jun 23, 2016 at 2:57 PM, Andrés Ivaldi <iaiva...@gmail.com> wrote:
> 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
>
--
Ing. Ivaldi Andres
