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.