[
https://issues.apache.org/jira/browse/HIVE-17278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16119455#comment-16119455
]
Leela Krishna commented on HIVE-17278:
--------------------------------------
HIVE-12706 resolution still causes issues when GMT timestamp hours are equal to
local timezone DST hours.
> 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)
