Re: Solr: delta-import, help needed

2009-03-18 Thread Giovanni De Stefano
Hello Paul, thank you for your feedback. I will ask to add an expiration date to the DB and run a process that updates the index accordingly. Cheers, Giovanni On 3/18/09, Noble Paul നോബിള്‍ नोब्ळ् wrote: > > it is not possible to query details from Solr and find out deleted > items using DIH >

Re: Solr: delta-import, help needed

2009-03-18 Thread Noble Paul നോബിള്‍ नोब्ळ्
it is not possible to query details from Solr and find out deleted items using DIH you must maintain a deleted rows ids in the db or just flag them as deleted. --Noble On Wed, Mar 18, 2009 at 2:46 PM, Giovanni De Stefano wrote: > Hello Paul, > > thank you for your reply. > > The UPDATE in fac

Re: Solr: delta-import, help needed

2009-03-18 Thread Giovanni De Stefano
Hello Paul, thank you for your reply. The UPDATE in fact works fine: I only had to update the CREATION_TIME on the DB :-) Regarding the deletedPkQuery, I understand it has to return the primary keys that should be removed from the index (because they have been removed from the DB) but I don't ha

Re: Solr: delta-import, help needed

2009-03-17 Thread Noble Paul നോബിള്‍ नोब्ळ्
are you sure your schema.xml has a field to UPDATE docs. to remove deleted docs you must have deletedPkQuery attribute in the root entity On Tue, Mar 17, 2009 at 8:48 PM, Giovanni De Stefano wrote: > Hello all, > > I have a table TEST in an Oracle DB with the following columns: URI > (varchar),

Solr: delta-import, help needed

2009-03-17 Thread Giovanni De Stefano
Hello all, I have a table TEST in an Oracle DB with the following columns: URI (varchar), CONTENT (varchar), CREATION_TIME (date). The primary key both in the DB and Solr is URI. Here is my data-config.xml: The problem is that anytime I perform a delta-import