[
https://issues.apache.org/jira/browse/IMPALA-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17517971#comment-17517971
]
Gabor Kaszab edited comment on IMPALA-3169 at 4/6/22 9:11 AM:
--------------------------------------------------------------
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.
Let me close this, but feel free to reopen if there are any objections.
was (Author: gaborkaszab):
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-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
