Hi all, So I Have two dataframes, with two columns: DATE and VALUE.
Performing this: data = data.join(cur_data, data("DATE") === cur_data("DATE"), "outer") returns Exception in thread "main" org.apache.spark.sql.AnalysisException: Reference 'DATE' is ambiguous, could be: DATE#0, DATE#3.; But if I change one of the column names, I will get two columns and won't really merge "DATE" column as I wish. Any ideas without going to non trivial procedures? Thanks, Saif