RE: Is deltaQuery mandatory ?
No, it's not mandatory. You can't do delta imports without delta queries though; you'd need to do a full-import. Per your query, you'd only ever do objects with rownum=5000. -Original Message- From: A. Lotfi [mailto:majidna...@yahoo.com] Sent: Thursday, March 28, 2013 10:07 AM To: gene...@lucene.apache.org; solr-user@lucene.apache.org Subject: Is deltaQuery mandatory ? Is deltaQuery mandatory in data-config.xml ? I did it like this : entity name=residential query=select * from tsunami.consumer_data_01 where state='MA' and rownum = 5000 deltaQuery=select LEMSMATCHCODE, STREETNAME from residential where last_modified '${dataimporter.last_index_time}' Then my manager come and said we don't need it, this is only for incremental. I took off the line that start with deltaQuery, now in : http://localhost:8983/solr/#/db/dataimport//dataimport entity is empty, when I click the button Exwcute, nothing happened, thanks.
RE: Is deltaQuery mandatory ?
You do not need deltaQuery unless you're doing delta (incremental) updates. To configure a full import, try starting with this example: http://wiki.apache.org/solr/DataImportHandler#A_shorter_data-config James Dyer Ingram Content Group (615) 213-4311 -Original Message- From: A. Lotfi [mailto:majidna...@yahoo.com] Sent: Thursday, March 28, 2013 9:07 AM To: gene...@lucene.apache.org; solr-user@lucene.apache.org Subject: Is deltaQuery mandatory ? Is deltaQuery mandatory in data-config.xml ? I did it like this : entity name=residential query=select * from tsunami.consumer_data_01 where state='MA' and rownum = 5000 deltaQuery=select LEMSMATCHCODE, STREETNAME from residential where last_modified '${dataimporter.last_index_time}' Then my manager come and said we don't need it, this is only for incremental. I took off the line that start with deltaQuery, now in : http://localhost:8983/solr/#/db/dataimport//dataimport entity is empty, when I click the button Exwcute, nothing happened, thanks.