Jason Dere created HIVE-12706:
---------------------------------
Summary: Incorrect output from
from_utc_timestamp()/to_utc_timestamp when local timezone has DST
Key: HIVE-12706
URL: https://issues.apache.org/jira/browse/HIVE-12706
Project: Hive
Issue Type: Bug
Components: UDF
Reporter: Jason Dere
Assignee: Jason Dere
Getting wrong output with the local timezone set to PST (which has DST). I
don't think this happens when the local timezone does not observe DST.
{noformat}
select from_utc_timestamp('2015-03-28 17:00:00', 'Europe/London')
2015-03-28 17:00:00
select from_utc_timestamp('2015-03-28 18:00:00', 'Europe/London')
2015-03-28 19:00:00 <= Wrong, should be 2015-03-28 18:00:00
select from_utc_timestamp('2015-03-28 19:00:00', 'Europe/London')
2015-03-28 20:00:00 <= Wrong, should be 2015-03-28 19:00:00
{noformat}
Also to_utc_timestamp():
{noformat}
select to_utc_timestamp('2015-03-28 17:00:00', 'Europe/London')
2015-03-28 17:00:00
select to_utc_timestamp('2015-03-28 18:00:00', 'Europe/London')
2015-03-28 17:00:00 <= Wrong
select to_utc_timestamp('2015-03-28 19:00:00', 'Europe/London')
2015-03-28 18:00:00 <= Wrong
select to_utc_timestamp('2015-03-28 20:00:00', 'Europe/London')
2015-03-28 19:00:00 <= Wrong
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
