[FLINK-15595] Entirely implement resolution order as FLIP-68 concept

• Type: Bug
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Table SQL / API
• Labels: auto-deprioritized-major auto-deprioritized-minor pull-request-available
• Assignee: Unassigned
• Reporter: Jingsong Lee
• Created: 15/Jan/20 05:34
• Updated: 18/Dec/21 10:39

Description

First of all, the implementation is problematic. CoreModule returns BuiltinFunctionDefinition, which cannot be resolved in FunctionCatalogOperatorTable, so it will fall back to FlinkSqlOperatorTable.

Second, the function defined by CoreModule is seriously incomplete. You can compare it with FunctionCatalogOperatorTable, a lot less. This leads to the fact that the priority of some functions is in CoreModule, and the priority of some functions is behind all modules. This is confusing, which is not what we want to define in FLIP-68. 

We should:

• We should resolve BuiltinFunctionDefinition correctly in FunctionCatalogOperatorTable.
• CoreModule should contains all functions in FlinkSqlOperatorTable, a simple way could provided calcite wrapper to wrap all functions.
• PlannerContext.getBuiltinSqlOperatorTable should not contains FlinkSqlOperatorTable, we should use one FunctionCatalogOperatorTable.Otherwise, there will be a lot of confusion.

Issue Links

• is related to: FLINK-15592 Streaming sql throw hive exception when it doesn't use any hive table
• links to: GitHub Pull Request #10879

Sub-Tasks

• Add blink built-in functions from FlinkSqlOperatorTable to BuiltInFunctionDefinitions: Open