[FLINK-13933] Hive Generic UDTF can not be used in table API both stream and batch mode

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.9.0
• Fix Version/s: 1.9.1
• Component/s: Table SQL / Planner
• Assignee: Unassigned
• Reporter: fa zheng
• Created: 31/Aug/19 11:24
• Updated: 20/Sep/19 08:15
• Resolved: 20/Sep/19 08:15

Description

When i use Hive Generic UDTF in table API,  something wrong with CalciteContextException: No match found for function signature . As mentioned in tutorials, Hive’s GenericUDTF is automatically translated into Flink’s TableFunction. However, it didn't give a property of TABLE_FUNCTION. In convertToSqlFunction, when functionDefinition is instanceof TableFunctionDefinition, it will further call category.isTableFunction() and lead a wrong answer.