Cannot resolve field [content], input field list:[contents].

最新推荐文章于 2022-08-29 16:36:18 发布

微电子学与固体电子学-俞驰

最新推荐文章于 2022-08-29 16:36:18 发布

阅读量1.4k

点赞数

分类专栏： Flink

本文链接：https://blog.csdn.net/appleyuchi/article/details/109143655

版权

Flink 专栏收录该内容

210 篇文章 42 订阅

订阅专栏

碰到这么个报错:

Exception in thread "main" org.apache.flink.table.api.ValidationException: Cannot resolve field [content], input field list:[contents].
	at org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.failForField(ReferenceResolverRule.java:80)
	at org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.lambda$null$3(ReferenceResolverRule.java:75)
	at java.util.Optional.orElseThrow(Optional.java:290)
	at org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.lambda$null$4(ReferenceResolverRule.java:75)
	at java.util.Optional.orElseGet(Optional.java:267)
	at org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.lambda$visit$5(ReferenceResolverRule.java:74)
	at java.util.Optional.orElseGet(Optional.java:267)
	at org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.visit(ReferenceResolverRule.java:71)
	at org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule$ExpressionResolverVisitor.visit(ReferenceResolverRule.java:51)
	at org.apache.flink.table.expressions.ApiExpressionVisitor.visit(ApiExpressionVisitor.java:31)
	at org.apache.flink.table.expressions.UnresolvedReferenceExpression.accept(UnresolvedReferenceExpression.java:60)
	at org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule.lambda$apply$0(ReferenceResolverRule.java:47)
	at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1374)
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
	at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
	at org.apache.flink.table.expressions.resolver.rules.ReferenceResolverRule.apply(ReferenceResolverRule.java:48)
	at org.apache.flink.table.expressions.resolver.ExpressionResolver.lambda$null$1(ExpressionResolver.java:211)
	at java.util.function.Function.lambda$andThen$1(Function.java:88)
	at java.util.function.Function.lambda$andThen$1(Function.java:88)
	at java.util.function.Function.lambda$andThen$1(Function.java:88)
	at org.apache.flink.table.expressions.resolver.ExpressionResolver.resolve(ExpressionResolver.java:178)
	at org.apache.flink.table.operations.utils.OperationTreeBuilder.projectInternal(OperationTreeBuilder.java:191)
	at org.apache.flink.table.operations.utils.OperationTreeBuilder.project(OperationTreeBuilder.java:160)
	at org.apache.flink.table.api.internal.TableImpl.select(TableImpl.java:145)
	at org.apache.flink.table.api.internal.TableImpl.select(TableImpl.java:123)
	at UDF.main(UDF.java:37)

原因:

字段引用的content和起名时的contents不完全一致．

解决方案:

        Table tableA = tableEnv.fromDataSet(orderA,$("contents"));
    第１种用法
        Table result1 = tableA.select("content, content.hashCode(), hashCode(content)");
        tableEnv.toDataSet(result1, Row.class).print();

改成

        Table tableA = tableEnv.fromDataSet(orderA,$("content"));
    第１种用法
        Table result1 = tableA.select("content, content.hashCode(), hashCode(content)");
        tableEnv.toDataSet(result1, Row.class).print();