ElasticSearch: count by item in array

Question

For every document I have a category array, it looks like this:

[{
    "id": 1,
    "level": 1
}, {
    "id": 2,
    "level": 2
}, {
    "id": 3,
    "level": 3
}]

How can I count the categories I have in every document according to the level 3 category.id?

pls add more info or post a query along with schema would be good.thx — user3775217
– user3775217, Commented Aug 21, 2016 at 18:39

Pratyusha Rasamsetty · Accepted Answer · 2016-08-22 09:35:24Z

1

category array shall be nested field. And the rest can be handled via aggregations. Try something similar to the code given below.

"aggregations": {
"mainAgg": {
  "nested": {
    "path": "category"
  },
  "aggs": {
    "levelFilter": {
        -- filter condition
      "filter": {
        "term": {
          "level": 3
        },
          -- count aggregation
        "aggs": {
          "count": {
            "value_count": {
              "field": "level"
            }
          }
        }
      }
    }
  }
}

}

answered Aug 22, 2016 at 9:35

Pratyusha Rasamsetty

214 bronze badges

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

Collectives™ on Stack Overflow

ElasticSearch: count by item in array

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