Hi, Try this one:
df_join = df1.*join*(df2, 'Id', "fullouter") Thanks, Bijay On Tue, May 17, 2016 at 9:39 AM, ram kumar <ramkumarro...@gmail.com> wrote: > Hi, > > I tried to join two dataframe > > df_join = df1.*join*(df2, ((df1("Id") === df2("Id")), "fullouter") > > df_join.registerTempTable("join_test") > > > When querying "Id" from "join_test" > > 0: jdbc:hive2://> *select Id from join_test;* > *Error*: org.apache.spark.sql.AnalysisException: Reference 'Id' is > *ambiguous*, could be: Id#128, Id#155.; line 1 pos 7 (state=,code=0) > 0: jdbc:hive2://> > > Is there a way to merge the value of df1("Id") and df2("Id") into one "Id" > > Thanks >