You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Ahson Iqbal <mi...@yahoo.com> on 2011/09/20 07:21:17 UTC

How To perform SQL Like Join

Hi

As we do join two or more tables in sql, can we join 2 or more indexes in solr as well. if yes than in which version.

Regards
Ahsan

Re: How To perform SQL Like Join

Posted by stockii <st...@googlemail.com>.
http://wiki.apache.org/solr/Join

-----
------------------------------- System ----------------------------------------

One Server, 12 GB RAM, 2 Solr Instances, 8 Cores, 
1 Core with 45 Million Documents other Cores < 200.000

- Solr1 for Search-Requests - commit every Minute  - 5GB Xmx
- Solr2 for Update-Request  - delta every Minute - 4GB Xmx
--
View this message in context: http://lucene.472066.n3.nabble.com/How-To-perform-SQL-Like-Join-tp3351090p3352322.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: How To perform SQL Like Join

Posted by da...@ontrenet.com.
Hi,
  Maybe you are aware of this[1] already but I'm not sure its status. 
It seems to be removed currently from Solr. Also, I'm not sure if it
works cross-index, but thought you might look there.

Darren

[1] https://issues.apache.org/jira/browse/SOLR-2272

On Mon, 19 Sep 2011 22:21:17 -0700 (PDT), Ahson Iqbal
<mi...@yahoo.com>
wrote:
> Hi
> 
> As we do join two or more tables in sql, can we join 2 or more indexes
in
> solr as well. if yes than in which version.
> 
> Regards
> Ahsan