How can I unwind array in elasticsearch

Elastic Stack Elasticsearch
1

Hii

{
  "size": 0,
  "aggs": {
    "location_buckets": {
      "composite": {
        "size": 1000,
        "sources": [
          {
            "city": {
              "terms": {
                "field": "location.city"
              }
            }
          },
          {
            "state": {
              "terms": {
                "field": "location.state"
              }
            }
          }
        ]
      }
    }
  }
}

When I perform this query on

{
  "documents": [
    {
      "name": "A",
      "location": [
        {
          "state": "Andhra",
          "city": "vijayawada",
          "document_name": "A"
        },
        {
          "state": "telangana",
          "city": "hyderabad",
          "document_name": "A"
        }
      ]
    },
    {
      "name": "B",
      "location": [
        {
          "state": "telangana",
          "city": "hyderabad",
          "document_name": "B"
        }
      ]
    },
    {
      "name": "C",
      "location": [
        {
          "state": "telangana",
          "city": "hyderabad",
          "document_name": "C"
        }
      ]
    }
  ]
}

I got
"buckets" : [
{
"key" : {
"state" : "telangana",
"city" : "hyderabad",
},
"doc_count" : 3
},
{
"key" : {
"state" : "Andhra",
"city" : "hyderabad",
},
"doc_count" : 1
},
{
"key" : {
"state" : "telangana",
"city" : "vijayawada",
},
"doc_count" : 1
}
]
but, I need Separately like,
bucket ={
"key" : {
"state" : "telangana",
"city" : "hyderabad",
},
"doc_count" : 3
},
{
"key" : {
"state" : "Andhra",
"city" : "vijayawada",
},
"doc_count" : 1
}
Can you tell me how can I get them individually

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.