Re: Equivalent of SQL JOIN in SOLR across multiple cores
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//select?q={!join from=docId to=id fromIndex=}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
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 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.