spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Apache Spark (Jira)" <j...@apache.org>
Subject [jira] [Commented] (SPARK-32767) Bucket join should work if spark.sql.shuffle.partitions larger than bucket number
Date Tue, 01 Sep 2020 16:56:00 GMT

    [ https://issues.apache.org/jira/browse/SPARK-32767?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17188639#comment-17188639
] 

Apache Spark commented on SPARK-32767:
--------------------------------------

User 'wangyum' has created a pull request for this issue:
https://github.com/apache/spark/pull/29612

> Bucket join should work if spark.sql.shuffle.partitions larger than bucket number
> ---------------------------------------------------------------------------------
>
>                 Key: SPARK-32767
>                 URL: https://issues.apache.org/jira/browse/SPARK-32767
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 3.1.0
>            Reporter: Yuming Wang
>            Priority: Major
>
> How to reproduce this issue:
> {code:scala}
>     spark.range(1000).write.bucketBy(500, "id").saveAsTable("t1")
>     spark.range(1000).write.bucketBy(50, "id").saveAsTable("t2")
>     sql("set spark.sql.shuffle.partitions=600")
>     sql("set spark.sql.autoBroadcastJoinThreshold=-1")
>     sql("select * from t1 join t2 on t1.id = t2.id").explain()
> {code}



--
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


Mime
View raw message