Why not use delete by id rather than query? It'll be more efficient.... Probably not a big deal though.
On Tue, Oct 25, 2016 at 1:47 AM, Aniket Khare <aniketish...@gmail.com> wrote: > Hi Sowmya, > > I my case I have implemeneted the data indexing suggested by James and for > deleting the reords I have created my own data indexing job which will call > the delete API periodically by passing the list of unique Id. > https://cwiki.apache.org/confluence/display/solr/Uploading+Data+with+Index+Handlers > > http://localhost:8983/solr/update?stream.body= > <delete><query>id:1234</query></delete>&commit=true > > Thanks, > Aniket S. Khare > > On Tue, Oct 25, 2016 at 1:32 AM, Mohan, Sowmya <sowmya.mo...@icf.com> wrote: > >> Thanks James. That's what I was using before. But I also wanted to perform >> deletes using deletedPkQuery and hence switched to delta imports. The >> problem with using deletedPkQuery with the full import is that >> dataimporter.last_index_time is no longer accurate. >> >> Below is an example of my deletedPkQuery. If run the full-import for a >> differential index, that would update the last index time. Running the >> delta import to remove the deleted records then wouldn't do anything since >> nothing changed since the last index time. >> >> >> deletedPkQuery="SELECT id >> FROM content >> WHERE active = 1 AND lastUpdate > >> '${dataimporter.last_index_time}'" >> >> >> >> >> >> >> -----Original Message----- >> From: Dyer, James [mailto:james.d...@ingramcontent.com] >> Sent: Friday, October 21, 2016 4:23 PM >> To: solr-user@lucene.apache.org >> Subject: RE: CachedSqlEntityProcessor with delta-import >> >> Sowmya, >> >> My memory is that the cache feature does not work with Delta Imports. In >> fact, I believe that nearly all DIH features except straight JDBC imports >> do not work with Delta Imports. My advice is to not use the Delta Import >> feature at all as the same result can (often more-efficiently) be >> accomplished following the approach outlined here: >> https://wiki.apache.org/solr/DataImportHandlerDeltaQueryViaFullImport >> >> James Dyer >> Ingram Content Group >> >> -----Original Message----- >> From: Mohan, Sowmya [mailto:sowmya.mo...@icf.com] >> Sent: Tuesday, October 18, 2016 10:07 AM >> To: solr-user@lucene.apache.org >> Subject: CachedSqlEntityProcessor with delta-import >> >> Good morning, >> >> Can CachedSqlEntityProcessor be used with delta-import? In my setup when >> running a delta-import with CachedSqlEntityProcessor, the child entity >> values are not correctly updated for the parent record. I am on Solr 4.3. >> Has anyone experienced this and if so how to resolve it? >> >> Thanks, >> Sowmya. >> >> > > > -- > Regards, > > Aniket S. Khare
