我是新来的索尔我遵循一些教程来设置它。我在用Postgresql。当我跑回来时:

<response>
  <lst name="responseHeader">
    <int name="status">0</int>
    <int name="QTime">7</int>
    <lst name="params">
      <str name="q">*:*</str>
    </lst></lst>
    <result name="response" numFound="56" start="0">
      <doc>
        <str name="id">1</str>
      </doc>
      <doc>
        <str name="id">2</str>
      </doc>
      ...
      ...
      <doc>
        <str name="id">10</str>
      </doc>
    </result>
  </response>

我希望能得到一份有名字和姓氏的孩子的名单。
我的http://localhost:8080/solr/select?q=*:*中的requestHandler
  <requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">
 <lst name="defaults">
   <str name="config">data-config.xml</str>
 </lst>

mysolrconfig.xml
    <dataConfig>
<dataSource type="JdbcDataSource"
        driver="org.postgresql.Driver"
        name="ds1" url="jdbc:postgresql://localhost/some_db" user="db_user" password="hatpants" />
  <document name="kids">
    <entity name="kid" pk="ID" dataSource="ds1"
            query="select id,first_name,last_name from kid">
        <field column="ID" name="id" indexed="true" />
        <field column="FIRST_NAME" name="first_name" indexed="true" />
        <field column="LAST_NAME" name="last_name" indexed="true" />
    </entity>
  </document>
</dataConfig>

当我运行数据导入时:data-config.xml我得到:
<response>
  <lst name="responseHeader">
    <int name="status">0</int>
    <int name="QTime">4</int>
  </lst>
  <lst name="initArgs">
    <lst name="defaults">
      <str name="config">data-config.xml</str>
    </lst></lst>
    <str name="command">full-import</str>
    <str name="status">idle</str>
    <str name="importResponse"/>
    <lst name="statusMessages">
      <str name="Total Requests made to DataSource">1</str>
      <str name="Total Rows Fetched">56</str>
      <str name="Total Documents Skipped">0</str>
      <str name="Full Dump Started">2014-01-04 04:47:14</str>
      <str name="">Indexing completed. Added/Updated: 56 documents. Deleted 0 documents.</str>
      <str name="Committed">2014-01-04 04:47:14</str>
      <str name="Optimized">2014-01-04 04:47:14</str>
      <str name="Total Documents Processed">56</str>
      <str name="Time taken ">0:0:0.243</str>
    </lst>
    <str name="WARNING">This response format is experimental.  It is likely to change in the future.</str>
  </response>

在我看来,它似乎能够连接到数据库。我在数据库里一共有56条记录。当我做一个特定的选择时,它不会返回任何结果。

最佳答案

我想出来了。
我需要将这些字段添加到schema.xml文件的fields部分。

<field name="first_name" type="text" indexed="true" stored="true" multiValued="true" />
<field name="last_name" type="text" indexed="true" stored="true" multiValued="true" />


<copyField source="first_name" dest="text"/>
<copyField source="last_name" dest="text"/>

09-10 07:49
查看更多