Delta import query not working

[willbrindle]

Hi,

I am very new to Solr but I have been playing around with it a bit and my
imports are all working fine. However, now I wish to perform a delta import
on my query and I'm just getting nothing.

I have the entity:

 <entity name="stock"
          query="SELECT CONCAT('stk_',id) AS id,part_no,name,description FROM
stock_items"
          deltaQuery="SELECT CONCAT('stk_',id) AS
id,part_no,name,description,updated_at FROM stock_items WHERE updated_at >
'${dih.delta.last_index_time}'"
          deltaImportQuery="SELECT CONCAT('stk_',id) AS id,id AS
id2,part_no,name,description FROM stock_items WHERE id2='${dih.delta.id}'"> 
   

I am not too sure if ${dih.delta.id} is supposed to be id or id2 but I have
tried both and neither work. My output is something along the lines of:

{
  "responseHeader": {
    "status": 0,
    "QTime": 0
  },
  "initArgs": [
    "defaults",
    [
      "config",
      "data-config.xml"
    ]
  ],
  "command": "status",
  "status": "idle",
  "importResponse": "",
  "statusMessages": {
    "Time Elapsed": "0:0:16.778",
    "Total Requests made to DataSource": "2",
    "Total Rows Fetched": "0",
    "Total Documents Skipped": "0",
    "Delta Dump started": "2015-02-05 16:17:54",
    "Identifying Delta": "2015-02-05 16:17:54",
    "Deltas Obtained": "2015-02-05 16:17:54",
    "Building documents": "2015-02-05 16:17:54",
    "Total Changed Documents": "0",
    "Delta Import Failed": "2015-02-05 16:17:54"
  },
  "WARNING": "This response format is experimental.  It is likely to change
in the future."
}

My full import query is working fine.

Thanks.



--
View this message in context: 
http://lucene.472066.n3.nabble.com/Delta-import-query-not-working-tp4184280.html
Sent from the Solr - User mailing list archive at Nabble.com.