Which version of Solr and what kind of SQL errors? There were some bugs in 4.x related to last_index_time, but it does not sound related.
Regards, Alex. Personal website: http://www.outerthoughts.com/ LinkedIn: http://www.linkedin.com/in/alexandrerafalovitch - Time is the quality of nature that keeps events from happening all at once. Lately, it doesn't seem to be working. (Anonymous - via GTD book) On Sun, Oct 6, 2013 at 8:51 AM, Bill Au <bill.w...@gmail.com> wrote: > Here is my DIH config: > > <dataConfig> > <dataSource name="ds1" type="JdbcDataSource" driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost1/dbname1" user="db_username1" > password="db_password1"/> > <dataSource name="ds2" type="JdbcDataSource" driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost2/dbname2" user="db_username2" > password="db_password2"/> > <document name="products"> > <entity name="item" dataSource="ds1" query="select * from item"> > <field column="ID" name="id" /> > <field column="NAME" name="name" /> > > <entity name="feature" dataSource="ds2" query="select > description from feature where item_id='${item.ID}'"> > <field name="features" column="description" /> > </entity> > </entity> > </document> > </dataConfig> > > I am having trouble with delta import. I think it is because the main > entity and the sub-entity use different data source. I have tried using > both a delta query: > > deltaQuery="select id from item where id in (select item_id as id from > feature where last_modified > '${dih.last_index_time}') or last_modified > > '${dih.last_index_time}'" > > and a parentDeltaQuery: > > <entity name="feature" pk="ITEM_ID" query="select DESCRIPTION as features > from FEATURE where ITEM_ID='${item.ID}'" deltaQuery="select ITEM_ID from > FEATURE where last_modified > '${dih.last_index_time}'" > parentDeltaQuery="select ID from item where ID=${feature.ITEM_ID}"/> > > I ended up with an SQL error for both. Is there any way to make delta > import work in my case? > > Bill >
