Nancy created SOLR-12400:
----------------------------
Summary: 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
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: [email protected]
For additional commands, e-mail: [email protected]
