Elasticsearch: aggregate nested objects

Question

I have the data in the following structure

"mappings" : {
            "PERSON" : {
                "properties" : {
                    "ADDRESS" : {
                        "type": "nested",
                        "properties" : {
                        "STREET" : {
                            "type": "nested",
                            "properties" : {
                                "street": {
                                    "type": "string"
                                },
                                "number": {
                                "type": "integer"
                                }
                            }
                        },
                        "CITY" : {
                            "type": "nested",
                            "properties" : {
                                "name": {
                                    "type": "string"
                                },
                                "size": {
                                "type": "integer"
                                }
                            }
                        }
                        ,
                        "country": {
                            "type": "string"
                        }
                        }
                    },
                    "INFORMATION" : {
                        "type": "nested",
                        "properties" : {
                        "age": {
                            "type": "integer"
                        },
                        "sex": {
                            "type": "string"
                        }
                        }
                    }
                    "name" : {
                        "type": "string",
                    }
                }
            }
        }

I want to aggregate nested object dynamically in form: ["object type": count of records with this type].

e.g. for the PERSON I want to get something like:

[ADDRESS: 1000, INFORMATION: 1230]

and for ADDRESS:

[STREET: 200, CITY: 100]

Is it possible?

Hugo · Accepted Answer · 2016-03-30 16:14:51Z

1

You can first filter based on PERSON or ADDRESS and then use cardinality aggregation to get the count

answered Mar 30, 2016 at 16:14

Hugo

2542 silver badges6 bronze badges

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

1 Comment

Taras Kohut Over a year ago

what filter I have to use on PERSON to get ADDRESS and INFORMATION?

Collectives™ on Stack Overflow

Elasticsearch: aggregate nested objects

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