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
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
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
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
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