Ryan Blue created HIVE-12194:
--------------------------------

             Summary: Incorrect result when using from_utc_timestamp with the 
local time zone.
                 Key: HIVE-12194
                 URL: https://issues.apache.org/jira/browse/HIVE-12194
             Project: Hive
          Issue Type: Sub-task
          Components: Hive
    Affects Versions: 1.1.1
            Reporter: Ryan Blue


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

{code}
// 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
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to