[HIVE-7449] from_utc_timestamp and to_utc_timestamp not returning right values

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.10.0, 0.12.0
• Assignee: Unassigned
• Reporter: Mala Chikka Kempanna
• Created: 18/Jul/14 23:38
• Updated: 17/Dec/15 20:09
• Resolved: 17/Dec/15 20:09

Description

Tested it out like below

1.Get UTC and local time
date -u
Fri Jul 18 18:15:29 UTC 2014

Local time
date
Fri Jul 18 11:15:32 PDT 2014

2. Conversion output on HIVE 0.10.0 and HIVE 0.12.0
From UTC to local
SELECT from_utc_timestamp('2014-07-18 18:15:29.0','PDT') FROM sample_07 LIMIT 1;

2014-07-18 18:15:29 - Wrong output , it is supposed to be 2014-07-18 11:15:32

From local to utc

SELECT to_utc_timestamp('2014-07-18 11:15:32.0','PDT') FROM sample_07 LIMIT 1;

2014-07-18 11:15:32 - Wrong output , it is supposed to be 2014-07-18 18:15:29