[HIVE-14161] from_utc_timestamp()/to_utc_timestamp return incorrect results with EST

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Component/s: UDF
• Assignee: Chaoyu Tang
• Reporter: Chaoyu Tang
• Created: 05/Jul/16 12:27
• Updated: 13/Jul/16 21:55
• Resolved: 13/Jul/16 21:55

Description

hive> SELECT to_utc_timestamp('2016-06-30 06:00:00', 'PST'); 
OK
2016-06-30 13:00:00  ==>Correct, UTC is 7 hours ahead of PST
Time taken: 1.674 seconds, Fetched: 1 row(s)
hive> SELECT to_utc_timestamp('2016-06-30 08:00:00', 'CST');
OK
2016-06-30 13:00:00  ==>Correct, UTC is 5 hours ahead of CST
Time taken: 1.776 seconds, Fetched: 1 row(s)
hive> SELECT to_utc_timestamp('2016-06-30 09:00:00', 'EST');
OK
2016-06-30 14:00:00  ==>Wrong, UTC should be 4 hours ahead of EST
Time taken: 1.686 seconds, Fetched: 1 row(s)
hive> select from_utc_timestamp('2016-06-30 14:00:00', 'EST');
OK
2016-06-30 09:00:00  ==>Wrong, UTC should be 4 hours ahead of EST

It might be something related to daylight savings time.

Issue Links

• is related to: HIVE-12706 Incorrect output from from_utc_timestamp()/to_utc_timestamp when local timezone has DST