solr mysql dataimporthandler仅检索id,而不是select*查询

7qhs6swi  于 2021-10-10  发布在  Java
关注(0)|答案(0)|浏览(179)

我是seo新手,对Solr8.8中的mysql数据提取有问题;尽管有下面的声明,文档只检索id,而不是整个id。

<document>
  <entity name="foobars"
    query="SELECT *, 'test' AS ENTITY FROM foobar"
    deltaquery="SELECT ID FROM foobar WHERE updated >= '${dataimporter.last_index_time}'"
    deltaimportquery="SELECT *, 'MAT' AS ENTITY FROM foobar WHERE ID = ${dataimporter.delta.id}">
    <field column="ENTITY" name="entity" />
    <field column="ID" name="id" />
    <field column="FOO" name="foo" />
    <field column="BAR" name="bar" />
    <field column="BAZ" name="baz" />
    <field column="UPDATED" name="updated" />  
  </entity>
</document>

这是导入内容的示例:

{
  "responseHeader":{
    "status":0,
    "QTime":9,
    "params":{
      "q":"*:*",
      "_":"1623166185835"}},
  "response":{"numFound":147,"start":0,"numFoundExact":true,"docs":[
      {
        "id":"214768.0",
        "_version_":1702016739810738176},
      {
        "id":"296594.0",
        "_version_":1702016739840098304},
...

有人知道我错过了什么吗?谢谢你的帮助。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题