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)
