When you want the results of 'b' in the results of the join, you'll have to reconsider and merge 'b' into 'a' as suggested by Erick... This because the results of the join are not a combination of the 2 collections (as with " select a*,b.* " ). In the 'search' world, you can look at a join as a fq (filter on 'to' field with 'to'='from' field of query in fromindex "b") on the query in collection "a". So results from query in fromindex "b" are not used/retained when querying "a" except for the values used for setting the 'to' field in the filter.
------------------------------ Kind regards, Paul Blanchaert <http://sr-sl.net/p/paul> www.search-solutions.net Tel: +32 497 05.01.03 [image: View my profile on LinkedIn] <http://be.linkedin.com/in/paulblanchaert>view <http://be.linkedin.com/in/paulblanchaert> or connect <https://www.linkedin.com/inviteFromProfile?from=profile&key=682342&firstName=Paul&lastName=Blanchaert> ------------------------------ Please consider the environment before printing this e-mail. This message is explicitly subject to the conditions of the e-mail disclaimer, available via the following link: mail-disclaimer <https://www.search-solutions.net/en/articles/mail-disclaimer>. If you are unable to consult this e-mail disclaimer, please notify the sender at once. On 17 November 2015 at 09:05, soledede_w...@ehsy.com <soledede_w...@ehsy.com > wrote: > > Yes,Thanks,But It just support (select * from A where A.id in(select id > from B where...)) or not > I hope It is (select a*,b.* from A a join B b on A.id = B.id) > How to merge the result of shards > > Thanks > > > soledede_w...@ehsy.com > > From: Paul Blanchaert > Date: 2015-11-17 15:57 > To: solr-user > Subject: Re: Re: how to join search mutiple collection in sorlcloud > You might want to take a look at/follow up upon SOLR-8297 > <https://issues.apache.org/jira/browse/SOLR-8297> > > > On Tue, 17 Nov 2015 at 04:14 soledede_w...@ehsy.com < > soledede_w...@ehsy.com> > wrote: > > > > > Thanks Erick > > > > I think if can use hash for doc_id to all shards, then do join,Last merge > > the result in a node. > > > > > > soledede_w...@ehsy.com > > > > From: Erick Erickson > > Date: 2015-11-17 11:10 > > To: solr-user > > Subject: Re: how to join search mutiple collection in sorlcloud > > In a word, no. At least probably not. > > > > There are some JIRA tickets dealing with distributed joins, and some > > with certain restrictions, specifically if the second (from) > > collection can be reproduced on every slice of the first (to) > > collection. > > > > In the trunk (6.0), there's the ParallelSQL stuff which has some > > relevance, but it's still not a full RDBMS type join. > > > > The usual recommendation is to flatten your data if at all possible so > > you don't _have_ two collections. > > > > Solr is a wonderful search engine. It is not an RDBMS and whenever I > > find myself trying to make it behave like an RDBMS I try to rethink > > the architecture. > > > > On Mon, Nov 16, 2015 at 6:56 PM, soledede_w...@ehsy.com > > <soledede_w...@ehsy.com> wrote: > > > Dear @solr_lucene > > > currently,I am using solr5.3.1,I have a requirement, I need search like > > in relation database(select * from A ,B where A.id=B.id),Can we implments > > with solr5.3 in SolrCloud mode,I have two collection,2 shards per > > collection. > > > Help me please. > > > > > > Thanks > > > > > > > > > soledede_w...@ehsy.com > > > -- > ------------------------------ > > > Kind regards, > > Paul Blanchaert <http://sr-sl.net/p/paul> > www.search-solutions.net > Tel: +32 497 05.01.03 > [image: View my profile on LinkedIn] > <http://be.linkedin.com/in/paulblanchaert>view > <http://be.linkedin.com/in/paulblanchaert> or connect > < > https://www.linkedin.com/inviteFromProfile?from=profile&key=682342&firstName=Paul&lastName=Blanchaert > > > > ------------------------------ > > Please consider the environment before printing this e-mail. > > This message is explicitly subject to the conditions of the e-mail > disclaimer, available via the following link: mail-disclaimer > <https://www.search-solutions.net/en/articles/mail-disclaimer>. If you are > unable to consult this e-mail disclaimer, please notify the sender at once. >
