1

I have a scenario like below:

Collection A has:

<field name="id" type="string" indexed="true" stored="true"/> <!--  Not unique in Collection A but unique in Collection B as uid-->
<field name="type" type="string" indexed="true" stored="true"/>

Collection B has:

<field name="uid" type="string" indexed="true" stored="true"/> <!-- unique -->
<field name="name" type="string" indexed="true" stored="true"/

Now I need to join this two collection like :

For all type='xxx' from Collection A, get me all data from Collection B.

Am new to solr, not even sure its possible or not. But this can be easily done in DB. Any suggestion?

Aka
  • 171
  • 2
  • 5
  • 13

2 Answers2

1

The above solution only works when both the collections are in the same server. If they reside in different servers, then solr cloud has limitations to it. How to join two different cores from two different Solr servers?

Aj05
  • 41
  • 3
  • Now with SOLR version 8.6.0, it is possible to join between multiple shared and multiple collection. I tried to achieve the same but getting error. Please refer https://stackoverflow.com/questions/76578595/apache-solr-from-version-8-6-0-joining-between-multiple-collections-and-multip – Chirag Shah Jun 29 '23 at 06:50
0

Something like this should help you...

{!join from=fromField to=toField fromIndex=fromCoreName}fromQuery

javacreed
  • 958
  • 1
  • 8
  • 20