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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0
• Component/s: UDF
• Assignee: Jason Dere Assign to me
• Reporter: Jason Dere
• Created: 17/Dec/15 20:07
• Updated: 09/Aug/17 06:07
• Resolved: 05/Jan/16 00:24

Description

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.

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

Also to_utc_timestamp():

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

Issue Links

• Parent Feature: HIVE-17278 Incorrect output timestamp from from_utc_timestamp()/to_utc_timestamp when local timezone has DST
• relates to: HIVE-14161 from_utc_timestamp()/to_utc_timestamp return incorrect results with EST