CODEWITHSUNDEEP
solrsolrj
Varun Deep
Varun Deep

Reputation: 11

Is there anyway we can use the Left Join in the SOLR?

I am working on converting RDBMS query to SOLR. Here i am facing issue with Left Outer join. Is SOLR support Left outer Join? If yes, what are ways i can implement it. Thanks

Here is the table which i am try to convert into SOLR: 

SELECT * FROM abc cg LEFT OUTER JOIN xyz ac 
ON cg.S_ID = ac.CHILD_ID INNER JOIN abc cg1 ON cg1.S_ID = ac.PRENT_ID;

Upvotes: 0

Views: 1136

Answers (1)

Hugo Zaragoza
Hugo Zaragoza

Reputation: 601

Solr implements some joins (see http://wiki.apache.org/solr/Join), but you should try to avoid them if you can if you are trying to get high performance querying out of SOLR (https://lucidworks.com/blog/2012/06/20/solr-and-joins/)

Upvotes: 1

Related Questions