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 bijalcm <bi...@gmail.com> on 2013/12/11 15:25:05 UTC
Equivalent of SQL JOIN in SOLR across multiple cores
1, Are the cores join-able?
2. Could you give me an example about how to write a multiple core join?
3. Can we do equivalent of JOIN in SOLR across multiple cores
Select T1.*,T2.*
FROM Table1 T1,Table2 T2
WHERE T1.id = T2.id
--
View this message in context: http://lucene.472066.n3.nabble.com/Equivalent-of-SQL-JOIN-in-SOLR-across-multiple-cores-tp4106152.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Equivalent of SQL JOIN in SOLR across multiple cores
Posted by bijalcm <bi...@gmail.com>.
I had gone through link - http://wiki.apache.org/solr/Join and it says there
is a Limitation in JOIN, you will be able to get resulting documents
containing fields in either of two
I have used below query
http://localhost:8983/solr/<coreTO>/select?q={!join from=docId to=id
fromIndex=<coreFROM>}query
I want consolidation of fields from multiple cores and there are two fields
in common across all cores.
I have data stored in normalized form across 3 cores on same JVM. Want to
merge and select multiple fields depending on WHERE clause/common fields in
each core.
Any help would be appreciated!
--
View this message in context: http://lucene.472066.n3.nabble.com/Equivalent-of-SQL-JOIN-in-SOLR-across-multiple-cores-tp4106152p4106344.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Equivalent of SQL JOIN in SOLR across multiple cores
Posted by Ahmet Arslan <io...@yahoo.com>.
Hi,
There are some join support :
1) Query Time Join (works across cores)
https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-JoinQueryParser
http://wiki.apache.org/solr/Join
2) Block Joins
https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-BlockJoinQueryParsers
An open jira : https://issues.apache.org/jira/browse/SOLR-4787
On Wednesday, December 11, 2013 4:28 PM, bijalcm <bi...@gmail.com> wrote:
1, Are the cores join-able?
2. Could you give me an example about how to write a multiple core join?
3. Can we do equivalent of JOIN in SOLR across multiple cores
Select T1.*,T2.*
FROM Table1 T1,Table2 T2
WHERE T1.id = T2.id
--
View this message in context: http://lucene.472066.n3.nabble.com/Equivalent-of-SQL-JOIN-in-SOLR-across-multiple-cores-tp4106152.html
Sent from the Solr - User mailing list archive at Nabble.com.