RE: Is deltaQuery mandatory ?

2013-03-28 Thread Swati Swoboda
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 ?

2013-03-28 Thread Dyer, James
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.