[HIVE-20792] Inserting timestamp with zones truncates the data

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Serializers/Deserializers
• Assignee: Jaume M
• Reporter: Jaume M
• Created: 23/Oct/18 21:45
• Updated: 27/Feb/24 22:23
• Resolved: 28/Oct/18 15:25

Description

For example with the table:

CREATE TABLE myTable
(
a TIMESTAMP
)
STORED AS ORC
tblproperties("transactional"="true");

The following inserts store the wrong data:

INSERT INTO myTable VALUES("2018-10-19 10:35:00 UTC"); -> 2018-10-19 00:00:00.0
INSERT INTO myTable VALUES("2018-10-19 10:35:00 ZZZ"); -> 2018-10-19 00:00:00.0

The second one should fail since ZZZ is not a time zone.
Similarly if the column is of type DATE,

INSERT INTO myTableDate VALUES("2018-10-19 AAAA"); -> 2018-10-19