Elasticsearch: terms aggregations on doubly nested object

Question

I am trying to do a doubly nested aggregation on a doubly nested object. That is, I have the root document, a child property, and a grand-child property. To be more precise, I have the following mapping:

{
  "mappings": {
    "root": {
      "properties": {
        "fields": {
          "type": "nested",
          "properties": {
            "name": {
              "type": "keyword"
            },
            "selections": {
              "type": "nested",
              "properties": {
                "value": {
                  "type": "keyword"
                }
              }
            }
          }
        }
      }
    }
  }
}

I am trying to aggregate selection value counts per field, or in other words, to count the number of occurrences of each value for each field name, accross all root objects.

I have this:

{
  "query": {
      ...
  },
  "aggregations": {
    "fields": {
      "nested": {
        "path": "fields"
      },
      "aggregations": {
        "name": {
          "terms": {
            "field": "fields.name"
          },
          "aggregations": {
            "values": {
              "nested": {
                "path": "selections"
              },
              "aggregations": {
                "value": {
                  "terms": {
                    "field": "selections.value"
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

which gets the field names as I want but for each of them I get no doc counts for the values.

What am I doing wrong?

jaspreet chahal · Accepted Answer · 2020-05-16 02:14:04Z

1

You need to give full name for inner nested field, Change "path":"selections" to "path":"fields.selections"

{
  "size": 0, 
  "aggregations": {
    "fields": {
      "nested": {
        "path": "fields"
      },
      "aggregations": {
        "name": {
          "terms": {
            "field": "fields.name"
          },
          "aggregations": {
            "values": {
              "nested": {
                "path": "fields.selections"
              },
              "aggregations": {
                "value": {
                  "terms": {
                    "field": "fields.selections.value"
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

Result:

"aggregations" : {
    "fields" : {
      "doc_count" : 2,
      "name" : {
        "doc_count_error_upper_bound" : 0,
        "sum_other_doc_count" : 0,
        "buckets" : [
          {
            "key" : "abc",
            "doc_count" : 2,
            "values" : {
              "doc_count" : 2,
              "value" : {
                "doc_count_error_upper_bound" : 0,
                "sum_other_doc_count" : 0,
                "buckets" : [
                  {
                    "key" : "1",
                    "doc_count" : 2
                  }
                ]
              }
            }
          }
        ]
      }
    }
  }

answered May 16, 2020 at 2:14

jaspreet chahal

9,1392 gold badges14 silver badges30 bronze badges

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

1 Comment

chaoticdenim Over a year ago

Perfect, thanks fixed my issue, thanks a lot! To anyone who comes across this, I also made the mistake of including the second aggregation level outside of name, whereas it should be inside, just after terms

Collectives™ on Stack Overflow

Elasticsearch: terms aggregations on doubly nested object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related