extracting required information from two tables using spark and scala : table 1

col1  col2   col3

,,,,  ,,,,   ,,,,

a      p     d

b      q     e

c      r     f

d      s     g

table 2

col1  col2   col3

,,,,  ,,,,   ,,,,

a      m     s

e      q     l


output

col1  col2   col3

,,,,  ,,,,   ,,,,

a      m     d

b      q     e

c      r     f

d      s     g

e      q     l

i created table1 and table2 from csv files and in sql context i tried joining them with full outer join but i could get only the partial answer.



