接着前面定时增量导入的介绍:http://blog.csdn.net/jiyiqinlovexx/article/details/24913853 这里介绍一下多表导入。
(一)导入两张表,不相关:
新建一张新表,同样要有UpdateTime字段:
在data-config.xml文件中增加这个表的entity配置:
- <dataConfig>
- <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/test" user="root" password="passok" />
- <document>
- <entity name="userInfo" pk="UserID"
- query="SELECT * FROM userinfo"
- deltaImportQuery="SELECT * FROM userinfo where UserID='${dih.delta.UserID}'"
- deltaQuery="SELECT UserID FROM userinfo where UpdateTime > '${dataimporter.last_index_time}'">
- <field column="UserID" name="id"/>
- <field column="UserName" name="userName"/>
- <field column="UserAge" name="userAge"/>
- <field column="UpdateTime" name="updateTime"/>
- </entity>
- <!-- 新加的entity -->
- <entity name="myArticle" pk="AID"
- query="SELECT * FROM article"
- deltaImportQuery="SELECT * FROM article where AID='${dih.delta.AID}'"
- deltaQuery="SELECT AID FROM article where UpdateTime > '${dataimporter.last_index_time}'">
- <field column="AID" name="id"/>
- <field column="ArTitle" name="arTitle"/>
- <field column="UpdateTime" name="updateTime"/>
- </entity>
- </document>
- </dataConfig>
在schema,xml文件中增加想要索引的列的配置:
- <!-- ===========jiyiqin add====================== -->
- <field name="userName" type="text_general" indexed="true" stored="true" />
- <field name="userAge" type="int" indexed="true" stored="true" />
- <field name="updateTime" type="date" indexed="true" stored="true" />
- <field name="arTitle" type="text_general" indexed="true" stored="true" />
就这样启动tomcat服务器,就会自动增量导入Article这个表的数据并为ArTitle这列建立索引了。