You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Apache Spark (Jira)" <ji...@apache.org> on 2021/04/18 01:31:00 UTC
[jira] [Commented] (SPARK-35118) Propagate empty relation through
Join if join condition is empty
[ https://issues.apache.org/jira/browse/SPARK-35118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17324380#comment-17324380 ]
Apache Spark commented on SPARK-35118:
--------------------------------------
User 'wangyum' has created a pull request for this issue:
https://github.com/apache/spark/pull/32216
> Propagate empty relation through Join if join condition is empty
> ----------------------------------------------------------------
>
> Key: SPARK-35118
> URL: https://issues.apache.org/jira/browse/SPARK-35118
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.2.0
> Reporter: Yuming Wang
> Priority: Major
>
> {code:scala}
> spark.sql("create table t1 using parquet as select id as a, id as b from range(10)")
> spark.sql("create table t2 using parquet as select id as a, id as b from range(20)")
> spark.sql("select t1.a from t1 left semi join t2").explain(true)
> {code}
> Current plan:
> {noformat}
> == Optimized Logical Plan ==
> Join LeftSemi
> :- Project [a#6L]
> : +- Relation default.t1[a#6L,b#7L] parquet
> +- Project
> +- Relation default.t2[a#8L,b#9L] parquet
> {noformat}
> Excepted plan:
> {noformat}
> == Optimized Logical Plan ==
> Project [a#6L]
> +- Relation default.t1[a#6L,b#7L] parquet
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org