Вопрос по mysql – Как использовать обработчик импорта данных Solr для индексации таблицы MySQL?

2

Error: User Rate Limit Exceeded

http://192.168.136.129:8983/solr/dataimport?command=full-import

Error: User Rate Limit Exceeded

HTTP ERROR 404

Problem accessing /solr/dataimport. Reason:

    NOT_FOUND

Powered by Jetty://

Error: User Rate Limit Exceeded

http://wiki.apache.org/solr/DIHQuickStart

В соответствии с руководством я добавил это в свой solrconfig.xml:

<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">
  <lst name="defaults">
    <str name="config">data-config.xml</str>
  </lst>
</requestHandler>  

в data-config.xml у меня есть следующее:

<dataConfig>
  <dataSource type="JdbcDataSource" 
              driver="com.mysql.jdbc.Driver"
              url="jdbc:mysql://localhost/site" 
              user="root" 
              password="123"/>
  <document>
    <entity name="profiles" 
            query="select user_id,about,music,movies,occupation from profiles">
    </entity>
  </document>
</dataConfig>

И это поля, определенные в моем schema.xml:

  <fields>
    <field name="user_id" type="string" indexed="true" stored="true" required="true" />
    <field name="about" type="string" indexed="true" stored="true" />
    <field name="music" type="string" indexed="true" stored="true" />
    <field name="movies" type="string" indexed="true" stored="true" />
    <field name="occupation" type="string" indexed="true" stored="true" />  
    <field name="text" type="text_general" indexed="true" stored="false" multiValued="true"/>
  </fields>

  <uniqueKey>user_id</uniqueKey>

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

и положи в мой/solr/libError: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

Error: User Rate Limit ExceededcomError: User Rate Limit ExceededmysqlError: User Rate Limit ExceededjbdcError: User Rate Limit ExceededDriver.class.

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceededsolr.xmlError: User Rate Limit Exceeded javanna
Error: User Rate Limit Exceeded192.168.136.129:8983/solr/admin/dataimport.jspError: User Rate Limit Exceeded nikhil500
Error: User Rate Limit Exceededsolrconfig.xmlError: User Rate Limit Exceeded beerbajay
Error: User Rate Limit Exceeded TK123
Error: User Rate Limit Exceeded bikedorkseattle

Ваш Ответ

5   ответов
5

<lib dir="../../../contrib/dataimporthandler/lib/" regex=".*\.jar" />
<lib dir="../../../dist/" regex="solr-dataimporthandler-\d.*\.jar" />

0

data-config.xmlsolrconfig.xml

0

"http://localhost/solr/dataimport" ,

</requestHandler>
<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">
<lst name="defaults">
<str name="config">data-config.xml</str>
</lst>
</requestHandler>

.

0

1

In \dist make sure you have dataimporter and mysqlconnector:

In \contrib\dataimporthandler\lib

activation-1.1.1.jar

mail-1.4.3.jar

In your collection solrconfig.xml should have

<lib dir="../../contrib/dataimporthandler/lib/" regex=".*\.jar" />
<lib dir="../../dist/" regex="solr-dataimporthandler-.*\.jar" />  
<lib dir="../../dist/" regex="mysql-connector-java-.*\.jar"/>  

  <requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">
    <lst name="defaults">
      <str name="config">db-data-config.xml</str>
    </lst>
  </requestHandler>

Похожие вопросы