Hello, my question is about aggregation and sub aggregation.
I would like to use ES as a replacement of my aggregation system (classical SGBRr).
With a classic SQL language, it is possible to do a "group by" on more than one field.
SELECT Continent, Country, Sum(Visits) Visits
GROUP BY Continent, Country
ORDER BY Visits DESC
Here i want the top 5 couples of "Continent, Country" ordered by descending visits.
With ES, i do a first aggregation of the Continent dimension, and then a sub aggregation on the Country dimension. But i have no guarantee to get the same result than with a group by on two columns.
Would it be possible with the future SQL language directly accessible on ES ?