Re: Delete By Query issue followed by Delete By Id Issues

Hi Emir, We are deleting a larger subset of docs with a particular value which we know based on the id and only updating a few of the deleted. Our document is of the form __, we need to delete all that has the same , that are no longer in DB and then update only a few that has been updated in DB.

Re: Delete By Query issue followed by Delete By Id Issues

Hi Sujatha, Did I get it right that you are deleting the same documents that will be updated afterward? If that’s the case, then you can simply skip deleting, and just send updated version of document. Solr (Lucene) does not have delete - it’ll just flag document as deleted. Updating document (a

Re: Delete By Query issue followed by Delete By Id Issues

Thanks,Shawn. Our use case is something like this in a batch load of several 1000's of documents,we do a delete first followed by update.Example delete all 1000 docs and send an update request for 1000. What we see is that there are many missing docs due to DBQ re-ordering of the order of delet

Re: Delete By Query issue followed by Delete By Id Issues

On 6/21/2018 9:59 AM, sujatha sankaran wrote: > Currently from our business perspective we find that we are left with no > options for deleting docs in a batch load as : > > DBQ+ batch does not work well together > DBI+ custom routing (batch load / normal)would not work as well. I would expect

Re: Delete By Query issue followed by Delete By Id Issues

Thanks,Shawn. Currently from our business perspective we find that we are left with no options for deleting docs in a batch load as : DBQ+ batch does not work well together DBI+ custom routing (batch load / normal)would not work as well. We are not sure how we can proceed unless we don't hav

Re: Delete By Query issue followed by Delete By Id Issues

On 6/20/2018 3:46 PM, sujatha sankaran wrote: > Thanks,Shawn. Very useful information. > > Please find below the log details:- Is your collection using the implicit router?  You didn't say.  If it is, then I think you may not be able to use deleteById.  This is indeed a bug, one that has been re

Re: Delete By Query issue followed by Delete By Id Issues

Thanks,Shawn. Very useful information. Please find below the log details:- 2018-06-20 17:19:06.661 ERROR (updateExecutor-2-thread-8226-processing-crm_v2_01_shard3_replica1 x:crm_v2_01_shard3_replica2 r:core_node4 n:masked:8983_solr s:shard3 c:crm_v2_01) [c:crm_v2_01 s:shard3 r:core_node4 x:cr

Re: Delete By Query issue followed by Delete By Id Issues

On 6/15/2018 3:14 PM, sujatha sankaran wrote: We were initially having an issue with DBQ and heavy batch updates which used to result in many missing updates. After reading many mails in mailing list which mentions that DBQ and batch update do not work well together, we switched to DBI. But we

Delete By Query issue followed by Delete By Id Issues

We were initially having an issue with DBQ and heavy batch updates which used to result in many missing updates. After reading many mails in mailing list which mentions that DBQ and batch update do not work well together, we switched to DBI. But we are seeing issue as mentioned in this jira is

Re: Delete by query issue

: Here's the problem: the standard Solr parser is a little weird about : negative queries. The way to make this work is to say : *:* AND -field:[* TO *] the default parser actually works ok ... it's a bug specific to deletion... https://issues.apache.org/jira/browse/SOLR-381 -Hoss

Re: Delete by query issue

that I didn't know? > >> > >> -date_added_solr:[* TO *]' > >> > >> - Original Message - > >> From: "Max Lynch" > >> To: > >> Sent: Thursday, August 26, 2010 6:12 AM > >> Subject: Delete by query issue &g

Re: Delete by query issue

;date_added_solr'? Is >> this some kind of new query format that I didn't know? >> >> -date_added_solr:[* TO *]' >> >> - Original Message - >> From: "Max Lynch" >> To: >> Sent: Thursday, August 26, 2010 6:12 AM >> Subject: Delet

Re: Delete by query issue

now? > > -date_added_solr:[* TO *]' > > - Original Message - > From: "Max Lynch" > To: > Sent: Thursday, August 26, 2010 6:12 AM > Subject: Delete by query issue > > > > Hi, > > I am trying to delete all documents that have null values for

Re: Delete by query issue

Excuse me, what's the hyphen before the field name 'date_added_solr'? Is this some kind of new query format that I didn't know? -date_added_solr:[* TO *]' - Original Message - From: "Max Lynch" To: Sent: Thursday, August 26, 2010 6:12 AM Subject: D

Delete by query issue

Hi, I am trying to delete all documents that have null values for a certain field. To that effect I can see all of the documents I want to delete by doing this query: -date_added_solr:[* TO *] This returns about 32,000 documents. However, when I try to put that into a curl call, no documents get