Nico Kruber created FLINK-16301:
-----------------------------------
Summary: Annoying "Cannot find FunctionDefinition" messages with SQL for f_proctime or =
Key: FLINK-16301
URL:
https://issues.apache.org/jira/browse/FLINK-16301 Project: Flink
Issue Type: Bug
Components: Table SQL / Planner
Affects Versions: 1.10.0
Reporter: Nico Kruber
When running the following SQL query
{code}
SELECT
D1.col1 AS A,
D1.col2 AS B,
D1.col3 AS C,
D1.col4 AS D,
D1.col5 AS E,
D2.col1 AS F,
D2.col2 AS G,
D2.col3 AS H,
D2.col4 AS I,
D2.col5 AS J,
D3.col1 AS K,
D3.col2 AS L,
D3.col3 AS M,
D3.col4 AS N,
D3.col5 AS O,
D4.col1 AS P,
D4.col2 AS Q,
D4.col3 AS R,
D4.col4 AS S,
D4.col5 AS T,
D5.col1 AS U,
D5.col2 AS V,
D5.col3 AS W,
D5.col4 AS X,
D5.col5 AS Y
FROM
fact_table,
LATERAL TABLE (dimension_table1(f_proctime)) AS D1,
LATERAL TABLE (dimension_table2(f_proctime)) AS D2,
LATERAL TABLE (dimension_table3(f_proctime)) AS D3,
LATERAL TABLE (dimension_table4(f_proctime)) AS D4,
LATERAL TABLE (dimension_table5(f_proctime)) AS D5
WHERE
fact_table.dim1 = D1.id
AND fact_table.dim2 = D2.id
AND fact_table.dim3 = D3.id
AND fact_table.dim4 = D4.id
AND fact_table.dim5 = D5.id
{code}
with the Blink planner, it prints a log of bogus warnings about unknown functions for things like {{f_proctime}} or {{=}} at INFO level which should be DEBUG level at least in order not to bother the users with it. The messages I got are:
{code}
13:33:59,590 INFO org.apache.flink.table.module.ModuleManager - Cannot find FunctionDefinition f_proctime from any loaded modules
13:33:59,641 INFO org.apache.flink.table.module.ModuleManager - Cannot find FunctionDefinition f_proctime from any loaded modules
13:33:59,644 INFO org.apache.flink.table.module.ModuleManager - Cannot find FunctionDefinition f_proctime from any loaded modules
13:33:59,647 INFO org.apache.flink.table.module.ModuleManager - Cannot find FunctionDefinition f_proctime from any loaded modules
13:33:59,650 INFO org.apache.flink.table.module.ModuleManager - Cannot find FunctionDefinition f_proctime from any loaded modules
13:33:59,662 INFO org.apache.flink.table.module.ModuleManager - Cannot find FunctionDefinition = from any loaded modules
13:33:59,665 INFO org.apache.flink.table.module.ModuleManager - Cannot find FunctionDefinition = from any loaded modules
13:33:59,666 INFO org.apache.flink.table.module.ModuleManager - Got FunctionDefinition and from module core
13:33:59,667 INFO org.apache.flink.table.module.ModuleManager - Cannot find FunctionDefinition = from any loaded modules
13:33:59,668 INFO org.apache.flink.table.module.ModuleManager - Got FunctionDefinition and from module core
13:33:59,669 INFO org.apache.flink.table.module.ModuleManager - Cannot find FunctionDefinition = from any loaded modules
13:33:59,670 INFO org.apache.flink.table.module.ModuleManager - Got FunctionDefinition and from module core
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
Locked
