Hi Marc,
Did you do a full-import first? If not, no value for last import time is
written and the delta query may fail. We should fix this to use a sane
default so that people do not need to full import first.
You need to put both because we support both full and delta, both of which
need different kinds of queries and we cannot decide what you are going to
use.
On Fri, Nov 14, 2008 at 4:35 PM, Marc Sturlese <[EMAIL PROTECTED]>wrote:
>
> Hey there, I am using dataimport with full-import successfully but there's
> no
> way do make it work with delta-import. Aparently solr doesn't show any
> error
> but it does not do what it is supose to.
> I thing the problme is with dataimport.properties because it is never
> updated. I have it placed in the same folder as solrconfig.xml and
> schema.xml and the writing permissions are set propertly. What makes me
> doubt is that couldn't find anywhere to tell solr the path of this file.
> Don't know if solr is suposed to find it automatically.
>
> My data-config.xml looks like this:
> <dataConfig>
> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://path_db" user="user" password="pwd"/>
> <document name="product">
> <entity name="entity_n" pk="id" query="select id,field1 from table
> order by id limit 1000" deltaQuery="select id from table where
> dt_last_modified > '${dataimporter.last_index_time}' order by id" >
> <field name="id" column="id" />
> <field name="field1" column="field1" />
> </entity>
> </document>
> </dataConfig>
> *I have in the rows of the table a timestamp field called dt_last_modified
>
> Other thing that can't exactly understant is why i have to put the query
> and
> delta-query... why just with deltaquery (with more fields in the select) is
> not enough?
>
> After the ejecution everything seems to go ok (even with the debug and
> verbose mode) but no docs have changed and dataimport.properties is not
> updated...
>
> Any suggestion? Have done many tests but no way...
>
> --
> View this message in context:
> http://www.nabble.com/troubles-with-delta-import-tp20498449p20498449.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
--
Regards,
Shalin Shekhar Mangar.
