[jira] [Created] (FLINK-16301) Annoying "Cannot find FunctionDefinition" messages with SQL for f_proctime or =

["Nico Kruber (Jira)" <ji...@apache.org>]

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)