Counting parents in a parent child relationship

Todd_Gruben · September 17, 2012, 8:58pm

I am attempting to count profiles based on the has_child filter but I am
not getting the desired results. If I execute the query against the search
api, I get the correct list of documents, but If i execute against the
count api, I get 0.

My end goal is to count profiles which have certain attributes(like male)
and has a child document that matches a certain tag. That should be
possible correct?

gist.github.com

https://gist.github.com/tgruben/3739692

build notes


curl -XPOST http://localhost:9200/parent_child --data-binary @mapping.json
curl -XPOST http://localhost:9200/_bulk --data-binary @bulk.json

curl -XPOST http://localhost:9200/parent_child/profile/_search -d'{"query":{"has_child": {"query": {"term": {"tag": 110475388978628}}, "type": "segment"}}}'


curl -XPOST http://localhost:9200/parent_child/profile/_count -d'{"query":{"has_child": {"query": {"term": {"tag": 110475388978628}}, "type": "segment"}}}'

bulk.json

{ "index" : { "_index" : "parent_child", "_type" : "profile", "_id" : "f92c0f92-354d-11e1-8104-12313806f111" } }
{"gender": "male", "profile_id": "f92c0f92-354d-11e1-8104-12313806f111", "property_id": 9}
{ "index" : { "_index" : "parent_child", "_type" : "segment",  "parent" : "f92c0f92-354d-11e1-8104-12313806f111" } }
{"category": [0, 7], "tag": 183824211661952}
{ "index" : { "_index" : "parent_child", "_type" : "segment",  "parent" : "f92c0f92-354d-11e1-8104-12313806f111" } }
{"category": [0, 3, 29, 327], "tag": 110475388978628}
{ "index" : { "_index" : "parent_child", "_type" : "segment",  "parent" : "f92c0f92-354d-11e1-8104-12313806f111" } }
{"category": [0, 3, 29, 327], "tag": 28627688223}
{ "index" : { "_index" : "parent_child", "_type" : "segment",  "parent" : "f92c0f92-354d-11e1-8104-12313806f111" } }
{"category": [0, 7], "tag": 8062627951}

mapping.json

{
    "settings": {
        "number_of_shards": 1,
            "number_of_replicas": 1
    },
        "mappings": {
            "profile": {
                "properties": {
                    "property_id":{
                        "type":"long"

This file has been truncated. show original

Thanks for a really cool product

--

mvg · September 18, 2012, 9:14am

Hi Todd,

Executing the has_child query (and also top_children query) on the
count api has known problems.

The workaround for this problem is the use the search api with the
search type 'count':

In general it is recommended to use the search api with search type
count over the count api for counting hits.

Martijn

On 17 September 2012 22:58, Todd Gruben tgruben@gmail.com wrote:

I am attempting to count profiles based on the has_child filter but I am not
getting the desired results. If I execute the query against the search api,
I get the correct list of documents, but If i execute against the count api,
I get 0.

My end goal is to count profiles which have certain attributes(like male)
and has a child document that matches a certain tag. That should be
possible correct?

Issue with Parent Child counting · GitHub

Thanks for a really cool product

--

--
Met vriendelijke groet,

Martijn van Groningen

--

Topic		Replies	Views
Counting the number of children when returning a parent Elasticsearch	5	3118	July 6, 2017
search profile breakdown Elasticsearch	1	185	November 27, 2023
Counting matching parent documents by aggregations on child documents Elasticsearch	6	2704	July 5, 2017
Best way to count Child object matches? Elasticsearch	2	1066	July 6, 2017
Retrieve the children documents in a parent-child Elasticsearch	4	2029	July 5, 2017

Counting parents in a parent child relationship

Related topics