Re: Re: how to join search mutiple collection in sorlcloud

2015-11-17 Thread Paul Blanchaert
17 November 2015 at 09:05, 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 > >

Re: Re: how to join search mutiple collection in sorlcloud

2015-11-17 Thread soledede_w...@ehsy.com
: 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 wrote: > > Thanks Erick > > I think if can use hash

Re: Re: how to join search mutiple collection in sorlcloud

2015-11-16 Thread Paul Blanchaert
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 d

Re: Re: how to join search mutiple collection in sorlcloud

2015-11-16 Thread soledede_w...@ehsy.com
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

Re: how to join search mutiple collection in sorlcloud

2015-11-16 Thread Erick Erickson
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