You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Mala Chikka Kempanna (JIRA)" <ji...@apache.org> on 2014/07/19 01:38:39 UTC
[jira] [Created] (HIVE-7449) from_utc_timestamp and
to_utc_timestamp not returning right values
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)