orc-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Markus Steindl (JIRA)" <j...@apache.org>
Subject [jira] [Created] (ORC-457) If a timestamp is inserted using INSERT INTO ... SELECT and selected again the value is shifted
Date Tue, 08 Jan 2019 10:13:00 GMT
Markus Steindl created ORC-457:
----------------------------------

             Summary: If a timestamp is inserted using INSERT INTO ... SELECT and selected
again the value is shifted
                 Key: ORC-457
                 URL: https://issues.apache.org/jira/browse/ORC-457
             Project: ORC
          Issue Type: Bug
            Reporter: Markus Steindl


We don't get the original timestamp in the following example.
The timestamp is shifted precisely by the UTC Offset

CREATE TABLE `timestamp_test_orc_2`(
 `ts_double` double,
 `ts` timestamp)
 stored as orc

insert into timestamp_test_orc_2
select * from (select 1.5e9, cast(1.5e9 as timestamp)) t;

select ts, cast(ts_double as timestamp), cast(ts as double) - ts_double from timestamp_test_orc_2;

-- 2017-07-14 04:40:00     2017-07-14 02:40:00     7200.0



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message