[HIVE-12194] Daylight savings zones are not recognized (PDT, MDT)

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.1.1
• Component/s: Hive
• Labels: timestamp
• Assignee: Unassigned
• Reporter: Ryan Blue
• Created: 15/Oct/15 20:58
• Updated: 26/Oct/17 23:24

Description

When I call the from_utc_timestamp function (or to_utc_timestamp) using my current time zone, the result is incorrect:

// CURRENT SERVER TIME ZONE IS PDT
hive> select to_utc_timestamp('2015-10-13 09:15:34.101', 'PDT');
2015-10-13 09:15:34.101 // NOT CHANGED!
hive> select to_utc_timestamp('2015-10-13 09:15:34.101', 'PST');
2015-10-13 16:15:34.101 // CORRECT VALUE FOR PST

UPDATE: It appears that happens because the daylight savings zones are not recognized.

Issue Links

• relates to: HIVE-12195 Unknown zones should cause an error instead of silently failing