Noble, I tried the template setting for the "id" field, but I didn't notice any different behavior. I also didn't see where this would be reflected. I looked at the fields and the debug output for the dataImporter and couldn't see any reference to a modified id name (per the template instructions).
The behavior in the end seemed to be the same. Did I miss anything? I assume that the <uniqueKey>id</uniqueKey> setting in the schema.xml remains the same? Thanks again ** julio -----Original Message----- From: Noble Paul ??????? ?????? [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2008 9:46 PM To: solr-user@lucene.apache.org Subject: Re: How to describe 2 entities in dataConfig for the DataImporter? Consider constructing the id concatenating an extra string for each document . You can construct that field using the TeplateTransformer. in the entity owners keep the id as <field column="id" name="id" template="owners-${owners.id}"/> and in vets <field column="id" name="id" template="vets-${vets.id}"/> or anything else which can make it unique --Noble On Fri, May 30, 2008 at 10:05 AM, Shalin Shekhar Mangar <[EMAIL PROTECTED]> wrote: > That will happen only if id is the uniqueKey in Solr and the id coming > from both your tables have same values. In that case, they will > overwrite each other. You will need a separate uniqueKey (on other > than id field). > > On Fri, May 30, 2008 at 6:34 AM, Julio Castillo <[EMAIL PROTECTED]> wrote: >> Thanks Shalin, >> I tried putting everything under the same document (two different >> unrelated entities), and got a bit further. >> >> My problem now appears to be both of them stepping on each other due to "id" >> conflicts. Currently my id is defined in my schema as <field >> name="id" type="long" indexed="true" stored="true" required="true"/> >> >> Do I have to create a new "id" field? >> >> Thanks >> >> ** julio >> >> -----Original Message----- >> From: Shalin Shekhar Mangar [mailto:[EMAIL PROTECTED] >> Sent: Thursday, May 29, 2008 11:40 AM >> To: solr-user@lucene.apache.org >> Subject: Re: How to describe 2 entities in dataConfig for the DataImporter? >> >> Hi Julio, >> >> The first data-config is correct. >> >> You're running DataImportHandler in debug mode which creates only the >> first 10 documents by default. You can also add count=N to index only >> the first N documents. But this is intended only for debugging >> purposes. If you want to do a full-import just use >> /dataimport?command=full-import. By default, a full-import automatically cleans and commits. >> >> Hope that helps. >> >> On Thu, May 29, 2008 at 11:42 PM, Julio Castillo >> <[EMAIL PROTECTED]> >> wrote: >>> I have 2 dB tables unrelated to each other that I want to index. >>> >>> I have tried 2 approaches for specifying them in my data-config.xml file. >>> None of them seem to work (it seems I can only get data for the >>> first one listed). >>> >>> CASE 1) >>> <dataConfig> >>> <document name="test"> >>> <entity name="owners" pk="id" query="...."> >>> <field column="id" name="id"/> >>> <field column=name" name="userName"/> >>> </entity> >>> <entity name="vets" pk="id" query="...."> >>> <field column="id" name="id"/> >>> <field column=name" name="userName"/> >>> </entity> >>> </document> >>> </dataConfig> >>> >>> CASE 2) >>> <dataConfig> >>> <document name="test-1"> >>> <entity name="owners" pk="id" query="...."> >>> <field column="id" name="id"/> >>> <field column=name" name="userName"/> >>> </entity> >>> </document> >>> <document name="test-2"> >>> <entity name="vets" pk="id" query="...."> >>> <field column="id" name="id"/> >>> <field column=name" name="userName"/> >>> </entity> >>> </document> >>> </dataConfig> >>> >>> I ran the dataImporter as follows >>> http://localhost:2455/solr/dataimport?command=full-import&debug=on&v >>> er >>> bose=t >>> rue&clean=true&commit=true >>> >>> After running Case 1 the output only shows documents under entity:owners. >>> And an empty reference to entity:vets (no data). >>> >>> After running Case 2, the output only shows documents under entity:owners. >>> No references to entity:vets. >>> >>> In either case, I have commented out the entity:owners and I do see >>> the entity:vets data then. >>> >>> Thanks for your assistance >>> >>> Julio Castillo >>> >>> >> >> >> >> -- >> Regards, >> Shalin Shekhar Mangar. >> >> > > > > -- > Regards, > Shalin Shekhar Mangar. > -- --Noble Paul
