Sql aggregation

Elastic Stack Elasticsearch
1

hi, my sql like this: SELECT a.*, (SELECT b.id, SUM(b.num) FROM table2 AS b GROUP BY b.id HAVING b.id=a.id) AS sumNum FROM table1 AS a;
table2 is nested in table1, how to build dsl?

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.