es

es.md

Aggregates

Let's say I have a funds index with 2 documents like this

{
  "fundId": 123,
  "fundManager": {
    "id": 123434,
    "name": "Chris Inc"
  },
  "sectors": ["a", "b"]
}

{
  "fundId": 456,
  "fundManager": {
    "id": 123434,
    "name": "Chris Inc"
  },
  "sectors": ["c"]
}

Notice they are two different "funds" with the same fund manager.

What we want to do is retrieve all fund managers with the sectors they manage (e.g bring all the sectors together)

So in this case I'd want for the lack of a better word a "GROUP BY" and get something returned like

{
  "fundManager": {
    "id": 123434,
    "name": "Chris Inc"
  },
  "sectors": ["a", "b", "c"]
}

Is this possible? How?

Aggregation and returning some fieleds

GET deals/doc/_search
{
  "size": 0,
  "aggs": {
    "fund_managers": {
      "terms": {
        "field": "fundManager.name.keyword",
        "size": 100
      },
      "aggs": {
        "top_sectors": {
          "top_hits": {
            "_source": {
              "includes": [
                "fundId",
                "fundManager.id",
                "fundManager.name",
                "sectors"
              ]
            },
            "size": 10
          }
        }
      }
    }
  }
}