I'm quite new in SOLR, I have a question regarding the request for data importer.
In my data-config.xml
, i have something like this
<entity name="content" pk="id" query="SELECT * FROM tableX"
deltaQuery="SELECT max(id) AS id from ${dataimporter.request.dataView}"
deltaImportQuery="SELECT * FROM tableX WHERE ${dataimporter.delta.id} < id">
....
</entity>
However, everytime I execute delta-import (/dataimport?command=delta-import
), it always gives me exception like this:
Caused by: java.lang.RuntimeException:
org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query:
SELECT max(id) AS id FROM Processing Document # 1
I believe this error exists because the system didn't recognize ${dataimporter.request.dataView}
, but I don't know how to make that recognized?