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

Reply via email to