solr5中配置dataimport-handler

scs653298

1.Configuring solrconfig.xml
　　（文件所在路径D:\solr5\solr-5.0.0\server\solr\xuq\conf\solrconfig.xml）
　　Data Import Handler必须先在solrconfig.xml中进行注册。
<requestHandler name=&quot;/dataimport&quot; class=&quot;org.apache.solr.handler.dataimport.DataImportHandler&quot;>  <lst name=&quot;defaults&quot;>    <str name=&quot;config&quot;>DIHconfigfile.xml</str>  </lst></requestHandler>　　2.Configuring the DIH Configuration File（DIHconfigfile.xml）
　　（文件所在路径D:\solr5\solr-5.0.0\server\solr\xuq\conf\DIHconfigfile.xml）
　　the DIH Configuration File是基于目录下D:\solr5\solr-5.0.0\example\example-DIH\solr\db\conf中的db-data-config.xml文件的注释文件，它从以下定义的4张数据库表中抽取数据。
<dataConfig><!--The first element is the dataSource, in this case an HSQLDB database.     Thepath to the JDBC driver and the JDBC URL and login credentials are all specified here.     Otherpermissible attributes include whether or not to autocommit to Solr,the batchsize     usedin the JDBC connection, a 'readOnly' flag -->  <dataSource driver=&quot;org.hsqldb.jdbcDriver&quot; url=&quot;jdbc:hsqldb:./example-DIH/hsqldb/ex&quot; user=&quot;sa&quot; /> <!--a 'document' element follows, containing multiple 'entity' elements.     Notethat 'entity' elements can be nested, and this allows the entity     relationshipsin the sample database to be mirrored here, so that we can     generatea denormalized Solr record which may include multiple features     forone item, for instance -->  <document> <!--The possible attributes for the entity element are described below.     Entityelements may contain one or more 'field' elements, which map     thedata source field names to Solr fields, and optionally specify     per-fieldtransformations --><!--this entity is the 'root' entity. -->    <entity name=&quot;item&quot; query=&quot;select* from item&quot;            deltaQuery=&quot;selectid from item where last_modified > '${dataimporter.last_index_time}'&quot;>      <field column=&quot;NAME&quot; name=&quot;name&quot; /> <!--This entity is nested and reflects the one-to-many relationship between an item and its multiple features.     Notethe use of variables; ${item.ID} is the value of the column 'ID' for the current item     ('item'referring to the entity name)  -->      <entity name=&quot;feature&quot;               query=&quot;selectDESCRIPTION from FEATURE where ITEM_ID='${item.ID}'&quot;              deltaQuery=&quot;selectITEM_ID from FEATURE where last_modified > '${dataimporter.last_index_time}'&quot;              parentDeltaQuery=&quot;selectID from item where ID=${feature.ITEM_ID}&quot;>        <field name=&quot;features&quot; column=&quot;DESCRIPTION&quot; />      </entity>      <entity name=&quot;item_category&quot;              query=&quot;selectCATEGORY_ID from item_category where ITEM_ID='${item.ID}'&quot;              deltaQuery=&quot;selectITEM_ID, CATEGORY_ID from item_category where last_modified > '${dataimporter.last_index_time}'&quot;              parentDeltaQuery=&quot;selectID from item where ID=${item_category.ITEM_ID}&quot;>        <entity name=&quot;category&quot;                query=&quot;selectDESCRIPTION from category where ID = '${item_category.CATEGORY_ID}'&quot;                deltaQuery=&quot;selectID from category where last_modified > '${dataimporter.last_index_time}'&quot;                parentDeltaQuery=&quot;selectITEM_ID, CATEGORY_ID from item_category where CATEGORY_ID=${category.ID}&quot;>          <field column=&quot;description&quot; name=&quot;cat&quot; />        </entity>      </entity>    </entity>  </document></dataConfig>　　数据源根据实际情况配置。将DIHconfigfile.xml文件放到solrconfig.xml同目录下，重启solr服务器即可。
　　资料参考：https://cwiki.apache.org/confluence/display/solr/Uploading&#43;Structured&#43;Data&#43;Store&#43;Data&#43;with&#43;the&#43;Data&#43;Import&#43;Handler
　　

         版权声明：本文为博主原创文章，未经博主允许不得转载。