You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Alexandre Rafalovitch (JIRA)" <ji...@apache.org> on 2018/07/05 17:34:00 UTC
[jira] [Closed] (SOLR-12400) SOLR Joins for multiple collections
[ https://issues.apache.org/jira/browse/SOLR-12400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexandre Rafalovitch closed SOLR-12400.
----------------------------------------
> SOLR Joins for multiple collections
> -----------------------------------
>
> Key: SOLR-12400
> URL: https://issues.apache.org/jira/browse/SOLR-12400
> Project: Solr
> Issue Type: Wish
> Security Level: Public(Default Security Level. Issues are Public)
> Components: faceting, multicore, search
> Reporter: Nancy
> Priority: Major
>
> I have the below requirement and need help to know if it is achievable with JOINs or Block Join (Nested documents)-
> Data
> There are multiple tables, one primary table having all the basic details about product, the primary key is Product ID. There are 6-7 other tables having other details of product, it has Product ID column too but can have multiple entries for single Product ID.
> Can you please let me know if the below are possible-
> # Can we get data from multiple collections in the search results. The results should contain only one record for a single product ID?
> # Can we search across multiple collections in a single query and then club the results, so that final search results will have single result for each Product ID.
> # Can we perform join on more than 2 collections as we need to search across 6-7 collections and then merge the data based on product ID.
> # Can we query Parent and child in nested index at the same time. Example- perform search on column1 from Parent and Column2 from Child and get the parent records with nested child in search results?
> # If we can perform fielded search across multiple collections in the single query,will the filters from different collections be returned in a single search response
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org