[
https://issues.apache.org/jira/browse/IMPALA-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabor Kaszab closed IMPALA-3169.
--------------------------------
Fix Version/s: Not Applicable
Resolution: Won't Fix
> to_utc_timestamp blank value
> ----------------------------
>
> Key: IMPALA-3169
> URL: https://issues.apache.org/jira/browse/IMPALA-3169
> Project: IMPALA
> Issue Type: Improvement
> Components: Backend
> Affects Versions: Impala 2.3.0, Impala 2.5.0, Impala 2.4.0
> Environment: Cloudera CDH 5.5.2
> Reporter: Lorenzo Bagni
> Priority: Major
> Fix For: Not Applicable
>
>
> When is called the function for convertion date from daylight saving time to
> legal time (i.e. CEST to CET) the function returns wrong (blank) value for
> '2015-10-25 01:00:01'.
> The correct vaule will be '2015-10-24 23:00:01'
> Code to reproduce:
> {{select}}
> {{to_utc_timestamp(cast('2015-10-25 00:00:01' as timestamp),'CET') ,}}
> {{to_utc_timestamp(cast('2015-10-25 01:00:01' as timestamp),'CET') ,}}
> {{to_utc_timestamp(cast('2015-10-25 02:00:01' as timestamp),'CET') ,}}
> {{to_utc_timestamp(cast('2015-10-25 03:00:01' as timestamp),'CET')}}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
