[jira] [Commented] (IMPALA-3169) to_utc_timestamp blank value

["Gabor Kaszab (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17517971#comment-17517971 ] 

Gabor Kaszab commented on IMPALA-3169:
--------------------------------------

I've jumped into this ticket recently and I feel that the behaviour we have currently is correct to return NULL during the DST hour due to ambiguity. I feel that this ticket should be closed without taking any action.

> 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
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org