RE: Remove data from index

2009-08-21 Thread Fuad Efendi
x, but put current timestamp on each document; then delete by query all exprired documents -Fuad -Original Message- From: clico [mailto:cl...@mairie-marseille.fr] Sent: August-21-09 5:58 AM To: solr-user@lucene.apache.org Subject: Re: Remove data from index hossman wrote: > > :

Re: Remove data from index

2009-08-21 Thread clico
I don't understand this point. -- View this message in context: http://www.nabble.com/Remove-data-from-index-tp25063736p25080669.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Remove data from index

2009-08-21 Thread Noble Paul നോബിള്‍ नोब्ळ्
you can write a onImportEnd event handler also On Fri, Aug 21, 2009 at 3:28 PM, clico wrote: > > > hossman wrote: >> >> : > The request I would like to write is >> : > >> : > "Delete from my solr Index the id that are no longer present in my >> : > table_document" >> : > >> : > With Lucene I had a

Re: Remove data from index

2009-08-21 Thread clico
hossman wrote: > > : > The request I would like to write is > : > > : > "Delete from my solr Index the id that are no longer present in my > : > table_document" > : > > : > With Lucene I had a way to do that : > : > open IndexReader, > : > for each lucene document : check in table_document and r

Re: Remove data from index

2009-08-20 Thread Chris Hostetter
: > The request I would like to write is : > : > "Delete from my solr Index the id that are no longer present in my : > table_document" : > : > With Lucene I had a way to do that : : > open IndexReader, : > for each lucene document : check in table_document and remove in lucene : > index if docume

Re: Remove data from index

2009-08-20 Thread Noble Paul നോബിള്‍ नोब्ळ्
On Thu, Aug 20, 2009 at 8:39 PM, clico wrote: > > I hope it could be a solution. > > But I think I understood that u can use deletePkQuery like this > > "select document_id from table_document where statusDeleted= 'Y'" > > In my case I have no status like "statusDeleted". I don't think there is a

Re: Remove data from index

2009-08-20 Thread Marc Sturlese
As far as I know you can not do that with DIH. What size is your index? Probably the best you can do is index from scratch again with full-import. clico wrote: > > I hope it could be a solution. > > But I think I understood that u can use deletePkQuery like this > > "select document_id from ta

Re: Remove data from index

2009-08-20 Thread Constantijn Visinescu
You could write a solr query that queries *:* and only returns the id field and then throw out all the IDs from "select id from databaseTable" and then run a delete query for all the IDs that are left after wards. However you'd have to write a seperate program/script to do this i think as the DIH

Re: Remove data from index

2009-08-20 Thread clico
I hope it could be a solution. But I think I understood that u can use deletePkQuery like this "select document_id from table_document where statusDeleted= 'Y'" In my case I have no status like "statusDeleted". The request I would like to write is "Delete from my solr Index the id that are no

Re: Remove data from index

2009-08-20 Thread Noble Paul നോബിള്‍ नोब्ळ्
did you see the deletedPkQuery? On Thu, Aug 20, 2009 at 8:27 PM, clico wrote: > > Hello > > I'm trying a way to do that : > > I index a db query like >  "select id from table_documents" > > Some documents are updated or deleted from the data table. > > > Using DIH, I can indexe the updated documen