mughilanand opened a new issue, #63640: URL: https://github.com/apache/doris/issues/63640
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 4.0.2 and 4.0.5 ### What's Wrong? When querying an Iceberg table in Doris via Iceberg Catalog, DATE columns are consistently shifted by -1 day compared to Spark/Beeline for the same Iceberg snapshot. This affects all DATE values and is reproducible across multiple rows and tables. ### What You Expected? Date Column should be return the same data when accessing in doris(no -1 shifting) via iceberg catalog and Spark. ### How to Reproduce? **SPARK:** CREATE TABLE test.mughil_test ( id_col BIGINT, date_col DATE, ts_col TIMESTAMP ) USING iceberg; INSERT INTO test.mughil_test VALUES (1, DATE '1970-01-01', TIMESTAMP '1970-01-01 00:00:00'), (2, DATE '1970-01-02', TIMESTAMP '1970-01-02 00:00:00'), (3, DATE '1977-04-18', TIMESTAMP '1977-04-18 00:00:00'), (4, DATE '1977-04-19', TIMESTAMP '1977-04-19 00:00:00'), (5, DATE '1985-01-31', TIMESTAMP '1985-01-31 00:00:00'), (6, DATE '2000-01-01', TIMESTAMP '2000-01-01 00:00:00'); spark-sql> SELECT * FROM test.mughil_test ORDER BY id; id d ts 1 1970-01-01 1970-01-01 00:00:00 2 1970-01-02 1970-01-02 00:00:00 3 1977-04-18 1977-04-18 00:00:00 4 1977-04-19 1977-04-19 00:00:00 5 1985-01-31 1985-01-31 00:00:00 6 2000-01-01 2000-01-01 00:00:00 Time taken: 1.868 seconds, Fetched 6 row(s) **Doris Via Iceberg Catalog:** mysql> SELECT id, d, ts -> FROM test_iceberg.test.mughil_test -> ORDER BY id; +------+------------+----------------------------+ | id | d | ts | +------+------------+----------------------------+ | 1 | 1969-12-31 | 1970-01-01 00:00:00.000000 | | 2 | 1970-01-01 | 1970-01-02 00:00:00.000000 | | 3 | 1977-04-17 | 1977-04-18 00:00:00.000000 | | 4 | 1977-04-18 | 1977-04-19 00:00:00.000000 | | 5 | 1985-01-30 | 1985-01-31 00:00:00.000000 | | 6 | 1999-12-31 | 2000-01-01 00:00:00.000000 | +------+------------+----------------------------+ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
