[HIVE-17278] Incorrect output timestamp from from_utc_timestamp()/to_utc_timestamp when local timezone has DST

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.0.0
• Component/s: UDF
• Labels: timestamp
• Target Version/s: 3.0.0
• Assignee: Unassigned
• Reporter: Leela Krishna
• Created: 09/Aug/17 06:05
• Updated: 04/Dec/17 16:49

Description

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

Issue Links

• Parent Feature: HIVE-12706 Incorrect output from from_utc_timestamp()/to_utc_timestamp when local timezone has DST