Re: Solr equivalent of relational joins on nested documents

2021-05-07 Thread Alain Rogister
Thanks! I am aware of the examples in the docs but they don't quite answer my specific question about parent/child joins on multiple levels in a general way. Here is a slightly modified example that actually works on ElasticSearch with an equivalent (nested) schema. I can't figure out how to exp

Re: Solr equivalent of relational joins on nested documents

2021-05-05 Thread Norbert Kutasi
Hello Alain, If I was going to implement queries on deeply nested documents, I can see quite a few examples here : https://solr.apache.org/guide/8_8/searching-nested-documents.html#parent-query-parser In a hierarchy like below the following query with a criteria on _nest_path_ suppose to retriev

Re: Solr equivalent of relational joins on nested documents

2021-05-04 Thread Timothy Potter
Did you try routing all docs for the same customer ID to the same shard (not block join), just docs of different types in the same shard based on customer ID and then using Joins? On Tue, May 4, 2021 at 4:06 AM Alain Rogister wrote: > > It sounds like nobody knows. Just one last try. Up ! > > Tx

Re: Solr equivalent of relational joins on nested documents

2021-05-04 Thread Alain Rogister
It sounds like nobody knows. Just one last try. Up ! Tx On 2021/04/21 10:08:16, Alain Rogister wrote: > Hi, > > Imagine that you have been tasked with designing a Solr-based system that > indexes and queries data aggregated from several relational databases. All > the data items are ultimate

Re: Solr equivalent of relational joins on nested documents

2021-04-23 Thread Alain Rogister
Thanks, but as far as I understand this is "just" a different, Json-based syntax for the same underlying feature (join queries, no support for parent/child block joins). So alas! my questions remain open. I have been unable so far to find any comprehensive example I could relate to, and I have

Re: Solr equivalent of relational joins on nested documents

2021-04-23 Thread Alain Rogister
Thanks, Tim. Alas, this is nothing more than a join query in Json syntax, so does not really explain how the sort of query I am looking for could be expressed. Any takers ? A. On 2021/04/22 20:45:37, Timothy Potter wrote: > Might take a look at the domain join stuff in JSON facets too: > http

Re: Solr equivalent of relational joins on nested documents

2021-04-22 Thread Timothy Potter
Might take a look at the domain join stuff in JSON facets too: https://solr.apache.org/guide/8_8/json-faceting-domain-changes.html#join-query-domain-changes ... I've seen this work where you index a common ID field in each document (different document types in the same collection each having a comm

Re: Solr equivalent of relational joins on nested documents

2021-04-22 Thread Alain Rogister
Hi, Thanks, I knew about that one, but note the date : 2012. A lot has changed in the meantime, specifically block joins and improved nested documents support. But I wonder about what can be expressed, even if we leave performance issues aside for another post. I can't find a comprehensive exam

Re: Solr equivalent of relational joins on nested documents

2021-04-22 Thread Eran Buchnick
Read this before going deeper https://lucidworks.com/post/solr-and-joins/ Good luck On Wed, 21 Apr 2021, 13:55 Alain Rogister, wrote: > Hi, > > Imagine that you have been tasked with designing a Solr-based system that > indexes and queries data aggregated from several relational databases. All

Solr equivalent of relational joins on nested documents

2021-04-21 Thread Alain Rogister
Hi, Imagine that you have been tasked with designing a Solr-based system that indexes and queries data aggregated from several relational databases. All the data items are ultimately related to a common object type, so the logical data schema looks like : Customer Profile Events