Hi,
I am wondering if with a nested entity using the DataImportHandler, if
its possible to unroll the parent document with each of the child document
as a separate entry in the index.
I am using Solr 7.4.0 version.
For eg.
<entity name="Parent" query="select Id, Name, RecordKey from table1">
<field column="Id" name="id"/>
<field column="Name" name="name"/>
<entity name="Child" query="select RecordKey, Country from table2"
cacheImpl=SortedMapBackedCache" cacheKey="RecordKey" cacheLookup="Parent.
RecordKey" >
<field column="Country" name="Country"/>
</entity>
</entity>
So what i would desire the index to create multiple entries for each
Id,Name,Country combination.
Currently with the above config it combines all the entries of country
together in a single field for each Parent record.
What would the change look like? In my scenario, the child table has
multiple fields and combining all the data together for each field is not
what I desire.
Kindly let me know.
Thanks,
Tanya
