lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dyer, James" <James.D...@ingramcontent.com>
Subject RE: deletedPkQuery not work in solr 3.3
Date Thu, 06 Sep 2012 14:03:00 GMT
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 &gt; 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:wangjundot@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 &gt; 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


Mime
View raw message