liukun4515 commented on PR #5605:
URL: https://github.com/apache/arrow-rs/pull/5605#issuecomment-2060960080
> > Do we need to add or wrap the cast expr explicitly to the target
timestamp column?
>
> Yes arrow does not have a notion of "local" timezone, users need to be
explicit about the timezone they wish to use for a particular array.
Theoretically a DF frontend could add such a notion, but I would strongly
recommend against it as it is leads to all sorts of peculiar bugs.
>
> The following would be an example DataFusion SQL query that is explicit
about timezones
>
> ```
> SELECT arrow_cast(time_column, 'Timestamp(Nanosecond, Some("+07:00"))';
> ```
Thanks for your feedback for
> > Do we need to add or wrap the cast expr explicitly to the target
timestamp column?
I also know that adding explicit `cast` expr is not a good way.
Maybe the suggestion from @alamb is a good solution to resolve this after
thinking about it again.
We can specify the `timezone` which is defined from `parquet reader options`
when read the timestamp column.
what do you think about this method?
--
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: github-unsubscr...@arrow.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
