a field/column id. The fact that you omitted
>> it, was an oversight, or not necessary, I suppose.
>> 3) Your statement about uniqueKey needs some clarification:
>> - I do have the following in my schema.xml: id, I
>> also added comboId. Are both necessary?
>>
&
t; also added comboId. Are both necessary?
>
> Thanks
>
> ** julio
>
> -----Original Message-----
> From: Shalin Shekhar Mangar [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 04, 2008 11:01 AM
> To: solr-user@lucene.apache.org
> Subject: Re: How to describe 2 entiti
"SELECT id,name,birth_date,type_id FROM pets
> WHERE owner_id='${owners.id}'"
>parentDeltaQuery="SELECT id FROM owners WHERE
> id=${pets.owner_id}">
>
>
>
>
>
>
>
>
> The debug output for one
27;"
>parentDeltaQuery="SELECT id FROM owners WHERE
> id=${pets.owner_id}">
>
>
>
>
>
>
>
>
> The debug output for one row from the dataImporter while iterating over
> pets
> where the first row owne
_id in the pets table is
>> currently a number and thus will not match the modified combo id
>> generated for the owners' id column.
>>
>> So, somehow, I need to be able to either remove the 'owners-' suffix
>> before comparing, or append the same suff
to either remove the 'owners-' suffix before
>> comparing, or append the same suffix to the pets.owner_id value prior to
>> comparing.
>>
>> Thanks
>>
>> ** julio
>>
>> -Original Message-
>> From: Noble Paul ??? ?? [mail
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> The debug output of the data import looks as follows:
>>>
>>>
>>> -
>>> -
>>>
OTECTED]
Sent: Monday, June 02, 2008 9:20 PM
To: solr-user@lucene.apache.org
Subject: Re: How to describe 2 entities in dataConfig for the DataImporter?
hi Julio,
delete my previous response. In your schema , 'id' is the uniqueKey.
make 'comboid' the unique key. Becau
-
>> select id,first_name,last_name FROM owners
>> 0:0:0.15
>> --- row #1-
>> 1
>> George
>> Franklin
>> -
>> -
>> -----------------
>>
narrow down the scope of the problem).
>>>
>>>
>>>>>query="select id as idAlias,first_name,last_name FROM vets"
>>> deltaQuery="SELECT id as idAlias FROM vets WHERE
>>> last_modified > '${dataimport
gt;
>>> template="vets-${vets.idAlias}"/>
>>
>>
>>
>>
>>
>>
>> Thanks again.
>>
>> ** julio
>>
>> -Original Message-
>> From: Shalin Shekhar Mangar [mailto:[EMAIL PROTEC
> template="vets-${vets.idAlias}"/>
>>
>>
>>
>>
>>
>>
>> Thanks again.
>>
>> ** julio
>>
>> -Original Message-
>> From: Shalin Shekhar Mangar [mailto:[EMAIL PROTECTED]
>> Sent:
/>
>>
>>
>>
>>
>>
>>
>> Thanks again.
>>
>> ** julio
>>
>> -Original Message-
>> From: Shalin Shekhar Mangar [mailto:[EMAIL PROTECTED]
>> Sent: Friday, May 30, 2008 11:38 AM
>> To: s
-
> From: Shalin Shekhar Mangar [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 30, 2008 11:38 AM
> To: solr-user@lucene.apache.org
> Subject: Re: How to describe 2 entities in dataConfig for the DataImporter?
>
> The surname is used just as an example of a field.
>
> The
ekhar Mangar [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2008 11:38 AM
To: solr-user@lucene.apache.org
Subject: Re: How to describe 2 entities in dataConfig for the DataImporter?
The surname is used just as an example of a field.
The NullPointerException is because the same field "id" tr
>
> ...
>
> Am I missing a surname? Whatever that may be?
>
> Thanks
>
> ** julio
>
> -Original Message-
> From: Noble Paul ??????? ?????? [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 29, 2008 11:10 PM
> To: solr-user@lucene.apac
, 2008 6:04 PM
To: solr-user@lucene.apache.org
Subject: RE: How to describe 2 entities in dataConfig for the DataImporter?
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
al Message-
From: Noble Paul ??? ?? [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2008 11:10 PM
To: solr-user@lucene.apache.org
Subject: Re: How to describe 2 entities in dataConfig for the DataImporter?
Sorry I forgot to mention that.
http://wiki.apache.org/solr/DataImportHa
tting 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@luce
e that the id 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: R
008 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
and i
r due to "id"
>> conflicts. Currently my id is defined in my schema as
>>
>>
>> Do I have to create a new "id" field?
>>
>> Thanks
>>
>> ** julio
>>
>> -Original Message-
>> From: Shalin Shekhar Mangar [
t;
>
> 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
"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
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
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)
CASE 2)
26 matches
Mail list logo