CODEWITHSUNDEEP
searchsolrlucene
Kamal Nayan
Kamal Nayan

Reputation: 1940

How to join two solr indexes and get result from both?

I have two indices, on two different cores:

firstCore {id, fid, resid, status}
secondCore {id, resid, title, name, cat, role, exp}

I want to execute a join query that will give result of both the indexes, with matching criteria, I mean to display id, fid, resid, status, title, name, cat, role, exp. We can omit id, if needed, and this is id of secondCore.

What I tried:
1. Following query returned: id, fid, resid, status i.e. of firstCore

 http://localhost:8888/solr/firstCore/select?q=*:*&fq={!join from=resid to=resid fromIndex=secondCore}resid:546384

  1. Following query returned: id, resid, title, name, cat, role, exp, i.e. of secondCore.

    http://localhost:8888/solr/secondCore/select?q=*:*&fq={!join%20from=resid%20to=resid%20fromIndex=firstCore}resid:546384

How can I get, id, fid, resid, status, title, name, cat, role, exp?

Upvotes: 0

Views: 333

Answers (1)

Aman Tandon
Aman Tandon

Reputation: 1509

This can be achieved by sharding but as of now there is no solution for this.

This might help, check out http://mail-archives.apache.org/mod_mbox/lucene-solr-user/201510.mbox/%3CCAEYSxhVie4oei+7sMFuAEZgOUxbJ-YM_hzHh54kgWiPqJuoFhQ@mail.gmail.com%3E

Upvotes: 1

Related Questions