[ https://issues.apache.org/jira/browse/FLINK-36898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hanyu Zheng updated FLINK-36898: -------------------------------- Description: Currently, Flink does not support nanosecond precision for the CEIL and FLOOR functions. This limitation exists because Flink does not have a data type with precision greater than nanoseconds. To introduce support for nanoseconds in these functions, we can suppose can support ceil and floor (was: Currently, Flink does not support nanosecond precision for the CEIL and FLOOR functions. This limitation exists because Flink does not have a data type with precision greater than nanoseconds. To introduce support for nanoseconds in these functions, we would first need to evaluate whether this level of precision is required. If the requirement is confirmed, it may necessitate the creation of a new data type with higher precision. This ticket aims to: # Investigate the need for nanosecond precision in CEIL and FLOOR functions. # Analyze the technical feasibility of extending Flink's type system to support nanoseconds in ceil and floor functions. # Identify potential changes required across Flink's core components, including data types, functions, and runtime execution. This research will guide whether a subsequent implementation task is needed to support the datatype which precision is higher than nanosecond.) > Support SQL FLOOR and CEIL functions with NanoSecond for TIMESTAMP_TLZ > ---------------------------------------------------------------------- > > Key: FLINK-36898 > URL: https://issues.apache.org/jira/browse/FLINK-36898 > Project: Flink > Issue Type: Improvement > Reporter: Hanyu Zheng > Priority: Major > > Currently, Flink does not support nanosecond precision for the CEIL and FLOOR > functions. This limitation exists because Flink does not have a data type > with precision greater than nanoseconds. To introduce support for nanoseconds > in these functions, we can suppose can support ceil and floor -- This message was sent by Atlassian Jira (v8.20.10#820010)