#2425 DB::Exception: Aggregate function quantilesMergeState(0.5, 0.75, 0.9, 0.95, 0.99)(duration_quantiles_state) is found inside another aggregate function Issue created by srikanthccv Hi I'm getting following error while going to service map page ``` WITH quantilesMergeState(0.5, 0.75, 0.9, 0.95, 0.99)(duration_quantiles_state) AS duration_quantiles_state, finalizeAggregation(duration_quantiles_state) AS result SELECT src as parent, dest as child, result[1] AS p50, result[2] AS p75, result[3] AS p90, result[4] AS p95, result[5] AS p99, sum(total_count) as callCount, sum(total_count)/ @duration AS callRate, sum(error_count)/sum(total_count) * 100 as errorRate FROM signoz_traces.distributed_dependency_graph_minutes WHERE toUInt64(toDateTime(timestamp)) >= @start AND toUInt64(toDateTime(timestamp)) <= @end GROUP BY src, dest[{start 1677773684} {end 1677773984} {duration 300}] 2023-03-02T162117.250Z ERROR clickhouseReader/reader.go:2011 Error in processing sql query: code: 184, message: Received from chi-signoz-clickhouse-cluster-0-0:9000. DB:Exception Aggregate function quantilesMergeState(0.5, 0.75, 0.9, 0.95, 0.99)(duration_quantiles_state) is found inside another aggregate function in query: While processing quantilesMergeState(0.5, 0.75, 0.9, 0.95, 0.99)(duration_quantiles_state). Stack trace: 0. DB:Exception:Exception(std: 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> > const&, int, bool) @ 0xa3fb75a in /usr/bin/clickhouse 1. DB:GetAggregatesMatcher:visit(DB::ASTFunction const&, std: 1shared ptr&lt;DB:IAST> const&, DB:GetAggregatesMatcher:Data&) @ 0x149c2115 in /usr/bin/clickhouse 2. DB:InDepthNodeVisitor&lt;DB:GetAggregatesMatcher, true, false, std: 1shared ptr&lt;DB:IAST> const>::visit(std: 1shared ptr&lt;DB:IAST> const&) @ 0x149b2dd2 in /usr/bin/clickhouse 3. ? @ 0x150d5ee7 in /usr/bin/clickhouse 4. DB:TreeRewriter:analyzeSelect(std: 1shared ptr&lt;DB:IAST>&, DB::TreeRewriterResult&&, DB::SelectQueryOptions const&, std: 1vector&lt;DB:TableWithColumnNamesAndTypes, std: 1allocator&lt;DB:TableWithColumnNamesAndTypes> > const&, std: 1vector&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> >, std: 1allocator&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> > > > const&, std: 1shared ptr&lt;DB:TableJoin>) const @ 0x150d2f3b in /usr/bin/clickhouse 5. ? @ 0x14e598e1 in /usr/bin/clickhouse 6. DB:InterpreterSelectQuery:InterpreterSelectQuery(std: 1shared ptr&lt;DB:IAST> const&, std: 1shared ptr&lt;DB:Context> const&, std: 1optional&lt;DB:Pipe>, std: 1shared ptr&lt;DB:IStorage> const&, DB::SelectQueryOptions const&, std: 1vector&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> >, std: 1allocator&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> > > > const&, std: 1shared ptr&lt;DB:StorageInMemoryMetadata const> const&, std: 1shared ptr&lt;DB:PreparedSets>) @ 0x14e56549 in /usr/bin/clickhouse 7. DB:InterpreterSelectQuery:InterpreterSelectQuery(std: 1shared ptr&lt;DB:IAST> const&, std: 1shared ptr&lt;DB:Context const> const&, std: 1optional&lt;DB:Pipe>, std: 1shared ptr&lt;DB:IStorage> const&, DB::SelectQueryOptions const&, std: 1vector&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> >, std: 1allocator&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> > > > const&, std: 1shared ptr&lt;DB:StorageInMemoryMetadata const> const&, std: 1shared ptr&lt;DB:PreparedSets>) @ 0x14e53a26 in /usr/bin/clickhouse 8. DB:InterpreterSelectQuery:InterpreterSelectQuery(std: 1shared ptr&lt;DB:IAST> const&, std: 1shared ptr&lt;DB:Context const> const&, DB::SelectQueryOptions const&, std: 1shared ptr&lt;DB:PreparedSets>) @ 0x14e58410 in /usr/bin/clickhouse 9. DB:MergeTreeData:getQueryProcessingStageWithAggregateProjection(std: 1shared ptr&lt;DB:Context const>, std: 1shared ptr&lt;DB:StorageSnapshot> const&, DB::SelectQueryInfo&) const @ 0x158c2a04 in /usr/bin/clickhouse 10. DB:MergeTreeData:getQueryProcessingStage(std: 1shared ptr&lt;DB:Context const>, DB:QueryProcessingStage:Enum, std: 1shared ptr&lt;DB:StorageSnapshot> const&, DB::SelectQueryInfo&) const @ 0x158c72a5 in /usr/bin/clickhouse 11. DB:InterpreterSelectQuery:getSampleBlockImpl() @ 0x14e63916 in /usr/bin/clickhouse 12. ? @ 0x14e5b423 in /usr/bin/clickhouse 13. DB:InterpreterSelectQuery:InterpreterSelectQuery(std: 1shared ptr&lt;DB:IAST> const&, std: 1shared ptr&lt;DB:Context> const&, std: 1optional&lt;DB:Pipe>, std: 1shared ptr&lt;DB:IStorage> const&, DB::SelectQueryOptions const&, std: 1vector&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> >, std: 1allocator&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> > > > const&, std: 1shared ptr&lt;DB:StorageInMemoryMetadata const> const&, std: 1shared ptr&lt;DB:PreparedSets>) @ 0x14e56549 in /usr/bin/clickhouse 14. DB:InterpreterSelectWithUnionQuery:buildCurrentChildInterpreter(std: 1shared ptr&lt;DB:IAST> const&, std: 1vector&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> >, std: 1allocator&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> > > > const&) @ 0x14ea2cac in /usr/bin/clickhouse 15. DB:InterpreterSelectWithUnionQuery:InterpreterSelectWithUnionQuery(std: 1shared ptr&lt;DB:IAST> const&, std: 1shared ptr&lt;DB:Context>, DB::SelectQueryOptions const&, std: 1vector&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> >, std: 1allocator&lt;std 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> > > > const&) @ 0x14ea09ac in /usr/bin/clickhouse 16. DB:InterpreterFactory:get(std: 1shared ptr&lt;DB:IAST>&, std: 1shared ptr&lt;DB:Context>, DB::SelectQueryOptions const&) @ 0x14e04a9e in /usr/bin/clickhouse 17. ? @ 0x15196e80 in /usr/bin/clickhouse 18. DB::executeQuery(std: 1:basic_string<char, std: 1:char_traits<char>, std: 1:allocator<char> > const&, std: 1shared ptr&lt;DB:Context>, bool, DB:QueryProcessingStage:Enum) @ 0x15194957 in /usr/bin/clickhouse 19. DB:TCPHandler:runImpl() @ 0x15c8dd6c in /usr/bin/clickhouse 20. DB:TCPHandler:run() @ 0x15ca2379 in /usr/bin/clickhouse 21. Poco:NetTCPServerConnection:start() @ 0x18a16b73 in /usr/bin/clickhouse 22. Poco:NetTCPServerDispatcher:run() @ 0x18a17ecd in /usr/bin/clickhouse 23. Poco:PooledThread:run() @ 0x18bda829 in /usr/bin/clickhouse 24. Poco:ThreadImpl:runnableEntry(void*) @ 0x18bd80e2 in /usr/bin/clickhouse 25. ? @ 0x7fc72d53a609 in ? 26. __clone @ 0x7fc72d45f133 in ? : While executing Remote <http://go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.(*ClickHouseReader).GetDependencyGraph|go.signoz.io/signoz/pkg/query-service/app/cli… SigNoz/signoz