Which version of Solr is it and in which way is it not working.
And should not the deltaQuery and deltaImportQuery both have "as ID" part?
Regards,
Alex.
On 6 July 2018 at 07:53, shruti suri <er.shrutis...@gmail.com> wrote:
> HI,
>
> Please help me with delta import form one oracle table into solr. I don't
> have any primary key in the table. We need to use composite key using
> (LOCAL_MASTER_ID,LOCAL_ID).
>
> <entity name="item" pk="ID" transformer="TemplateTransformer"
> query="select * from data.vw_data_ref"
> deltaQuery="select concat(LOCAL_ID,LOCAL_MASTER_ID) as ID from
> data.vw_data_ref where UPDATED_DATE >
> to_date('${dataimporter.last_index_time}', 'YYYY-MM-DD HH24:MI:SS')"
> deltaImportQuery="select concat(LOCAL_ID,LOCAL_MASTER_ID) from
> data.vw_data_ref where ID='${item.ID}'">
>
> <field column="ID" template="${item.LOCAL_ID}${item.LOCAL_MASTER_ID}" />
> </entity>
>
>
>
> -----
> Regards
> Shruti
> --
> Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
