hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-17278) Incorrect output timestamp from from_utc_timestamp()/to_utc_timestamp when local timezone has DST
Date Thu, 26 Oct 2017 23:04:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-17278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jesus Camacho Rodriguez updated HIVE-17278:
-------------------------------------------
    Labels: timestamp  (was: )

> Incorrect output timestamp from from_utc_timestamp()/to_utc_timestamp when local timezone
has DST
> -------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-17278
>                 URL: https://issues.apache.org/jira/browse/HIVE-17278
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>    Affects Versions: 2.0.0
>            Reporter: Leela Krishna
>              Labels: timestamp
>
> HIVE-12706 is resolved but there is still a bug in this - from_utc_timestamp() is interpreting
a GMT timestamp with DST.
> HS2 on PST timezone:
> GMT timestamp PST timestamp PST 2GMT
> 2012-03-11 01:30:15.332	2012-03-10 17:30:15.332	2012-03-11 01:30:15.332
> 2012-03-11 02:30:15.332	2012-03-10 19:30:15.332	2012-03-11 03:30:15.332 (<--- We got
1 hour more on GMT)
> PSTtimestap is generated using from_utc_timestamp('2012-03-11 02:30:15.332', 'PST') 
> PST2GMT timestamp is generated using to_utc_timestamp(from_utc_timestamp('2012-03-11
02:30:15.332', 'PST'), 'PST')



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message