[SPARK-41812] DataFrame.join: ambiguous column

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: Connect
• Assignee: Ruifeng Zheng
• Reporter: Hyukjin Kwon
• Created: 02/Jan/23 08:19
• Updated: 20/Feb/23 20:18
• Resolved: 13/Feb/23 08:23

Description

File "/.../spark/python/pyspark/sql/connect/column.py", line 106, in pyspark.sql.connect.column.Column.eqNullSafe
Failed example:
    df1.join(df2, df1["value"] == df2["value"]).count()
Exception raised:
    Traceback (most recent call last):
      File "/.../miniconda3/envs/python3.9/lib/python3.9/doctest.py", line 1336, in __run
        exec(compile(example.source, filename, "single",
      File "<doctest pyspark.sql.connect.column.Column.eqNullSafe[4]>", line 1, in <module>
        df1.join(df2, df1["value"] == df2["value"]).count()
      File "/.../spark/python/pyspark/sql/connect/dataframe.py", line 151, in count
        pdd = self.agg(_invoke_function("count", lit(1))).toPandas()
      File "/.../spark/python/pyspark/sql/connect/dataframe.py", line 1031, in toPandas
        return self._session.client.to_pandas(query)
      File "/.../spark/python/pyspark/sql/connect/client.py", line 413, in to_pandas
        return self._execute_and_fetch(req)
      File "/.../spark/python/pyspark/sql/connect/client.py", line 573, in _execute_and_fetch
        self._handle_error(rpc_error)
      File "/.../spark/python/pyspark/sql/connect/client.py", line 619, in _handle_error
        raise SparkConnectAnalysisException(
    pyspark.sql.connect.client.SparkConnectAnalysisException: [AMBIGUOUS_REFERENCE] Reference `value` is ambiguous, could be: [`value`, `value`].

Issue Links

• is duplicated by: SPARK-41823 DataFrame.join creating ambiguous column names
• links to: [Github] Pull Request #39734 (zhengruifeng)
• links to: [Github] Pull Request #39925 (zhengruifeng)
• links to: [Github] Pull Request #40094 (grundprinzip)