[
https://issues.apache.org/jira/browse/IMPALA-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-3169:
----------------------------------
Issue Type: Improvement (was: Bug)
> 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
>
> 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
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
