RE: Can we query across collections in SOLR?

2016-10-24 Thread Preeti Bhat
AM To: solr-user@lucene.apache.org Subject: Re: Can we query across collections in SOLR? Take a look at Streaming Expressions in Solr 6.x - https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=61330338. This supports cross-collection joining. - Denns On Fri, Oct 21, 2016 at 7:42 AM

Re: Can we query across collections in SOLR?

2016-10-22 Thread Dennis Gove
Take a look at Streaming Expressions in Solr 6.x - https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=61330338. This supports cross-collection joining. - Denns On Fri, Oct 21, 2016 at 7:42 AM, Preeti Bhat wrote: > Hi All, > > > > I have an requirement where in SQL we have two diff

Re: Can we query across collections in SOLR?

2016-10-21 Thread Erick Erickson
Join queries don't work across sharded collections. Well, there's a special case where the "from" collection can be hosted in-toto on every replica the "to" collection is hosted on, but If you can denormalize the data, that's always the first option. Whenever I find myself trying to express s

Re: Can we query across collections in SOLR?

2016-10-21 Thread Susheel Kumar
You may wanna to checkout below these options as well https://cwiki.apache.org/confluence/display/solr/Advanced+Distributed+Request+Options https://cwiki.apache.org/confluence/display/solr/Streaming+Expressions#StreamingExpressions-innerJoin On Fri, Oct 21, 2016 at 7:49 AM, Adi wrote: > Hi, >

Re: Can we query across collections in SOLR?

2016-10-21 Thread Adi
Hi, Check documentation on join parser, https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-JoinQueryParser Regards, Adi On Fri, Oct 21, 2016, 5:11 PM Preeti Bhat wrote: > Hi All, > > I have an requirement where in SQL we have two different sets of data like > Company and

Can we query across collections in SOLR?

2016-10-21 Thread Preeti Bhat
Hi All, I have an requirement where in SQL we have two different sets of data like Company and Contact in SQL. We are planning to get this to SOLR, I wanted to know whether we can have two separate collections in SOLR and say have a link between them with say id of one collection or if there

Recall: Can we query across collections in SOLR?

2016-10-21 Thread Preeti Bhat
Preeti Bhat would like to recall the message, "Can we query across collections in SOLR?". NOTICE TO RECIPIENTS: This communication may contain confidential and/or privileged information. If you are not the intended recipient (or have received this communication in error) please

Can we query across collections in SOLR?

2016-10-21 Thread Preeti Bhat
Hi All, I have an requirement where in SQL we have two different sets of data like Company and Contact in SQL. We are planning to get this to SOLR, I wanted to know whether we can have two separate collections in SOLR and say have a link between them with say id of one collection or if there

Can we query across collections in SOLR?

2016-10-21 Thread Preeti Bhat
Hi All, I have an requirement where in SQL we have two different sets of data like Company and Contact in SQL. We are planning to get this to SOLR, I wanted to know whether we can have two separate collections in SOLR and say have a link between them with say id of one collection or if there an