Re: How to achieve join like behavior on solr-cloud

[Alok Bhandari]

Hi Dennis ,

thanks for your reply. As I wanted this for some production system so may
not be able to upgrade to under-development branch of solr.

but thanks a lot for pointing me to this possible approach.



--
View this message in context: 
http://lucene.472066.n3.nabble.com/How-to-achieve-join-like-behavior-on-solr-cloud-tp4247703p4247896.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: How to achieve join like behavior on solr-cloud

[Dennis Gove]

Alok,

You can use the Streaming API to achieve this goal but joins have not been
added to a 5.X release (at least I don't see it on the changelog). They do
exist on trunk and will be a part of Solr 6.

Documentation is still under development but if you wanted to play around
with it now you could perform an inner join with the expression

innerJoin(
  search(products, fl="id,itemDescription", q="type:book", sort="id asc"),
  search(orderLines, fl="orderId,productId", q="*:*",sort="productId asc"),
  on="id=productId"
)

On Tue, Dec 29, 2015 at 6:18 AM, Alok Bhandari <
alokomprakashbhand...@gmail.com> wrote:

> Hello ,
>
> I am aware of the fact that Solr (I am using 5.2) does not support join on
> distributed search with documents to be joined residing on different
> shards/collections.
>
> My use case is I want to fetch uuid of documents that are resultant of a
> search and also those docs which are outside this search but have "related"
> field same as one of the search result docs. This is a typical join
> scenario.
>
> Is there some way using streaming-api to achieve this behavior . Or some
> other approach.
>
> Thanks.
> Alok
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/How-to-achieve-join-like-behavior-on-solr-cloud-tp4247703.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>

How to achieve join like behavior on solr-cloud

[Alok Bhandari]

Hello ,

I am aware of the fact that Solr (I am using 5.2) does not support join on
distributed search with documents to be joined residing on different
shards/collections.

My use case is I want to fetch uuid of documents that are resultant of a
search and also those docs which are outside this search but have "related"
field same as one of the search result docs. This is a typical join
scenario. 

Is there some way using streaming-api to achieve this behavior . Or some
other approach.

Thanks.
Alok



--
View this message in context: 
http://lucene.472066.n3.nabble.com/How-to-achieve-join-like-behavior-on-solr-cloud-tp4247703.html
Sent from the Solr - User mailing list archive at Nabble.com.