YesOrNo828 opened a new issue, #5314: URL: https://github.com/apache/iceberg/issues/5314
Scenario: Create an iceberg table that has a timestamp-type column with a precision equal to 0 by Flink SQL. Using the below DDL to create a watermark definition table like the iceberg table would be failed. ` create table hadoop_catalog.db.dim (id int, name string, opt timestamp(0), primary key (id) not enforced) ; ` `create table arctic_dim ( watermark for opt as opt - interval '5' second) like hadoop_catalog.db.dim; ` org.apache.flink.table.api.ValidationException: Invalid data type of time field for watermark definition. The field must be of type TIMESTAMP(p) or TIMESTAMP_LTZ(p), the supported precision 'p' is from 0 to 3, but the time field type is TIMESTAMP(6) The [TypeToFlinkType](https://github.com/apache/iceberg/blob/master/flink/v1.14/flink/src/main/java/org/apache/iceberg/flink/TypeToFlinkType.java#L111) default converts it to flink timestamp type with precision 6. So is it possible to support precision 0/3/6 in timestamp type in the iceberg? -- 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]
