[jira] [Resolved] (SOLR-12400) SOLR Joins for multiple collections

["Erick Erickson (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SOLR-12400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Erick Erickson resolved SOLR-12400.
-----------------------------------
    Resolution: Invalid

This issue tracker is not a support portal. Please raise this question on the user's list at solr-user@lucene.apache.org, see: (http://lucene.apache.org/solr/community.html#mailing-lists-irc) there are a _lot_ more people watching that list who may be able to help and you'll probably get responses much more quickly.

If it's determined that this really is a code issue in Solr and not a configuration/usage problem, we can raise a new JIRA or reopen this one.

> 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