[SPARK-32594] Insert wrong dates to Hive tables

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.1, 3.1.0
• Fix Version/s: 3.0.1, 3.1.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 11/Aug/20 20:18
• Updated: 12/Dec/22 18:10
• Resolved: 12/Aug/20 04:33

Description

Run spark-sql -S:

spark-sql> CREATE TABLE table1 (d date);
20/08/11 23:17:20 WARN HiveMetaStore: Location: file:/Users/maximgekk/proj/insert-date-into-hive-table/spark-warehouse/table1 specified for non-external table:table1
spark-sql> INSERT INTO table1 VALUES (date '2020-08-11');
spark-sql> SELECT * FROM table1;
1970-01-01

The expected result of the last statement is 2020-08-11 but got 1970-01-01.

Issue Links

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