Leela Krishna created HIVE-17278:
------------------------------------
Summary: Incorrect output timestamp from
from_utc_timestamp()/to_utc_timestamp when local timezone has DST
Key: HIVE-17278
URL: https://issues.apache.org/jira/browse/HIVE-17278
Project: Hive
Issue Type: Bug
Components: UDF
Affects Versions: 2.0.0
Reporter: Leela Krishna
HIVE-12706 is resolved but there is still a bug in this - from_utc_timestamp()
is interpreting a GMT timestamp with DST.
HS2 on PST timezone:
GMT timestamp PST timestamp PST 2GMT
2012-03-11 01:30:15.332 2012-03-10 17:30:15.332 2012-03-11 01:30:15.332
2012-03-11 02:30:15.332 2012-03-10 19:30:15.332 2012-03-11 03:30:15.332 (<---
We got 1 hour more on GMT)
PSTtimestap is generated using from_utc_timestamp('2012-03-11 02:30:15.332',
'PST')
PST2GMT timestamp is generated using
to_utc_timestamp(from_utc_timestamp('2012-03-11 02:30:15.332', 'PST'), 'PST')
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
