Build relation between elasticsearch aggregators - Nested groupings

Elastic Stack Elasticsearch
1

Hi,

I need to create nested groupings between fields.
Let us consider the example given below,

Documents:

{
"keyword": "abc",
"country": "IN",
"state": "TN",
"city": "Chennai"
},
{
"keyword": "abc",
"country": "IN",
"state": "TN",
"city": "Trichy"
},
{
"keyword": "abc",
"country": "IN",
"state": "KL",
"city": "TVM"
},
{
"keyword": "abc",
"country": "US",
"state": "Cal",
"city": "California"
}

Required output(Something like this):

{
"country": "IN",
"TN": [
"Chennai",
"Trichy"
],
"KL": [
"TVM"
]
},
{
"country": "US",
"Cal": [
"California"
]
}

Query used:

{
"from": 0,
"size": 1,
"aggs": {
"country": {
"terms": {
"field": "country.keyword",
"size": 50000
}
},
"state": {
"terms": {
"field": "state.keyword",
"size": 50000
}
},
"city": {
"terms": {
"field": "city.keyword",
"size": 50000
}
}
},
"query": {
"query_string": {
"query": "(keyword:abc) "
}
}
}

For this query I got separate bucket as output for city , state and country.

But what I need is city should be grouped under state and state should be grouped under country.

Thanks in advance.

2

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