ElasticSearch：查询嵌套数组

3pvhb19x 于 2023-02-18 发布在 ElasticSearch

关注(0)|答案(1)|浏览(152)

我正在尝试编写多字段查询的搜索功能，但是在嵌套数组中进行全文搜索时存在一些问题
我的数据格式如下：

{
  "name": "[Sample] AAA",
  "variant": [
    ["s", "black"],
    ["l", "white"],
  ],
},
{
  "name": "[Sample] BBB",
  "variant": [
    ["s", "white"],
    ["l", "black"],
  ],
},

对于输入sample s black或sample black s，我希望找到所有具有s和black选项（如[Sample] AAA，但不包括[Sample] BBB）的文档。我尝试了nested查询，但没有得到所需的结果。是否有任何方法可以重构数据格式并编写最佳Map？

elasticsearch

来源：https://stackoverflow.com/questions/75444965/elasticsearch-query-nested-array

1条答案

按热度按时间

xqkwcwgp1#

使用以下Map创建索引

PUT my_index
{
  "mappings": {
    "properties": {
      "name": {
        "type": "text"
      },
      "variant": {
        "type": "nested",
        "properties": {
          "0": {
            "type": "keyword"
          },
          "1": {
            "type": "text"
          }
        }
      }
    }
  }
}

把样本文件

PUT my_index/_doc/1
{
  "name": "[Sample] AAA",
  "variant": [
    ["s", "black"],
    ["l", "white"],
  ]
}

PUT my_index/_doc/2
{
  "name": "[Sample] BBB",
  "variant": [
    ["s", "white"],
    ["l", "black"],
  ]
}

去拿文件

GET my_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "variant",
            "query": {
              "bool": {
                "must": [
                  {
                    "match": {
                      "variant.key": "s"
                    }
                  },
                  {
                    "match": {
                      "variant.value": "black"
                    }
                  }
                ]
              }
            }
          }
        }
      ]
    }
  }
}

赞(0）回复(0）举报 2023-02-18

我来回答

ElasticSearch：查询嵌套数组

1条答案

相关问题

热门标签

最新问答