Could you try something like this.?
deltaQuery="select CONCAT(cast(col1 as varchar(10)) , name) as ID FROM
MyTable WHERE UPDATED_DATE > '${dih.last_index_time}'"
deltaImportQuery="select CONCAT(cast(col1 as varchar(10)) , name) as ID, *
from MyTable WHERE CONCAT(cast(col1 as varchar(10)) , name) = '${
dih.delta.ID}'"
pk="ID"
query="select CONCAT(cast(col1 as varchar(10)) , name) as ID, * from MyTable
On Sat, Jul 7, 2018 at 1:41 PM, 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
>
