Elasticsearch 0.18.6 : My example of "parent child"

"parent child" data

curl -s -XPOST localhost:9200/_bulk?pretty=true --data-binary '
{ "index" : { "_index" : "parent_child", "_type" : "store", "_id" : "store1" } }
{ "name" : "auchan", "owner" : "chris" }
{ "index" : { "_index" : "parent_child", "_type" : "department", "_id" : "department1", "parent" : "store1" } }
{ "name" : "toys", "numberOfProducts" : 150  }
{ "index" : { "_index" : "parent_child", "_type" : "product", "_id" : "product1", "parent" : "department1", "routing" : "store1" } }
{ "name" : "gun", "trademark" : "tiger", "price" : 9, "store_id" : "store1"  }
'

"parent child" mapping

curl -XPOST 'http://localhost:9200/parent_child' -d '{
    "settings": {
        "number_of_shards": 5,
        "number_of_replicas": 1
    },
    "mappings": {
        "store": {
            "properties": {
                "name": {
                    "type": "string"
                },
                "owner": {
                    "type": "string"
                }
            }
        },
        "department": {
            "_parent": {
                "type": "store"
            },
            "properties": {
                "name": {
                    "type": "string"
                },
                "numberOfProducts": {
                    "type": "long"
                }
            }
        },
        "product": {
            "_parent": {
                "type": "department"
            },
            "_routing": {
                "required": true,
                "path": "store_id"
            },
            "properties": {
                "name": {
                    "type": "string"
                },
                "trademark": {
                    "type": "string"
                },
                "price": {
                    "type": "long"
                },
                "store_id": {
                    "type": "string"
                }
            }
        }
    }
}'

"parent child" query

curl -XPOST 'http://localhost:9200/parent_child/_search?pretty=true' -d '{
    "query": {
        "filtered": {
            "query": {
                "bool": {
                    "must": [
                        {
                            "term": {
                                "name": "auchan"
                            }
                        }
                    ]
                }
            },
            "filter": {
                "has_child": {
                    "type": "department",
                    "query": {
                        "filtered": {
                            "query": {
                                "bool": {
                                    "must": [
                                        {
                                            "term": {
                                                "name": "toys"
                                            }
                                        }
                                    ]
                                }
                            },
                            "filter": {
                                "has_child": {
                                    "type": "product",
                                    "query": {
                                        "term": {
                                            "trademark": "tiger"
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}'