[jira] [Resolved] (HIVE-14161) from_utc_timestamp()/to_utc_timestamp return incorrect results with EST

["Chaoyu Tang (JIRA)" <ji...@apache.org>]

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

Chaoyu Tang resolved HIVE-14161.
--------------------------------
    Resolution: Not A Problem

I do not think it is a bug since different IDs with a TimeZone can have different DTS behavior.

> 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)