Thanks, confirmed by trying w/ 4.3.1 that the join works with the outer
collection distributed/sharded so long as the inner collection is not
distributed/sharded.
Chris
On Tue, Jun 25, 2013 at 4:55 PM, Upayavira <u...@odoko.co.uk> wrote:
> I have never heard mention that joins support distributed search, so you
> cannot do a join against a sharded core.
>
> However, if from your example, innerCollection was replicated across all
> nodes, I would think that should work, because all that comes back from
> each server when a distributed search happens is the best 'n' matches,
> so exactly how those 'n' matches were located doesn't matter
> particularly.
>
> Simpler answer: try it!
>
> Upayavira
>
> On Tue, Jun 25, 2013, at 11:25 PM, Chris Toomey wrote:
> > What are the restrictions/limitations w.r.t. joins when using SolrCloud?
> >
> > Say I have a 3-node cluster and both my "outer" and "inner" collections
> > are
> > sharded 3 ways across the cluster. Could I do a query such as
> >
> "select?q={!join+from=inner_id+fromIndex=innerCollection+to=outer_id}xx:foo&collection=outerCollection"?
> >
> > Or if the above isn't supported, would it be if the "inner" collection
> > was
> > not sharded and was replicated across all 3 nodes, so that it existed in
> > its entirety on each node?
> >
> > thx,
> > Chris
>
