lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ephraim Ofir (JIRA)" <j...@apache.org>
Subject [jira] Created: (SOLR-2104) DIH special command $deleteDocById dosn't skip the document and doesn't increment the deleted statistics
Date Mon, 06 Sep 2010 09:17:33 GMT
DIH special command $deleteDocById dosn't skip the document and doesn't increment the deleted
statistics
--------------------------------------------------------------------------------------------------------

                 Key: SOLR-2104
                 URL: https://issues.apache.org/jira/browse/SOLR-2104
             Project: Solr
          Issue Type: Bug
          Components: contrib - DataImportHandler
    Affects Versions: 1.4.1, 1.4
            Reporter: Ephraim Ofir
            Priority: Minor


1. Not sure it's a bug, but looks like a bug to me - if the query returns any values other
than $deleteDocById for the row you want deleted, it deletes the row but also re-adds it with
the rest of the data, so in effect the row isn't deleted.  In order to work around this issue,
you have to either make sure no data other than $deleteDocById=<id> exists in rows to
be deleted or add $skipDoc='true'
(which I think is a little counter-intuitive, but was the better choice in my case).  My query
looks something like:
SELECT u.id,
       u.name,
       ...
       IF(u.delete_flag > 0, u.id, NULL) AS $deleteDocById,
       IF(u.delete_flag > 0, 'true', NULL) AS $skipDoc FROM users_tb u

2. $deleteDocById doesn't update the statistics of deleted documents.
This has 2 downsides, the obvious one is that you don't know if/how many documents were deleted,
the not-so-obvious one is that if your import contains only deleted items, it won't be committed
automatically by DIH and you'll have to commit it manually.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message