我使用solr 4.10.2,因为完全导入工作正常,但如果在mysql DB中有任何插入/更新,某种方式delta导入不起作用 . Delta导入不会出现任何错误,但从不提取任何更改 .
我按照本网站提到的步骤进行操作
http://wiki.apache.org/solr/DataImportHandler
data-config.xml
<dataConfig>
<dataSource autoCommit="true" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/delta_import_handler" user="root" password="Gemini*123" />
<document name="Products">
<entity name="item" pk="ID" query="SELECT * FROM item " deltaImportQuery="select * from item where ID='${dih.delta.ID}'"
deltaQuery="select id from item where last_modified > '${dataimporter.last_index_time}'">
<field name="ID" column="id"/>
<field name="name" column="name"/>
<field name="manu" column="manu"/>
<field name="weight" column="weight"/>
<field name="price" column="price"/>
<field name="popularity" column="popularity"/>
<field name="includes" column="includes"/>
<field name="last_modified" column="last_modified" />
solrconfig.xml
<requestHandler name="/dataimport"class="org.apache.solr.handler.dataimport.DataImportHandler">
<lst name="defaults">
<str name="config">data-config.xml</str>
</lst>
</requestHandler>
schema.xml
<field name="id" type="text_general" indexed="true" stored="true"/>
<field name="name1" type="string" indexed="true" stored="true"/>
<field name="manu" type="string" indexed="true" stored="true"/>
<field name="weight" type="string" indexed="true" stored="true"/>
<field name="price" type="string" indexed="true" stored="true"/>
<field name="popularity" type="string" indexed="true" stored="true"/>
<field name="includes" type="string" indexed="true" stored="true"/>
<field name="last_modified" type="timestamp" indexed="true" stored="true"/>
1 回答
而不是'$ '使用'$ '或STR_TO_DATE('$ ','%Y-%m-%d%H:%i:%s')
我使用如下,因为我的MYSQL字段
updated_at
是varchar .STR_TO_DATE(updated_at,'%Y-%m-%dT%H:%i:%s.000Z')> STR_TO_DATE('$ ','%Y-%m-%d%H:% I:%S')