You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2020/02/27 14:11:00 UTC
[jira] [Updated] (FLINK-16301) Annoying "Cannot find
FunctionDefinition" messages with SQL for f_proctime or =
[ https://issues.apache.org/jira/browse/FLINK-16301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated FLINK-16301:
-----------------------------------
Labels: pull-request-available (was: )
> 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
> Assignee: Jark Wu
> Priority: Major
> Labels: pull-request-available
>
> 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)