Alexey Leonov-Vendrovskiy created FLINK-35241:
-------------------------------------------------
Summary: Support SQL FLOOR and CEIL functions with SECOND and
MINUTE for TIMESTAMP_TLZ
Key: FLINK-35241
URL: https://issues.apache.org/jira/browse/FLINK-35241
Project: Flink
Issue Type: Bug
Components: Table SQL / API
Reporter: Alexey Leonov-Vendrovskiy
We need a fix for both SECOND and MINUTE.
The following query doesn't work:
{code:java}
SELECT
FLOOR(
CAST(TIMESTAMP '2024-04-25 17:19:42.654' AS TIMESTAMP_LTZ(3))
TO MINUTE) {code}
These two queries work:
{code:java}
SELECT
FLOOR(
CAST(TIMESTAMP '2024-04-25 17:19:42.654' AS TIMESTAMP_LTZ(3))
TO HOUR) {code}
{code:java}
SELECT
FLOOR(
TIMESTAMP '2024-04-25 17:19:42.654'
TO MINUTE) {code}
Stack trace:
For the first not working query:
{code:java}
Caused by: io.confluent.flink.table.utils.CleanedException:
org.codehaus.commons.compiler.CompileException: Line 41, Column 69: No
applicable constructor/method found for actual parameters
"org.apache.flink.table.data.TimestampData,
org.apache.flink.table.data.TimestampData"; candidates are: "public static long
org.apache.flink.table.runtime.functions.SqlFunctionUtils.floor(long, long)",
"public static float
org.apache.flink.table.runtime.functions.SqlFunctionUtils.floor(float)",
"public static org.apache.flink.table.data.DecimalData
org.apache.flink.table.runtime.functions.SqlFunctionUtils.floor(org.apache.flink.table.data.DecimalData)",
"public static int
org.apache.flink.table.runtime.functions.SqlFunctionUtils.floor(int, int)",
"public static double
org.apache.flink.table.runtime.functions.SqlFunctionUtils.floor(double)"
at org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:13080)
at
org.codehaus.janino.UnitCompiler.findMostSpecificIInvocable(UnitCompiler.java:9646)
at org.codehaus.janino.UnitCompiler.findIMethod(UnitCompiler.java:9506)
at org.codehaus.janino.UnitCompiler.findIMethod(UnitCompiler.java:9422)
at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:5263)
... {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
