flink 报错

最新推荐文章于 2025-05-14 08:30:26 发布

原创最新推荐文章于 2025-05-14 08:30:26 发布 · 612 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#flink #大数据

文章讨论了在使用ApacheFlinkTableAPI时遇到的错误，指出由于两个聚合函数（sum和avg）的窗口定义不一致导致的UnsupporteduseofOVERwindows异常。解决方法是确保所有聚合函数都在同一窗口内计算。

Caused by: org.apache.flink.table.api.TableException: Over Agg: Unsupported use of OVER windows. All aggregates must be computed on the same window. please re-check the over window statement.
	at org.apache.flink.table.planner.plan.rules.physical.stream.StreamPhysicalOverAggregateRule.convert(StreamPhysicalOverAggregateRule.scala:59)
	at org.apache.calcite.rel.convert.ConverterRule.onMatch(ConverterRule.java:167)
	at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:229)
	at org.apache.calcite.plan.volcano.IterativeRuleDriver.drive(IterativeRuleDriver.java:58)
	at org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:510)
	at org.apache.calcite.tools.Programs$RuleSetProgram.run(Programs.java:312)
	at org.apache.flink.table.planner.plan.optimize.program.FlinkVolcanoProgram.optimize(FlinkVolcanoProgram.scala:69)
	... 23 more

sum(cnt) over(partition by window_start, window_end, province_id order by window_time) total_cnt,avg(cnt) over(partition by window_start, window_end order by window_time) avg_cnt

两个聚合函数窗口不一致导致，可修改为

sum(cnt) over(partition by window_start, window_end, province_id order by window_time) total_cnt,avg(cnt) over(partition by window_start, window_end, province_id order by window_time) avg_cnt