You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Markus Steindl (JIRA)" <ji...@apache.org> on 2019/01/09 09:21:00 UTC

[jira] [Updated] (HIVE-21101) Hive always interprets UTC timestamps as local when writing to timestamp columns

     [ https://issues.apache.org/jira/browse/HIVE-21101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Markus Steindl updated HIVE-21101:
----------------------------------
    Summary: Hive always interprets UTC timestamps as local when writing to timestamp columns  (was: Hive always interprets UTC timestamps as local)

> Hive always interprets UTC timestamps as local when writing to timestamp columns
> --------------------------------------------------------------------------------
>
>                 Key: HIVE-21101
>                 URL: https://issues.apache.org/jira/browse/HIVE-21101
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Markus Steindl
>            Priority: Major
>
> Assume I want to insert "2017-07-14 02:40:00 UTC" (1500000000 seconds since epoch) into a timestamp column.
> {{create table timestamp_test(ts timestamp)}}
> {{insert into timestamp_test select * from (select 1.5e9) t;}}
> However, Hive writes "2017-07-14 04:40:00" into the CSV.
> I suppose it interprets the timestamp as CET (timezone of the cluster) and converts it to UTC by adding 2 hours.
> Also none of the following works:
> {{insert into timestamp_test select * from (select 1500000000000) t;}}
> {{insert into timestamp_test select * from (select cast(1.5e9 as timestamp)) t;}}
> {{insert into timestamp_test select * from (select cast(cast(1.5e9 as timestamp) as string)) t;}}
> {{insert into timestamp_test select * from (select "2017-07-14 02:40:00") t;}}
> {{insert into timestamp_test select * from (select cast("2017-07-14 02:40:00" as timestamp)) t;}}
> {{insert into timestamp_test select * from (select from_utc_timestamp(1.5e9, "CET")) t;}}
> {{insert into timestamp_test select * from (select from_utc_timestamp(1.5e9, "UTC")) t;}}
> We're using Hive 1.2.1000.2.6.0.3-8.



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