You have "deletedPKQuery", but the correct spelling is "deletedPkQuery"
(lowercase "k"). Try that and see if it fixes your problem.
Also, you can probably simplify this if you do this as
"command=full-import&clean=false", then use something like this for your query:
select product_id as '$deleteDocById' from modified_product
where gmt_create > to_date('${dataimporter.last_index_time}','yyyy-mm-dd
hh24:mi:ss')
and modification = 'deleted'
See http://wiki.apache.org/solr/DataImportHandler#Special_Commands for more
info on this technique.
Finally, you will want to be aware of
https://issues.apache.org/jira/browse/SOLR-2492 , a bug which was fixed in Solr
3.4. DIH doesn't automatically do a commit in some cases if your import only
does deletes. You need to issue a commit manually after it completes.
James Dyer
E-Commerce Systems
Ingram Content Group
(615) 213-4311
-----Original Message-----
From: jun Wang [mailto:wangjun...@gmail.com]
Sent: Wednesday, September 05, 2012 8:33 PM
To: solr-user@lucene.apache.org
Subject: deletedPkQuery not work in solr 3.3
I have a data-config.xml with 2 entity, like
<entity name="full" PK="ID" ...>
...
</entity>
and
<entity name="delta_build" PK="ID" ...>
...
</entity>
entity delta_build is for delta import, query is
?command=full-import&entity=delta_build&clean=false
and I want to using deletedPkQuery to delete index. So I have add those to
entity "delta_build"
deltaQuery="select -1 as ID from dual"
deltaImportQuery="select * from product where a.id='${dataimporter.delta.ID}' "
deletedPKQuery="select product_id as ID from modified_product where
gmt_create > to_date('${dataimporter.last_index_time}','yyyy-mm-dd
hh24:mi:ss') and modification = 'deleted'"
deltaQuery and deltaImportQuery is simply to avoid delta import any
records, course delta import has been implement by full import. and I am
just want using delta for delete index.
But when I hit query
?command=delta-import
deltaQuery and deltaImportQuery can be found in log, and without
deletedPKQuery. Is there any thing wrong in config file?
--
from Jun Wang
