You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jitendra Nath Pandey (JIRA)" <ji...@apache.org> on 2015/06/11 01:38:01 UTC
[jira] [Assigned] (HIVE-9862) Vectorized execution corrupts
timestamp values
[ https://issues.apache.org/jira/browse/HIVE-9862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jitendra Nath Pandey reassigned HIVE-9862:
------------------------------------------
Assignee: (was: Jitendra Nath Pandey)
> Vectorized execution corrupts timestamp values
> ----------------------------------------------
>
> Key: HIVE-9862
> URL: https://issues.apache.org/jira/browse/HIVE-9862
> Project: Hive
> Issue Type: Bug
> Components: Vectorization
> Affects Versions: 1.0.0
> Reporter: Nathan Howell
>
> Timestamps in the future (year 2250?) and before ~1700 are silently corrupted in vectorized execution mode. Simple repro:
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)