hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mala Chikka Kempanna (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-7449) from_utc_timestamp and to_utc_timestamp not returning right values
Date Fri, 18 Jul 2014 23:38:39 GMT
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)

Mime
View raw message