lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan Matheis <matheis.ste...@gmail.com>
Subject Re: explicite deltaimports by given ids
Date Tue, 24 Sep 2013 13:54:29 GMT
Peter

You can access request params that way: ${dataimporter.request.command} (from https://wiki.apache.org/solr/DataImportHandler#Accessing_request_parameters)
- although i'm not sure what happens if you provide the same param multiple times.

Perhaps i'd go with &oid=5,6 as url param and use ".. WHERE oid IN( ${dataimporter.request.oid}
) .." in the query?

-Stefan  


On Friday, September 13, 2013 at 3:37 PM, Peter Schütt wrote:

> Hallo,
> I want to trigger a deltaimportquery by given IDs.
>  
> Example:
>  
> query="select oid, att1, att2 from my_table"
>  
> deltaImportQuery="select oid, att1, att2 from my_table  
> WHERE oid=${dih.delta.OID}"
>  
> deltaQuery="select OID from my_table WHERE
> TIME_STAMP > TO_DATE
> (${dih.last_index_time:VARCHAR}, 'YYYY-MM-DD HH24:MI:SS')"
>  
> deletedPkQuery="select OID from my_table
> where TIME_STAMP > TO_DATE(${dih.last_index_time:VARCHAR}, 'YYYY-MM-
> DD HH24:MI:SS')"
>  
>  
> Pseudo URL:  
>  
> http://solr-server/solr/mycore/dataimport/?command=deltaImportQuery&&oid=5
> &&oid=6
>  
> to trigger the update or insert of the datasets with OID in (5, 6).
>  
> What is the correct way?
>  
> Thanks for any hint.
>  
> Ciao
> Peter Schütt
>  
>  



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message