[SPARK-31641] Incorrect days conversion by JSON legacy parser

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0, 3.1.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 05/May/20 08:57
• Updated: 05/May/20 14:51
• Resolved: 05/May/20 14:16

Description

Spark 2.4.5:

scala> val ds = Seq("{'d': '-141704'}").toDS
ds: org.apache.spark.sql.Dataset[String] = [value: string]

scala> val json = spark.read.schema("d date").json(ds)
json: org.apache.spark.sql.DataFrame = [d: date]

scala> json.show
+----------+
|         d|
+----------+
|1582-01-01|
+----------+

Spark 3.1.0-SNAPSHOT:

scala> val ds = Seq("{'d': '-141704'}").toDS
ds: org.apache.spark.sql.Dataset[String] = [value: string]

scala> val json = spark.read.schema("d date").json(ds)
json: org.apache.spark.sql.DataFrame = [d: date]

scala> json.show
+----------+
|         d|
+----------+
|1582-01-11|
+----------+

Issue Links

• links to: [Github] Pull Request #28453 (MaxGekk)
• links to: [Github] Pull Request #28453 (MaxGekk)