pyspark AnalysisException: "Reference '' is ambiguous

Asked May 01 '18 at 04:35

Active May 01 '18 at 11:22

Viewed 417 times

I am trying to list the column in a dataframe but i am getting an ambiguous column error.

$df.printSchema()
root
 |-- ACTION: string (nullable = true)

$df_new.select(["ACTION"]).show()
AnalysisException: "Reference 'ACTION' is ambiguous, could be: ACTION#22058, ACTION#22334

edited May 01 '18 at 11:22

zero323

322,348
103
959
935

asked May 01 '18 at 04:35

Sun

1,855
5
21
26

1

Where's `df_new`'s schema? Is it a product of a self-join or of a join that duplicated column names? – ernest_k May 01 '18 at 06:27
1

Your df_new has 2 columns named ACTION – pissall May 01 '18 at 09:34

pyspark AnalysisException: "Reference '' is ambiguous

0 Answers0