Aggregate nested objects in ElasticSearch

Question

Let's say we have this document:

{
    "Article" : [
      {
        "id" : 12
        "title" : "An article title",
        "categories" : [1,3,5,7],
        "tag" : ["elasticsearch", "symfony",'Obtao'],
        "author" : [
            {
                "firstname" : "Francois",
                "surname": "francoisg",
                "id" : 18
            },
            {
                "firstname" : "Gregory",
                "surname" : "gregquat"
                "id" : "2"
            }
        ]
      }
    },
    {
        "id" : 13
        "title" : "A second article title",
        "categories" : [1,7],
        "tag" : ["elasticsearch", "symfony",'Obtao'],
        "author" : [
            {
                "firstname" : "Gregory",
                "surname" : "gregquat",
                "id" : "2"
            }
        ]
      }
}

How can I find all unique authors by id? What is the proper query? I need to return all unique authors ("author.id")

Thanks for help.

What about nested aggregations? elastic.co/guide/en/elasticsearch/reference/current/… — Taras Kohut
– Taras Kohut, Commented Dec 9, 2017 at 23:55

Eli · Accepted Answer · 2017-12-10 13:20:52Z

1

First, you should set your mapping with nested type for the field author. Second, as @Taras_Kohut mentioned, and after you re-indexed the entire data, you can do:

{
  "size": 0,
  "aggregations": {
    "records": {
      "nested": {
        "path": "author"
      },
      "aggregations": {
        "ids": {
          "terms": {
            "field": "author.id"
          }
        }
      }
    }
  }
}

See Nested Aggregation

answered Dec 10, 2017 at 13:20

Eli

5,0361 gold badge31 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Aggregate nested objects in ElasticSearch

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