文档

Quick BI数据集保存报错“ODPS-0130071:[67,28] Semantic analysis exception - aggregate function is not allowed in window, aggregation and table function arguments ”

更新时间:
一键部署

问题描述

基于MaxCompute数据源生成的数据集保存报错“ODPS-0130071:[67,28] Semantic analysis exception - aggregate function is not allowed in window, aggregation and table function arguments”。完整的异常信息如下:

traceId:45c35641-bd6f-4468-b712-365761b6e3df;
errMsg:INTERNAL: instance:[20220816034445513g0tmgnim] failed: ODPS-0130071:[67,28] Semantic analysis exception - aggregate function is not allowed in window, aggregation and table function arguments ODPS-0130071:[67,130] Semantic analysis exception - aggregate function is not allowed in window, aggregation and table function arguments ODPS-0130071:[67,253] Semantic analysis exception - aggregate function is not allowed in window, aggregation and table function arguments ODPS-0130071:[67,376] Semantic analysis exception - aggregate function is not allowed in window, aggregation and table function arguments ODPS-0130071:[67,499] Semantic analysis exception - aggregate function is not allowed in window, aggregation and table function arguments io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(ServerCalls.java:182) io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:331) io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamLis...

问题原因

客户数据集中添加计算字段时有引用其他已经存在的聚合类计算字段导致。ODPS-0130071:[67,499] Semantic analysis exception - aggregate function is not allowed in window, aggregation and table function arguments异常是MaxCompute语法错误:不允许在窗口、聚合和表函数参数中使用聚合函数。

先添加了计算字段A,表达式为sum([毛利额])-sum([运营费用(集团)]),然后添加计算字段B,其表达式为[字段A]/[不含税收入]。该操作存在聚合计算引用聚合函数的操作,因此导致该语法错误。

解决方案

修改计算字段A的表达式为(sum([毛利额])-sum([运营费用(集团)]))/sum([不含税收入])问题解决。

适用于

  • Quick BI
  • 本页导读
文档反馈