You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "ANAND CHINNAKANNAN (JIRA)" <ji...@apache.org> on 2019/01/22 16:23:00 UTC
[jira] [Comment Edited] (SPARK-26677) Incorrect results of
not(eqNullSafe) when data read from Parquet file
[ https://issues.apache.org/jira/browse/SPARK-26677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16748879#comment-16748879 ]
ANAND CHINNAKANNAN edited comment on SPARK-26677 at 1/22/19 4:22 PM:
---------------------------------------------------------------------
I have done the analysis for this bug. Below are the initial analysis
scala> Seq("A", "B", null).toDS.repartition(1).write.parquet("t3");
scala> spark.read.parquet("t3").where(not(col("value").eqNullSafe("A"))).show;
+-----+
|value|
+-----+
| B|
|null|
+-----+
When the issue happens only if the columns have duplicate row data. I will do the research to deep dive in the code
was (Author: anandchinn):
I have done the analysis for this bug. Below are the initial analysis
scala> Seq("A", "B", null).toDS.repartition(1).write.parquet("t3");
scala> spark.read.parquet("t3").where(not(col("value").eqNullSafe("A"))).show;
+-----+
|value|
+-----+
| B|
|null|
+-----+
When the issue happens only if the columns has Duplicate row data. We do the research to understand the code.
> Incorrect results of not(eqNullSafe) when data read from Parquet file
> ----------------------------------------------------------------------
>
> Key: SPARK-26677
> URL: https://issues.apache.org/jira/browse/SPARK-26677
> Project: Spark
> Issue Type: Bug
> Components: Spark Core
> Affects Versions: 2.4.0
> Environment: Local installation of Spark on Linux (Java 1.8, Ubuntu 18.04).
> Reporter: Michal Kapalka
> Priority: Critical
>
> Example code (spark-shell from Spark 2.4.0):
> {code:java}
> scala> Seq("A", "A", null).toDS.repartition(1).write.parquet("t")
> scala> spark.read.parquet("t").where(not(col("value").eqNullSafe("A"))).show
> +-----+
> |value|
> +-----+
> +-----+
> {code}
> Running the same with Spark 2.2.0 or 2.3.2 gives the correct result:
> {code:java}
> scala> spark.read.parquet("t").where(not(col("value").eqNullSafe("A"))).show
> +-----+
> |value|
> +-----+
> | null|
> +-----+
> {code}
> Also, with a different input sequence and Spark 2.4.0 we get the correct result:
> {code:java}
> scala> Seq("A", null).toDS.repartition(1).write.parquet("t")
> scala> spark.read.parquet("t").where(not(col("value").eqNullSafe("A"))).show
> +-----+
> |value|
> +-----+
> | null|
> +-----+
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org