Aggregate on nested objects

[mickaelmagniez]

Hi,

On Kibana 4.0.0-BETA2, i'm trying to make aggregation on nested objects, but the query send to elastic search is not correct :

This query is send by kibana :

{
    "size": 0,
    "query": {},
    "aggs": {
        "agg_53": {
            "date_histogram": {
                "field": "@timestamp",
                "interval": "day",
                "min_doc_count": 1,
                "extended_bounds": {
                    "min": "2013-12-31T23:00:00.000Z",
                    "max": "2014-01-31T22:59:59.999Z"
                }
            },
            "aggs": {
                "agg_54": {
                    "terms": {
                        "field": "steps.duration",
                        "size": 40,
                        "order": {
                            "_count": "desc"
                        }
                    }
                }
            }
        }
    }
}

Query should be :

{
    "size": 0,
    "query": {}
    "aggs": {
        "agg_53": {
            "date_histogram": {
                "field": "@timestamp",
                "interval": "day",
                "min_doc_count": 1,
                "extended_bounds": {
                    "min": "2013-12-31T23:00:00.000Z",
                    "max": "2014-01-31T22:59:59.999Z"
                }
            },
            "aggs": {
                "agg_54": {
                    "nested": {
                        "path": "steps"
                    },
                    "aggs": {
                        "agg_55": {
                            "terms": {
                                "field": "steps.worker",
                                "size": 5,
                                "order": {
                                    "_count": "desc"
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}

Here is my mapping

{
    "treatment": {
        "properties": {
            "@timestamp": {
                "type": "date",
                "format": "dateOptionalTime"
            },
            "steps": {
                "type": "nested",
                "properties": {
                    "worker": {
                        "type": "string"
                    },
                    "duration": {
                        "type": "double"
                    }
                }
            }
        }
    }
}

Is there a way to aggregate on nested objects, or to make custpm aggregates (manually input json)

Best regards,

[rashidkpc]

Duplicate of #1084