Mala Chikka Kempanna created HIVE-7449:
------------------------------------------
Summary: from_utc_timestamp and to_utc_timestamp not returning
right values
Key: HIVE-7449
URL: https://issues.apache.org/jira/browse/HIVE-7449
Project: Hive
Issue Type: Bug
Affects Versions: 0.12.0, 0.10.0
Reporter: Mala Chikka Kempanna
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
--
This message was sent by Atlassian JIRA
(v6.2#6252)
