AshinGau commented on issue #11003: URL: https://github.com/apache/hudi/issues/11003#issuecomment-2055847646
After detailed reading of the document [definition of isAdjustedToUTC=true](https://github.com/apache/parquet-format/blob/master/LogicalTypes.md#instant-semantics-timestamps-normalized-to-utc), I found that is was a display problem.  The top first image shows that the Arrow result is `2023-09-17 05:14:35.142+00:00`, which contains the time zone(relative to UTC0), it equals to `2023-09-17 13:14:35.142` in my local time zone(Asia/Shanghai UTC8), so although the display is different, the result is correct for Arrow because as stated in the Parquet document: ``` In practice, such timestamps are typically displayed to users in their local time zones, therefore they may be displayed differently depending on the execution environment. ``` However, the display of Trino does not include a time zone, and when trying to set different time zones, Trino still returns the same result, so it is highly likely that there is an issue with trino's results: <div> <img src="https://github.com/apache/hudi/assets/19337507/65cad820-fb32-40bc-ab50-510b2a560255"; width="400px" /> </div> -- 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]
