You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Nathan Howell (JIRA)" <ji...@apache.org> on 2015/03/05 00:56:38 UTC

[jira] [Created] (HIVE-9862) Vectorized execution corrupts timestamp values

Nathan Howell created HIVE-9862:
-----------------------------------

             Summary: 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
            Assignee: Jitendra Nath Pandey


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)