【Flink ERROR】List of column aliases must have same degree as table; the returned table of function ‘

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);
        }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值