CODEWITHSUNDEEP
javasolrsolrj
Swaraj
Swaraj

Reputation: 589

How to get all data from both core in SOLR joins

I have 2 core in Solr - Hotel and City. I want to do join operation on it so that I get all data from hotel as well as city. I am using the query as

    http://localhost:8080/solr/hotel/select?q=*:*&fq={!join%20fromIndex=city%20from=id%20to=id}id:200709062148134302

In result I am getting data only from hotel core not from city core.

is there an way to get data from both core?? please suggest...

Upvotes: 1

Views: 516

Answers (1)

MatsLindh
MatsLindh

Reputation: 52792

No. Solr joins are comparable to INNER JOIN in SQL, as shown in the example from the Solr Wiki:

SELECT xxx, yyy
FROM collection1
WHERE outer_id IN (SELECT inner_id FROM collection1 where zzz = "vvv")

Upvotes: 1

Related Questions