数据库的表有timestamp字段？ 每次 进行更新和修改的时候，这个字段的值都会自动变化，做增量的时候就能根据这个处理了
On Tue, Jun 19, 2012 at 6:24 PM, alex.wang <wang_...@sohu.com> wrote:
> hi all:
> when i import the data from db to solr. and solr changed the value with
> timezone.
> eg, the original value is 16/02/2012 12:05:16 , changed to 1/02/2012
> 04:05:06
> . and i add the 8 hours in my sql . it's be correct.
> but when i use delta-import mode to add index. it's not working.
> the sql in config as follow:
> <entity name="sharing" pk="id"
> query="select t.id, t.content , t.money , t.tradeTgtId , t0.name
> , DATE_ADD(t.time,INTERVAL 8 HOUR) as time from sharing t LEFT JOIN tradetgt
> t0 on t.tradeTgtId = t0.id "
> deltaImportQuery="select t.id, t.content , t.money ,
> t.tradeTgtId , t0.name , t.time from sharing t LEFT JOIN tradetgt t0 on
> t.tradeTgtId = t0.id where t.id = '${dataimporter.delta.id}'" >
> deltaQuery="select id from sharing where DATE_ADD(time,INTERVAL
> 8 HOUR) > '${dataimporter.last_index_time}'" >
> <field column="id" name="id"/>
> <field column="content" name="sharing_content"/>
> <field column="time" name="sharing_time"/>
> <field column="money"
> name="sharing_money"/>
> <field column="name"
> name="trade_name"/>
> </entity>
>
> and no log error.
> i don't know why?
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/question-about-DIH-tp3990261.html
> Sent from the Solr - User mailing list archive at Nabble.com.
