Elastic search 6.2 group by query

user_5333883 0
Viewed 137

elastic search version: 6.2

I want the count data group by a particular field

example:

Assume I have 3 following docs

{ field1: "value1" } { field1: "value2" } { field1: "value2" }

I want the following result

value1: 1

value2: 2

Note: Field is of type text

elastic-stack elasticsearch lucene
2 Answers

You can simply use a terms aggregation:

{
  "size": 0,
  "aggs": {
    "groups": {
      "terms": {
        "field": "field1"
      }
    }
  }
}
user_46045790

What you want is called aggregations. Here is the query:

GET /yourIndex/_search
{
  "aggs": {
    "myCustomAggregation": {
      "terms": {
        "field": "field1"
      }
    }
  }
}

Note however that you cannot perform aggregations on fields (in your case field field1) which are text fields. You should set that field as keyword.

user_91468040
Related