db-import.xml:
<entity name="doctor" pk= "person_id" transformer=“Some transformer"
query="SELECT p.person_id, p.details, p.authz_id,
p.last_modified, a.address_info from person p, address a where p.person_id =
a.person_id"
deltaImportQuery="SELECT p.person_id, p.authz_id, p.details,
p.last_modified, a.address_info from person p, address a where p.person_id =
a.person_id and p.person_id='${dataimporter.delta.person_id}'"
deltaQuery="SELECT person_id from person where last_modified
> '${dataimporter.last_index_time}'">
</entity>
schema.xml:
<dynamicField name="person_*" type="string" indexed="true" stored="true"/>
<field name="person_id" type="string" indexed="true" stored="true"/>
<uniqueKey>person_id</uniqueKey>
Thanks
Peri
On May 31, 2014, at 8:05 AM, Ahmet Arslan <[email protected]> wrote:
> Hi,
>
> Did you restart solr? Can you paste relevant portions of data-config.xml and
> schema.xml?
>
>
>
> On Saturday, May 31, 2014 3:46 AM, PeriS <[email protected]> wrote:
> I added the primaryKey as the <uniqueKey> and still same result.
>
> On May 30, 2014, at 8:38 PM, Ahmet Arslan <[email protected]> wrote:
>
>> Hi,
>>
>> Sure, have a look at <uniqueKey> definition in example schema.xml
>>
>> http://wiki.apache.org/solr/UniqueKey
>>
>>
>>
>>
>> On Saturday, May 31, 2014 3:35 AM, PeriS <[email protected]> wrote:
>> No. Is there a way to have the primary key of my entity be the unique key?
>>
>>
>> On May 30, 2014, at 7:00 PM, Ahmet Arslan <[email protected]> wrote:
>>
>>> Hi,
>>>
>>> Do you have uniqueKey defined in schema.xml ?
>>>
>>>
>>>
>>> On Saturday, May 31, 2014 1:23 AM, PeriS <[email protected]>
>>> wrote:
>>> Hi,
>>>
>>> I have followed the documentation to set up my delta query, but when I call
>>> the delta-import, the index is happening again for the same record and
>>> ends up being indexed twice. Any clues please?
>>>
>>> Thanks
>>> -Peri
>>>
>>>
>>>
>>>
>>>
>>> *** DISCLAIMER *** This is a PRIVATE message. If you are not the intended
>>> recipient, please delete without copying and kindly advise us by e-mail of
>>> the mistake in delivery.
>>> NOTE: Regardless of content, this e-mail shall not operate to bind HTC
>>> Global Services to any order or other contract unless pursuant to explicit
>>> written agreement or government initiative expressly permitting the use of
>>> e-mail for such purpose.
>>>
>>>
>>
>>> Thank you,
>>> Peri Subrahmanya
>>> HTC Global Services
>>> (KOLE)
>>> Cell: (+1) 618.407.3521
>>> Skype/Gtalk: peri.subrahmanya
>>>
>>> *** DISCLAIMER *** This is a PRIVATE message. If you are not the intended
>>> recipient, please delete without copying and kindly advise us by e-mail of
>>> the mistake in delivery.
>>> NOTE: Regardless of content, this e-mail shall not operate to bind HTC
>>> Global Services to any order or other contract unless pursuant to explicit
>>> written agreement or government initiative expressly permitting the use of
>>> e-mail for such purpose.
>
>
>
>>
>>
>>
>>
>>
>>
>> *** DISCLAIMER *** This is a PRIVATE message. If you are not the intended
>> recipient, please delete without copying and kindly advise us by e-mail of
>> the mistake in delivery.
>> NOTE: Regardless of content, this e-mail shall not operate to bind HTC
>> Global Services to any order or other contract unless pursuant to explicit
>> written agreement or government initiative expressly permitting the use of
>> e-mail for such purpose.
>>
>>
>
>> Thank you,
>> Peri Subrahmanya
>> HTC Global Services
>> (KOLE)
>> Cell: (+1) 618.407.3521
>> Skype/Gtalk: peri.subrahmanya
>>
>> *** DISCLAIMER *** This is a PRIVATE message. If you are not the intended
>> recipient, please delete without copying and kindly advise us by e-mail of
>> the mistake in delivery.
>> NOTE: Regardless of content, this e-mail shall not operate to bind HTC
>> Global Services to any order or other contract unless pursuant to explicit
>> written agreement or government initiative expressly permitting the use of
>> e-mail for such purpose.
>
>
>
> *** DISCLAIMER *** This is a PRIVATE message. If you are not the intended
> recipient, please delete without copying and kindly advise us by e-mail of
> the mistake in delivery.
> NOTE: Regardless of content, this e-mail shall not operate to bind HTC Global
> Services to any order or other contract unless pursuant to explicit written
> agreement or government initiative expressly permitting the use of e-mail for
> such purpose.
>
>
*** DISCLAIMER *** This is a PRIVATE message. If you are not the intended
recipient, please delete without copying and kindly advise us by e-mail of the
mistake in delivery.
NOTE: Regardless of content, this e-mail shall not operate to bind HTC Global
Services to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail for
such purpose.