[ 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