I have as well faced the problem when we have composite primary key in the
table, so below is how have went with workaround.
deltaQuery retrieve concat value with time criteria (that should retrieves
only modified rows) and use it in deltaImportQuery with where clause.
<entity name="item" pk="data_id" transformer="TemplateTransformer"
query="select concat(LOCAL_ID,LOCAL_MASTER_ID) as data_id, * from
data.vw_data_ref"
deltaImportQuery="select concat(LOCAL_ID,LOCAL_MASTER_ID)
as data_id, * from data.vw_data_ref where
concat(LOCAL_ID,LOCAL_MASTER_ID)='${dataimporter.delta.data_id}'"
deltaQuery="select concat(LOCAL_ID,LOCAL_MASTER_ID) as data_id
from data.vw_data_ref
where UPDATE_DATE > to_date('${dataimporter.last_index_time}', 'YYYY-MM-DD
HH24:MI:SS')"
>
</entity>
On Sun, Jul 8, 2018 at 11:56 AM, shruti suri <er.shrutis...@gmail.com>
wrote:
> Dataconfig I am using now
>
> <entity name="item" pk="data_id" transformer="TemplateTransformer"
>
> query="select * from data.vw_data_ref"
> deltaImportQuery="select * from data.vw_data_ref where
> concat(LOCAL_ID,LOCAL_MASTER_ID)='${dataimporter.delta.data_id}'"
> deltaQuery="select concat(LOCAL_ID,LOCAL_MASTER_ID) as unique_id
> from data.vw_data_ref
> where UPDATE_DATE > to_date('${dataimporter.last_index_time}',
> 'YYYY-MM-DD
> HH24:MI:SS')"
> >
>
> <field column="data_id"
> template="${item.LOCAL_MASTER_ID}${item.LOCAL_ID}" />
> </entity>
>
> *managed-schema*
>
> <uniqueKey>data_id</uniqueKey>
>
>
>
>
> -----
> Regards
> Shruti
> --
> Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
>
