Cross-index parent/child support?

Greg · February 4, 2012, 11:50am

Hi all

Does Elasticsearch support mapping a child to a parent in a different
index?

Thanks
Greg

kimchy · February 5, 2012, 4:31pm

No...

On Saturday, February 4, 2012 at 1:50 PM, Greg wrote:

Hi all

Does Elasticsearch support mapping a child to a parent in a different
index?

Thanks
Greg

Thomas_Bolis · November 26, 2013, 10:18am

Hi,

I'm bringing this question back into surface and I wanted just to ask
whether such a functionality is planned or thought to be supported in the
future. The thing is that it would be very useful in the case that we need
to support (at least one way) analytics for uniqueness. Actually is there a
way to do it with the Lookup functionality?

Thanks

On Saturday, 4 February 2012 13:50:19 UTC+2, Greg wrote:

Hi all

Does Elasticsearch support mapping a child to a parent in a different
index?

Thanks
Greg

--
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 · November 26, 2013, 5:04pm

Hi Thomas,

Yes, soon.

github.com/elastic/elasticsearch

Terms Lookup by Query/Filter (aka. Join Filter)

elastic:master ← mattweber:terms_lookup_by_query

opened 05:20PM - 01 Jul 13 UTC

mattweber

+4543 -187

This PR adds support for generating a terms filter based on the field values of …documents matching a specified lookup query/filter. The value of the configurable "path" field is collected from the field data cache for each document matching the lookup query/filter and is then used to filter the main query. This is can also be called a join filter. This PR abstracts the TermsLookup functionality in order to support multiple lookup methods. The existing functionality is moved into FieldTermsLookup and the new query based lookup is in QueryTermsLookup. All existing caching functionality works with the new query based lookup for increased performance. During testing of I found that one of the performance bottlenecks was generating the Lucene TermsFilter on large sets of terms (probably since it sorts the terms). I have created a FieldDataTermsFilter that uses the field data cache to lookup value of the field being filtered and compare it to the set of gathered terms. This significantly increased performance at the cost of higher memory usage. Currently a TermsFilter is used when the number of filtering terms is less than 1024 and the FieldDataTermsFilter is used for everything else. This should eventually be configurable or we need to perform some test to find the optimal value. Examples: Replicate a has_child query by joining on the child's "pid" field to the parent's "id" field for each child that has the tag "something". ``` curl -XPOST 'http://localhost:9200/parentIndex/_search' -d '{ "query": { "constant_score": { "filter": { "terms": { "id": { "index": "childIndex", "type": "childType", "path": "pid", "query": { "term": { "tag": "something" } } } } } } } }' ``` Lookup companies that offer products or services mentioning elasticsearch. Notice that products and services are kept in their own indices. ``` curl -XPOST 'http://localhost:9200/companies/_search' -d '{ "query": { "constant_score": { "filter": { "terms": { "company_id": { "indices": ["products", "services"], "path": "company_id", "filter": { "term": { "description": "elasticsearch" } } } } } } } }' ```

Thanks,
Matt Weber

On Tue, Nov 26, 2013 at 2:18 AM, Thomas thomas.bolis@gmail.com wrote:

Hi,

I'm bringing this question back into surface and I wanted just to ask
whether such a functionality is planned or thought to be supported in the
future. The thing is that it would be very useful in the case that we need
to support (at least one way) analytics for uniqueness. Actually is there a
way to do it with the Lookup functionality?

Thanks

On Saturday, 4 February 2012 13:50:19 UTC+2, Greg wrote:

Hi all

Does Elasticsearch support mapping a child to a parent in a different
index?

Thanks
Greg

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAJ3KEoBA_vmz9jjmy-xg%2B0-%3Ds6mcVkVb_x2fY%2BC6cbt0OVSZ2g%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Thomas_Bolis · November 27, 2013, 8:20am

Great news,

Thank you Matt

On Tuesday, 26 November 2013 19:04:33 UTC+2, Matt Weber wrote:

Hi Thomas,

Yes, soon.

Terms Lookup by Query/Filter (aka. Join Filter) by mattweber · Pull Request #3278 · elastic/elasticsearch · GitHub

Thanks,
Matt Weber

On Tue, Nov 26, 2013 at 2:18 AM, Thomas <thomas...@gmail.com <javascript:>

wrote:

Hi,

I'm bringing this question back into surface and I wanted just to ask
whether such a functionality is planned or thought to be supported in the
future. The thing is that it would be very useful in the case that we need
to support (at least one way) analytics for uniqueness. Actually is there a
way to do it with the Lookup functionality?

Thanks

On Saturday, 4 February 2012 13:50:19 UTC+2, Greg wrote:

Hi all

Does Elasticsearch support mapping a child to a parent in a different
index?

Thanks
Greg

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/5ed27f47-72d0-4530-a537-27d745053101%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Topic		Replies	Views
Parent-Child and elastic 6 Elasticsearch	7	5321	June 29, 2017
Hierarchical query with terms lookup filter Elasticsearch	4	3467	July 6, 2017
HOW-TO: terms lookup or sth-else Elasticsearch	4	931	July 5, 2017
FEATURE REQUEST: parent.field query support for query_string queries Elasticsearch	4	902	July 5, 2017
Parent/Child use case Elasticsearch	7	1118	July 6, 2017

Cross-index parent/child support?

Related topics