[I] Timestamp data losing precision when Flink writing to Iceberg [iceberg]

[via GitHub]

yeunghl-shoalter opened a new issue, #9229:
URL: https://github.com/apache/iceberg/issues/9229

   ### Apache Iceberg version
   
   1.4.2 (latest release)
   
   ### Query engine
   
   Flink
   
   ### Please describe the bug 🐞
   
   When writing data (timestamp with timezone precision 3) into Iceberg table, 
the value would store with precision 0. Sure that the source provides values of 
millisecond. Is there a problem when Flink writing timestamp that having 
different precision with the Iceberg data type? Or there is other cause? Any 
solution to this? Thanks.
   
   Flink CDC MySQL connector as source and Iceberg as sink.
   
   Flink SQL
   ```
   CREATE TABLE `abcd` (
       `__operation_timestamp` TIMESTAMP_LTZ(3) METADATA FROM 'op_ts' VIRTUAL
     ) WITH (
       'connector'='mysql-cdc',
       'hostname'='abcd',
       'port'='8000',
       'username'='abcd',
       'password'='abcd',
       'database-name'='abcd',
       'table-name'='abcd'
   );
   
   INSERT INTO `abcd`.`abcd`.`abcd`
   (
     `operation_timestamp`
   )
   SELECT
     `__operation_timestamp` AS `operation_timestamp`
   FROM `abcd`;
   ```
   View Iceberg table with Superset + Trino
   
![image](https://github.com/apache/iceberg/assets/105259054/6df8c4ad-f033-48da-a74b-8b95bcd992db)
   
![image](https://github.com/apache/iceberg/assets/105259054/7f187eb6-32bb-455b-809f-439ed3c618ed)
   
   


-- 
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: issues-unsubscr...@iceberg.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org
For additional commands, e-mail: issues-h...@iceberg.apache.org