hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Howell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-9862) Vectorized execution corrupts timestamp values
Date Wed, 04 Mar 2015 23:56:38 GMT
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)

Mime
View raw message