parthchandra commented on PR #1387:
URL:
https://github.com/apache/datafusion-comet/pull/1387#issuecomment-2656383868
More info -
with `native_iceberg_compat`:
```
from_type: Timestamp(Nanosecond, None) to_type: Timestamp(Microsecond,
Some("America/Los_Angeles"))
array: PrimitiveArray<Timestamp(Nanosecond, None)>
[
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
],
casted: Ok(PrimitiveArray<Timestamp(Microsecond,
Some("America/Los_Angeles"))>
[
2020-01-01T09:02:03.123456-08:00,
2020-01-01T09:02:03.123456-08:00,
2020-01-01T09:02:03.123456-08:00,
2020-01-01T09:02:03.123456-08:00,
2020-01-01T09:02:03.123456-08:00,
2020-01-01T09:02:03.123456-08:00,
2020-01-01T09:02:03.123456-08:00,
2020-01-01T09:02:03.123456-08:00,
2020-01-01T09:02:03.123456-08:00,
2020-01-01T09:02:03.123456-08:00,
])
```
with `native_datafusion`:
from_type: Timestamp(Nanosecond, None) to_type: Timestamp(Microsecond,
Some("UTC"))
array: PrimitiveArray<Timestamp(Nanosecond, None)>
[
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
2020-01-01T09:02:03.123456,
],
casted: Ok(PrimitiveArray<Timestamp(Microsecond, Some("UTC"))>
[
2020-01-01T09:02:03.123456+00:00,
2020-01-01T09:02:03.123456+00:00,
2020-01-01T09:02:03.123456+00:00,
2020-01-01T09:02:03.123456+00:00,
2020-01-01T09:02:03.123456+00:00,
2020-01-01T09:02:03.123456+00:00,
2020-01-01T09:02:03.123456+00:00,
2020-01-01T09:02:03.123456+00:00,
2020-01-01T09:02:03.123456+00:00,
2020-01-01T09:02:03.123456+00:00,
])
So the difference in behavior is because of a different timezone being
applied. Both are using session timezone, but one of them is wrong. Either way,
we cannot pin the failures on this PR.
--
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...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
