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.
