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
