Seems like the issue got fixed after I updated my import query to the following;
<entity name="item" 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
AND '${dataimporter.request.clean}' != 'false'
OR p.last_modified > '${dataimporter.last_index_time}'">
</entity>
On May 31, 2014, at 9:24 AM, PeriS <[email protected]> wrote:
> 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.
>
>
> *** 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.
