You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@orc.apache.org by "Markus Steindl (JIRA)" <ji...@apache.org> on 2019/01/08 10:20:00 UTC
[jira] [Updated] (ORC-457) If a timestamp is inserted using INSERT
INTO ... SELECT and selected again the value is shifted
[ https://issues.apache.org/jira/browse/ORC-457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Markus Steindl updated ORC-457:
-------------------------------
Description:
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}}
was:
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
> 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
> Priority: Major
>
> 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)