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