[
https://issues.apache.org/jira/browse/SPARK-17211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15435745#comment-15435745
]
Himanish Kushary commented on SPARK-17211:
------------------------------------------
I ran the following in a Databricks environment with Spark 2.0. Works fine.
{code:java}
import spark.implicits._
val a1 = Array((123,1),(234,2),(432,5))
val a2 = Array(("abc",1),("bcd",2),("dcb",5))
val df1 = sc.parallelize(a1).toDF("gid","id")
val df2 = sc.parallelize(a2).toDF("gname","id")
df1.join(df2,"id").show() // WORKS
+---+---+-----+
| id|gid|gname|
+---+---+-----+
| 5|432| dcb|
| 2|234| bcd|
| 1|123| abc|
+---+---+-----+
df1.join(broadcast(df2),"id").show() // BROADCASTING - DOES NOT WORK on EMR
+---+---+-----+
| id|gid|gname|
+---+---+-----+
| 1|123| null|
| 2|234| null|
| 5|432| null|
+---+---+-----+
broadcast(df1).join(df2,"id").show() // BROADCASTING - DOES NOT WORK on EMR
{code}
> Broadcast join produces incorrect results
> -----------------------------------------
>
> Key: SPARK-17211
> URL: https://issues.apache.org/jira/browse/SPARK-17211
> Project: Spark
> Issue Type: Bug
> Components: PySpark
> Affects Versions: 2.0.0
> Reporter: Jarno Seppanen
>
> Broadcast join produces incorrect columns in join result, see below for an
> example. The same join but without using broadcast gives the correct columns.
> Running PySpark on YARN on Amazon EMR 5.0.0.
> {noformat}
> import pyspark.sql.functions as func
> keys = [
> (54000000, 0),
> (54000001, 1),
> (54000002, 2),
> ]
> keys_df = spark.createDataFrame(keys, ['key_id', 'value']).coalesce(1)
> keys_df.show()
> # +--------+-----+
> # | key_id|value|
> # +--------+-----+
> # |54000000| 0|
> # |54000001| 1|
> # |54000002| 2|
> # +--------+-----+
> data = [
> (54000002, 1),
> (54000000, 2),
> (54000001, 3),
> ]
> data_df = spark.createDataFrame(data, ['key_id', 'foo'])
> data_df.show()
> # +--------+---+
>
> # | key_id|foo|
> # +--------+---+
> # |54000002| 1|
> # |54000000| 2|
> # |54000001| 3|
> # +--------+---+
> ### INCORRECT ###
> data_df.join(func.broadcast(keys_df), 'key_id').show()
> # +--------+---+--------+
>
> # | key_id|foo| value|
> # +--------+---+--------+
> # |54000002| 1|54000002|
> # |54000000| 2|54000000|
> # |54000001| 3|54000001|
> # +--------+---+--------+
> ### CORRECT ###
> data_df.join(keys_df, 'key_id').show()
> # +--------+---+-----+
> # | key_id|foo|value|
> # +--------+---+-----+
> # |54000000| 2| 0|
> # |54000001| 3| 1|
> # |54000002| 1| 2|
> # +--------+---+-----+
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
