jayzhan211 commented on issue #8899:
URL:
https://github.com/apache/arrow-datafusion/issues/8899#issuecomment-1897862226
The issue is due to the ambiguous time between daylight saving time and
standard time in chrono.
Ambiguous(2023-10-29T02:00:00TzOffset { tz: Tz(Timezone(Europe/Berlin)),
offset: +02:00 }, 2023-10-29T02:00:00TzOffset { tz:
Tz(Timezone(Europe/Berlin)), offset: +01:00 })
https://github.com/chronotope/chrono/blob/5aaf74235778120b5984b46ced47478c1431d9a0/src/datetime/mod.rs#L693-L698
Therefore `.single()` return None in this case.
I think the easier way to fix this is changing from `and_then` to `or_else`
in `_date_trunc_coarse`?
https://github.com/apache/arrow-datafusion/blob/57e38fb16a9918fb16c2c50e2188cc22c0afe4ad/datafusion/physical-expr/src/datetime_expressions.rs#L234-L288
Possible related issue https://github.com/chronotope/chrono/issues/1153
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
