You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Xinrong Meng (Jira)" <ji...@apache.org> on 2023/02/01 03:35:00 UTC

[jira] [Created] (SPARK-42267) Support left_outer join

Xinrong Meng created SPARK-42267:
------------------------------------

             Summary: Support left_outer join
                 Key: SPARK-42267
                 URL: https://issues.apache.org/jira/browse/SPARK-42267
             Project: Spark
          Issue Type: Sub-task
          Components: Connect, PySpark
    Affects Versions: 3.4.0
            Reporter: Xinrong Meng


```
>>> df = spark.range(1)
>>> df2 = spark.range(2)
>>> df.join(df2, how="left_outer")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Users/xinrong.meng/spark/python/pyspark/sql/connect/dataframe.py", line 438, in join
    plan.Join(left=self._plan, right=other._plan, on=on, how=how),
  File "/Users/xinrong.meng/spark/python/pyspark/sql/connect/plan.py", line 730, in __init__
    raise NotImplementedError(
NotImplementedError: 
                Unsupported join type: left_outer. Supported join types include:
                "inner", "outer", "full", "fullouter", "full_outer",
                "leftouter", "left", "left_outer", "rightouter",
                "right", "right_outer", "leftsemi", "left_semi",
                "semi", "leftanti", "left_anti", "anti", "cross",
```



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org