弹性搜索查询，用于匹配同一嵌套字段的不同值

Question

我试图获取嵌套文档中有两个名称的文档，但是< code>must子句作为“OR”而不是“AND”工作。下面是一个例子:

映射:

curl  -XPUT "http://localhost:9200/my_index" -d '
{
  "mappings": {
    "blogpost": {
      "properties": {
        "comments": {
          "type": "nested",
          "properties": {
            "name":    { "type": "keyword"   },
            "age":     { "type": "short"   }
          }
        }
      }
    }
  }
}'

索引3个文档：

curl  "http://localhost:9200/my_index/blogpost/1" -d '
{
  "title": "doc1",
  "comments": [
    {
      "name":    "John Smith",
      "age":     28
    },
    {
      "name":    "Alice White",
      "age":     31
    }
  ]
}
'

curl  "http://localhost:9200/my_index/blogpost/2" -d '
{
  "title": "doc2",
  "comments": [
    {
      "name":    "Luther Lawrence",
      "age":     21
    },
    {
      "name":    "Alice White",
      "age":     19
    }
  ]
}
'

curl  "http://localhost:9200/my_index/blogpost/3" -d '
{
  "title": "doc3",
  "comments": [
    {
      "name":    "Tadhg Darragh",
      "age":     22
    },
    {
      "name":    "Alice White",
      "age":     31
    },
    {
      "name":    "Lorene Hicks",
      "age":     44
    }
  ]
}
'

我正在寻找在同一文档中与“爱丽丝·怀特”和“约翰·史密斯”comments.name 的文档，使用上述数据只有文档ID 1会匹配。我尝试了这个查询：

curl  "http://localhost:9200/my_index/blogpost/_search" -d '
{
  "_source": { "include": "title" },
  "query": {
    "nested": {
      "path": "comments",
      "query": {
        "bool": {
          "must": [
            { "terms": { "comments.name": ["John Smith", "Alice White"] } }
          ]
        }
      }
    }
  }
}
'

它与所有文档匹配，因为所有文档都有“John Smith”或“Alice White”。改进此查询以具有两个分离的匹配项query.nested.query.bool.must[]. words，每个值一个匹配器：

curl  "http://localhost:9200/my_index/blogpost/_search" -d '
{
  "_source": { "include": "title" },
  "query": {
    "nested": {
      "path": "comments",
      "query": {
        "bool": {
          "must": [
            { "term": { "comments.name": "John Smith" } },
            { "term": { "comments.name": "Alice White" } }
          ]
        }
      }
    }
  }
}
'

那么，我的问题是，如何构建一个查询来仅匹配具有“爱丽丝·怀特”和“约翰·史密斯”的文档？

ps. 在这里放置了一个带有示例的脚本

Answer 1

{
  "_source": {
    "include": "title"
  },
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "comments",
            "query": {
              "bool": {
                "must": [
                  {
                    "terms": {
                      "comments.name": [
                        "John Smith"
                      ]
                    }
                  }
                ]
              }
            }
          }
        },
        {
          "nested": {
            "path": "comments",
            "query": {
              "bool": {
                "must": [
                  {
                    "terms": {
                      "comments.name": [
                        "Alice White"
                      ]
                    }
                  }
                ]
              }
            }
          }
        }
      ]
    }
  }
}