S02032

Error Code

S02032

Error Message

Cannot nest aggregate function. RefId:S02032

Probable Causes

Nesting aggregate functions is not allowed in DolphinDB SQL.

For example, the sum function cannot be nested with another sum function.

item = table(1..10 as id, 10+rand(100,10) as qty)
select sum(sum(qty)) from item group by id

Solutions

Most major databases, such as MySQL, PostgreSQL, SQLite, and ClickHouse, do not support nested aggregate functions. Please reconsider your query semantics.