FANNG1 opened a new issue, #4743:
URL: https://github.com/apache/gravitino/issues/4743

   ### Version
   
   main branch
   
   ### Describe what's wrong
   
   trino couldn't read Iceberg partition table created by spark
   
   ### Error message and/or stacktrace
   
   Query 20240828_134434_01832_9eicb failed: Could not serialize column 
'hire_date' of type 'timestamp(3)' at position 1:4
   
   
   ### How to reproduce
   
   
   Spark sql:
   ```
   CREATE DATABASE IF NOT EXISTS mydatabase;
   USE mydatabase;
   
   CREATE TABLE IF NOT EXISTS employee (
     id bigint,
     name string,
     department string,
     hire_date timestamp
   ) USING iceberg
   PARTITIONED BY (days(hire_date));
   DESC TABLE EXTENDED employee;
   
   INSERT INTO employee
   VALUES
   (1, 'Alice', 'Engineering', TIMESTAMP '2021-01-01 09:00:00'),
   (2, 'Bob', 'Marketing', TIMESTAMP '2021-02-01 10:30:00'),
   (3, 'Charlie', 'Sales', TIMESTAMP '2021-03-01 08:45:00');
   
   
   ```
   
   trino:
   ```
   select * from iceberg_hive.gt_db1.employee;
   ```
   
   ### Additional context
   
   _No response_


-- 
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]

Reply via email to