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&ver >> 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.
