Geek asks and answers

Solr delta import "fetch" but not "process",

when do I run / solr / dataimport? command = full-import processes all documents. However, when I run delta import (/ solr / dataimport? Command = delta-import), it correctly identifies updated data (returns " <str name="Total Rows Fetched">1</str>"), but does not process it (returns " <str name="Total Changed Documents">0</str>")

my data-config.xml looks something like this:

<entity name="category" pk="catID" 
query="SELECT CONCAT('c_',catID) ID, catID, catName FROM category" 
deltaImportQuery="SELECT CONCAT('c_',catID) ID, catID, catName FROM category WHERE catID = '{$dataimporter.delta.catID}'" 
deltaQuery="SELECT catID FROM category WHERE catDate &gt; '${dataimporter.last_index_time}'"/>

(note - there is a separate reason for my concat)

Why is the whole import process during import delta but not processed?

+5
source share
4 answers

'{$dataimporter.delta.catID}', catID name . , , - ... , .

+5

, , deltaImportQuery

"ID"

deltaImportQuery = " id, state, name, place, city from temp, ID = '$ {dih.delta.ID}

+1

, .

- , ( catDate).

, , 2012-09-09 12:15:38.

, - 2012-09-10 12:15:38. catDate > '2012-09-09 12:15:38'.

, - - .

0
source

In your case, the delta request works fine, but your request with delta import fails.

This is because you gave

deltaImportQuery = "SELECT CONCAT ('c_', catID) ID, catID, catName FROM category WHERE catID = '{$ dataimporter.delta.catID}' "

But it must be specified as

deltaImportQuery = "SELECT CONCAT ('c_', catID) ID, catID, catName FROM category WHERE catID = '$ {dataimporter.delta.catID}' "

0
source

More articles:


All Articles