Search child by parent field

Igor_Semenko · February 5, 2012, 8:40pm

Hello, I'm exploring Parent-Child feature in elasticsearch, but can't
understand whether it's possible to find child by parent's field name? Sort
of reverse 'has_child' query.

Here is example:

Author (parent)
-name
-country

Book (child of Author)

title
...

Can I search for all books author of which is from country:US for example?

Thanks.

Radu_Gheorghe1 · February 5, 2012, 9:40pm

Would it be an option in these cases to do a query on books with a
filter on author's country?

On 5 feb., 22:40, Igor Semenko i...@semenko.com wrote:

Hello, I'm exploring Parent-Child feature in elasticsearch, but can't
understand whether it's possible to find child by parent's field name? Sort
of reverse 'has_child' query.

Here is example:

Author (parent)
-name
-country

Book (child of Author)

title
...

Can I search for all books author of which is from country:US for example?

Thanks.

Igor_Semenko · February 6, 2012, 8:31pm

That would work, but I'm missing how to refer to the author in
search/filter.

Mapping:

curl -XPUT 'http://localhost:9200/test/'

curl -XPUT 'http://localhost:9200/test/author/_mapping' -d '{

"author" : {
    "properties" : {
        "name" : {"type" : "string"},
        "country" : {"type" : "string"}
    }
}

}
'

curl -XPUT 'http://localhost:9200/test/book/_mapping' -d '{

"book" : {
    "_parent" : {"type" : "author"},
    "properties" : {
        "title" : {"type" : "string"}
    }
}

}

Query/Filter??

curl -XGET 'http://localhost:9200/test/book/_search' -d '{
"explain" : true,
"query" : {
"bool" : {
"must" : {
"text" : {"title" : "book"}
},
"must" : {
"term" : {"_parent.country" : "us"}
}
}
}
}
';

curl -XGET 'http://localhost:9200/test/book/_search' -d '{
"explain" : true,
"query" : {
"text" : {"title" : "book"}
},
"filter" : {
"term": {"author.country" : "us"}
}
}
';

Sample data

curl -XPUT 'http://localhost:9200/test/author/1' -d '{
"name" : "author 1",
"country" : "us"
}'
curl -XPUT 'http://localhost:9200/test/author/2' -d '{
"name" : "author 2",
"country" : "uk"
}'
curl -XPUT 'http://localhost:9200/test/book/11?parent=1' -d '
{
"title": "book 1 author 1"
}'
curl -XPUT 'http://localhost:9200/test/book/12?parent=1' -d '
{
"title": "book 2 author 1"
}'
curl -XPUT 'http://localhost:9200/test/book/21?parent=2' -d '
{
"title": "book 3 author 2"
}'

Radu_Gheorghe1 · February 7, 2012, 8:00am

I'm so sorry, I totally misunderstood your question. I thought you
were talking about nested documents, not parent/child types.

Now that I got it, I tried to find a solution, but failed miserably. I
guess I would just use nested documents if I would need such
functionality.

Apparently, you can refer to the parent's ID from within the child:
http://elasticsearch-users.115913.n3.nabble.com/Parent-child-search-td2166479.html

I just tried that and I couldn't make it work, but I guess it's just
my lack of knowledge. So, provided that you could make it work, you
can search for the authors in "country":"us" or whatever, then get the
IDs. Then search for books by adding an OR filter (or a bool query)
for the parent's IDs that you just found.

kimchy · February 7, 2012, 12:08pm

No, there isn't a way to search based on parent data and get back children, unless you embed the parent data in the children...

On Sunday, February 5, 2012 at 10:40 PM, Igor Semenko wrote:

Hello, I'm exploring Parent-Child feature in elasticsearch, but can't understand whether it's possible to find child by parent's field name? Sort of reverse 'has_child' query.

Here is example:

Author (parent)
-name
-country

Book (child of Author)

title
...

Can I search for all books author of which is from country:US for example?

Thanks.

Ludovic · February 7, 2012, 1:50pm

HI,

I have a question about ES and Parent/Child :

is it possible to have nested has_child filter (or query) ? now, we are
trying to post a query with 2 levels of child (parent/child/grandchild).

example of mapping :
{
"settings":{
"analysis":{
"analyzer":{
"key_lowercase":{
"tokenizer":"keyword",
"filter":"lowercase"
}
}
},
"index":{
"number_of_shards":5,
"number_of_replicas":1
}
},
"mappings":{
"type0":{
"properties":{...}
},
"type1":{
"_parent":{
"type":"type0"
},
"properties":{...}
}
"type2":{
"_parent":{
"type":"type1"
},
"properties":{...}
}
}
}

*example of query :
*
{
"query" : {
"filtered" : {
"query" : {
"bool" : {
"must" : [{...}, {...}]
}
},
"filter" : {
"has_child" : {
"type" : "type1",
"query" : {
"filtered" : {
"query" : {
"bool" : {
"must" : [{...}]
}
},
"filter" : {
"has_child" : {
"type" : "type2",
"query" : {
"term" : {...}
}
}
}
}
}
}
}
}
}
}

Thanks.

Nick_Hoffman · July 23, 2013, 3:24pm

Hi Shay. Is this still the case?

On Tuesday, 7 February 2012 07:08:15 UTC-5, kimchy wrote:

No, there isn't a way to search based on parent data and get back
children, unless you embed the parent data in the children...

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

mattweber · July 23, 2013, 3:48pm

Are you looking for the has_parent query/filter

Thanks,
Matt Weber

On Tue, Jul 23, 2013 at 8:24 AM, Nick Hoffman nick@deadorange.com wrote:

Hi Shay. Is this still the case?

On Tuesday, 7 February 2012 07:08:15 UTC-5, kimchy wrote:

No, there isn't a way to search based on parent data and get back
children, unless you embed the parent data in the children...

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Nick_Hoffman · July 23, 2013, 3:57pm

Indeed, I am. Thanks, Matt!

On Tuesday, 23 July 2013 11:48:10 UTC-4, Matt Weber wrote:

Are you looking for the has_parent query/filter

Elasticsearch Platform — Find real-time answers at scale | Elastic
Elasticsearch Platform — Find real-time answers at scale | Elastic

Thanks,
Matt Weber

On Tue, Jul 23, 2013 at 8:24 AM, Nick Hoffman <ni...@deadorange.com<javascript:>

wrote:

Hi Shay. Is this still the case?

On Tuesday, 7 February 2012 07:08:15 UTC-5, kimchy wrote:

No, there isn't a way to search based on parent data and get back
children, unless you embed the parent data in the children...

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Topic		Replies	Views
Parent/child queries are broken? Elasticsearch	8	336	July 6, 2017
Parent/Child with one to many? Elasticsearch	2	306	July 6, 2017
Book search, Parent & child mapping multiple author Elasticsearch	2	1058	December 16, 2017
Parent Child Bool Search problem Elasticsearch	1	390	July 5, 2017
Parent/Child: Find children based on parent properties Elasticsearch	7	567	July 6, 2017

Search child by parent field

Related topics