我是新来的索尔我遵循一些教程来设置它。我在用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>
my
solrconfig.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"/>