Tanya, have you tried to designate it by rootEntity attribute? On Fri, Sep 21, 2018 at 11:06 PM Tanya Bompi <tanya.bo...@gmail.com> wrote:
> 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 > -- Sincerely yours Mikhail Khludnev
