List of column aliases must have same degree as table; the returned table of function ‘split’ has 1 columns, whereas alias list has 2 columns
在自定义表函数时,运行出现了此错误,具体报错如下:
log4j:WARN No appenders could be found for logger (org.apache.flink.api.java.typeutils.TypeExtractor).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Exception in thread "main" org.apache.flink.table.api.ValidationException: List of column aliases must have same degree as table; the returned table of function 'split' has 1 columns, whereas alias list has 2 columns
at org.apache.flink.table.operations.utils.factories.CalculatedTableFactory$FunctionTableCallVisitor.createFunctionCall(CalculatedTableFactory.java:116)
at org.apache.flink.table.operations.utils.factories.CalculatedTableFactory$FunctionTableCallVisitor.unwrapFromAlias(CalculatedTableFactory.java:100)
at org.apache.flink.table.operations.utils.factories.CalculatedTableFactory$FunctionTableCallVisitor.visit(CalculatedTableFactory.java:74)
at org.apache.flink.table.operations.utils.factories.CalculatedTableFactory$FunctionTableCallVisitor.visit(CalculatedTableFactory.java:62)
at org.apache.flink.table.expressions.CallExpression.accept(CallExpression.java:122)
at org.apache.flink.table.operations.utils.factories.CalculatedTableFactory.create(CalculatedTableFactory.java:59)
at org.apache.flink.table.operations.utils.OperationTreeBuilder.joinLateral(OperationTreeBuilder.java:367)
at org.apache.flink.table.api.internal.TableImpl.joinLateralInternal(TableImpl.java:337)
at org.apache.flink.table.api.internal.TableImpl.joinLateral(TableImpl.java:289)
at org.apache.flink.table.api.internal.TableImpl.joinLateral(TableImpl.java:284)
at udf.udfTest2_TableFunction.main(udfTest2_TableFunction.java:42)
原因:自定义类集成TableFunction时没有实现getResultType
方法
如我们此时输出的是Row类型,我们就需要重写此方法
@Override
public TypeInformation<Row> getResultType() {
return Types.ROW(Types.STRING, Types.INT);
}