hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chaoyu Tang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14161) from_utc_timestamp()/to_utc_timestamp return incorrect results with EST
Date Mon, 11 Jul 2016 14:39:11 GMT

    [ https://issues.apache.org/jira/browse/HIVE-14161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15370893#comment-15370893
] 

Chaoyu Tang commented on HIVE-14161:
------------------------------------

It seems to related to TimeZone ID (EST) used. For a given timezone like GMT-5 there might
be multiple associated timezone IDs such as EST, EST5EDT, America/New_York, US/Eastern etc.
These IDs differ in DST (daylight saving time) behavior. EST does not factor in DTS, but EST5EDT
does. So:
SELECT to_utc_timestamp('2016-06-30 09:00:00', 'EST'); still returns 2016-06-30 14:00:00.0

and
SELECT to_utc_timestamp('2016-06-30 09:00:00', 'EST5EDT'); returns 2016-06-30 13:00:00
SELECT from_utc_timestamp('2016-06-30 13:00:00', 'EST5EDT'); returns 2016-06-30 09:00:00

> from_utc_timestamp()/to_utc_timestamp return incorrect results with EST
> -----------------------------------------------------------------------
>
>                 Key: HIVE-14161
>                 URL: https://issues.apache.org/jira/browse/HIVE-14161
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>            Reporter: Chaoyu Tang
>            Assignee: Chaoyu Tang
>
> {code}
> hive> SELECT to_utc_timestamp('2016-06-30 06:00:00', 'PST'); 
> OK
> 2016-06-30 13:00:00  ==>Correct, UTC is 7 hours ahead of PST
> Time taken: 1.674 seconds, Fetched: 1 row(s)
> hive> SELECT to_utc_timestamp('2016-06-30 08:00:00', 'CST');
> OK
> 2016-06-30 13:00:00  ==>Correct, UTC is 5 hours ahead of CST
> Time taken: 1.776 seconds, Fetched: 1 row(s)
> hive> SELECT to_utc_timestamp('2016-06-30 09:00:00', 'EST');
> OK
> 2016-06-30 14:00:00  ==>Wrong, UTC should be 4 hours ahead of EST
> Time taken: 1.686 seconds, Fetched: 1 row(s)
> hive> select from_utc_timestamp('2016-06-30 14:00:00', 'EST');
> OK
> 2016-06-30 09:00:00  ==>Wrong, UTC should be 4 hours ahead of EST
> {code}
> It might be something related to daylight savings time.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message