[HIVE-9862] Vectorized execution corrupts timestamp values

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.3.0, 2.0.1, 2.1.0
• Component/s: Vectorization
• Target Version/s: 2.0.1
• Assignee: Matt McCline
• Reporter: Nathan Howell
• Created: 04/Mar/15 23:55
• Updated: 21/Jun/16 15:53
• Resolved: 09/Feb/16 19:17

Description

Timestamps in the future (year 2250?) and before ~1700 are silently corrupted in vectorized execution mode. Simple repro:

hive> DROP TABLE IF EXISTS test;
hive> CREATE TABLE test(ts TIMESTAMP) STORED AS ORC;
hive> INSERT INTO TABLE test VALUES ('9999-12-31 23:59:59');

hive> SET hive.vectorized.execution.enabled = false;
hive> SELECT MAX(ts) FROM test;
9999-12-31 23:59:59

hive> SET hive.vectorized.execution.enabled = true;
hive> SELECT MAX(ts) FROM test;
1816-03-30 05:56:07.066277376

Issue Links

• is related to: HIVE-13111 Fix timestamp / interval_day_time wrong results with HIVE-9862
• links to: RB #42108
• mentioned in: Wiki Page Loading...