Hello, I'm having the exact same problem. Have you managed to find a solution?
My thread is here: LINK <https://groups.google.com/forum/?fromgroups#!topic/elasticsearch/Oum03VSBzHQ> Thanks On Thursday, October 16, 2014 1:57:35 PM UTC+1, Alastair James wrote: > > Hi there. > > I am trying to create an aggregation that mimics the following SQL query: > > SELECT col1, col2, COUNT(*), SUM(metric) FROM table GROUP BY col1, col2 > ORDER BY SUM(metric) DESC > > On the face of it, I could create an terms aggregation for col1, add a > terms aggregation for col2 inside it, and the metric aggregations inside > that. I could then dynamically build the SQL result like grid and sort it > myself. However this breaks down for large results set, or a paginated > result set of a larger result. > > The problem is that the ES aggregation system always returns the top N > results for each parent and child bucket. Thus for each value of col1 I > have N values of col2. > > What I really want is to consider all possible combinations of col1 and > col2 in the same way as SQL does it and return the top N based on some > other metric. E.g. in ES speak, a single aggregation where the keys are > tuples of (col1, col2). > > I suppose one way would be to use a script terms aggregation to > concatenate each value of col1 and col2, however thats going to be slow. > > Does anyone else have any ideas? > > Ideally there would be a tuple aggregation built in, e.g.: > > "my_agg":{ > "tuple":{ > "fields":["col1","col2"] > } > } > > Would product keys that are objects like: > > { > "col1":"value1", > "col2":"value2" > } > > Does anyone know if this would be possible to write as a plugin? > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/713127be-b89e-42ee-8811-18dd0e31d16a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.