Combining aggregations in Elastic Search

Question

I have objects of which some are grouped by a 'masterID'. I need an aggregation/query that shows me as result the object with the highest 'relevance' per object group by 'masterID'.

With aggregation of term 'masterID' I can get buckets for each 'masterID'. But how do I get the highest 'relevance' object within each bucket?

The queries so far are:

curl -XGET 'http://localhost:9200/pwo/_search?search_type=count&size=0&pretty=true' -d '{
  "aggregations": {
    "masterIDs": {
      "terms": {
        "field": "masterID",
        "size": 0
      }
    }
  }
}
'

and

curl -XGET 'http://localhost:9200/pwo/_search?size=0&pretty=true' -d '{
  "aggregations": {
    "relevance": {
      "max": {
        "field": "relevance"
      }
    }
  }
}
'

Is there a way to solve this with a single query?

Yes! you can add the relevance aggregation block in the masterIDs block — eliasah
– eliasah, Commented Apr 20, 2015 at 9:45
Thanks, that worked fine. Any way to embed the field '_id' of the object with max 'relevance' to the output? — TeTeT
– TeTeT, Commented Apr 20, 2015 at 10:22
Seems to be working with a top_hits aggregation added to the relevance aggregation. — TeTeT
– TeTeT, Commented Apr 20, 2015 at 11:12
If problem is solved please answer your own question and accept it instead posting the answer in the question. — Dmytro Sadovnychyi
– Dmytro Sadovnychyi, Commented Apr 20, 2015 at 11:54
@eliasah , do you want to post the answer, I'll accept it then. Thanks. — TeTeT
– TeTeT, Commented Apr 20, 2015 at 12:24

eliasah · Accepted Answer · 2015-04-20 12:37:59Z

1

You can add the relevance aggregation block in the masterIDs block like following :

curl -XGET 'http://localhost:9200/pwo/_search?size=0&pretty=true' -d '{
  "aggregations": {
    "masterIDs": {
      "terms": {
        "field": "masterID",
        "size": 0
      },
      "aggregations": {
        "relevance": {
          "max": { "field" : "relevance" }
        },
        "aggregations": {
          "top_hits": {
            "size": 1
          }
        }
      }
    }
  }
}
'

answered Apr 20, 2015 at 12:37

eliasah

40.5k12 gold badges128 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combining aggregations in Elastic Search

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related