Re: Remove the deleted docs from the Solr Index

On Wed, Dec 30, 2009 at 12:10 AM, Mohamed Parvez wrote: > Ditto. There should have been an DIH command to re-sync the Index with the > DB. > But there is such a command; it is called full-import. -- Regards, Shalin Shekhar Mangar.

Re: Remove the deleted docs from the Solr Index

Lance: At times we dont have the freedom make these Database changes. Currently I am in this situation. Hence the requirement on the DIH. ~Ravi. On Sat, Jan 2, 2010 at 3:44 PM, Lance Norskog wrote: > The other option is to have a 'deleted' column in your table, and have > the applica

Re: Remove the deleted docs from the Solr Index

The other option is to have a 'deleted' column in your table, and have the application 'delete' operation set that field. In the DIH you query this column with 'deletedPkQuery'. Or, you can use triggers to maintain a new table with the IDs of deleted rows. This will allow you to have a batch job t

Re: Remove the deleted docs from the Solr Index

Ditto. There should have been an DIH command to re-sync the Index with the DB. Right now it looks like one way street form DB to Index. On Tue, Dec 29, 2009 at 3:07 AM, Ravi Gidwani wrote: > Hi Shalin: > > > I get your point about not knowing what has been deleted from > the database.

Re: Remove the deleted docs from the Solr Index

Hi Shalin: > I get your point about not knowing what has been deleted from the > database. So this is what even I am looking for: > > 0) A document (id=100) is currently part of solr index.( > 1) Lets say the application deleted a record with id=100 from database. > > 2) Now I need to e

Re: Remove the deleted docs from the Solr Index

On Tue, Dec 29, 2009 at 3:03 AM, Mohamed Parvez wrote: > I have looked in the that thread earlier. But there is no option there for > a > solution from Solr side. > > I mean the two more options there are > 1] Use database triggers instead of DIH to manage updating the index :- > This out of ques

Re: Remove the deleted docs from the Solr Index

I have looked in the that thread earlier. But there is no option there for a solution from Solr side. I mean the two more options there are 1] Use database triggers instead of DIH to manage updating the index :- This out of question as we cant run 1000 odd triggers every hour to delete. 2] Some s

Re: Remove the deleted docs from the Solr Index

Here's a couple more options: http://stackoverflow.com/questions/1555610/solr-dih-how-to-handle-deleted-documents/ Cheers, Mauricio On Mon, Dec 28, 2009 at 5:51 PM, Mohamed Parvez wrote: > I am using Solr 1.