My understanding is the same that "{!join...}" does not work in SolrCloud (aka distributed search) based on: 1. https://issues.apache.org/jira/browse/LUCENE-3759 2. http://wiki.apache.org/solr/DistributedSearch --- see "Limitations" section which refers to the JIRA above
-- James -----Original Message----- From: Upayavira [mailto:u...@odoko.co.uk] Sent: Tuesday, June 25, 2013 7:55 PM To: solr-user@lucene.apache.org Subject: Re: Joins with SolrCloud 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