Cheng Lian created SPARK-6319:
---------------------------------
Summary: DISTINCT doesn't work for binary type
Key: SPARK-6319
URL: https://issues.apache.org/jira/browse/SPARK-6319
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.2.1, 1.1.1, 1.0.2, 1.3.0
Reporter: Cheng Lian
Spark shell session for reproduction:
{noformat}
scala> import sqlContext.implicits._
scala> import org.apache.spark.sql.types._
scala> Seq(1, 1, 2, 2).map(i => Tuple1(i.toString)).toDF("c").select($"c" cast
BinaryType).distinct.show()
...
CAST(c, BinaryType)
[B@43f13160
[B@5018b648
[B@3be22500
[B@476fc8a1
{noformat}
Spark SQL uses plain byte arrays to represent binary values. However, arrays
are compared by reference rather than by value. On the other hand, the DISTINCT
operator uses a {{HashSet}} and its {{.contains}} method to check for
duplicated values. These two facts together cause the problem.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
