elasticsearch - aggregating counts on array matches

Question

This is my structure:

document 1 has

{
  "people": [
    {
      "name": "Darrell",
      "age": "10",
    },
    {
      "name": "Karen",
      "age": "20",
    },
    {
      "name": "Gary",
      "age": "30",
    }
  ]
}

Document 2 has

{
  "people": [
    {
      "name": "Karen",
      "age": "25",
    },
    {
      "name": "Gary",
      "age": "30",
    }
  ]
}

Now, how can I perform count aggregation on individual array elements that matched the query?

If I query for name:Karen, I need the count as 2.
If I query for name:Karen && age:20, I need the count as 1.
If I query for name:Gary && age:30, I need the count as 2.

Val · Accepted Answer · 2016-02-23 12:16:03Z

2

You need to map your people object as nested objects, otherwise it won't work as you expect.

curl -XPUT localhost:9200/your_index -d '{
  "mappings": {
    "your_type": {
      "properties": {
        "people": {
          "type": "nested",
          "properties": {
              "name": {"type": "string"},
              "age": {"type": "integer"}
          }
        }
      }
    }
  }
}'

Once your index and mapping type have been created and after you've re-indexed your data, you'll be able to run your query like this:

curl -XPOST localhost:9200/your_index/_search -d '{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "people",
            "query": {
              "term": {
                "people.name": "karen"
              }
            }
          }
        },
        {
          "nested": {
            "path": "people",
            "query": {
              "term": {
                "people.age": "20"
              }
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "people": {
      "nested": {
        "path": "people"
      },
      "aggs": {
        "names": {
          "terms": {
             "field": "people.name"
          }
        }
      }
    }
  }
}'

edited Feb 23, 2016 at 12:16

answered Feb 23, 2016 at 10:23

Val

218k14 gold badges377 silver badges384 bronze badges

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

4 Comments

user3658423 Over a year ago

Thanks val. It shows me an error- "bool query does not support [filter]"

Val Over a year ago

Oh, I'm using ES 2. and you probably aren't. I've updated my answer with a pre-2.0 valid query.

user3658423 Over a year ago

for some reason the terms aggregation did not work. I switched to value_count and it worked. thanks a lot.

user3658423 Over a year ago

I had added the name key already but still "terms" was not giving the correct counts...still trying to debug that. (But value_count was readily correct).

Collectives™ on Stack Overflow

elasticsearch - aggregating counts on array matches

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related