ES存在查询

Question

我有一个具有嵌套字段的文档：

• 测试数据。测试数据ID

我只想获取包含测试数据的文档。testDataId为空

以下是我的疑问：

{
  "bool": {
    "must_not": [
      { "exists": { "field": "testData.testDataId", "boost": 1.0 } }
    ],
    "adjust_pure_negative": true,
    "boost": 1.0
  }
}

但是我有和那些'testData'为空的文档。可以禁用吗？

例如：我有那3个文件

[
  {
    "name": "test_user_1",
    "additionalInfo": { "phoneNumber": "00000000", "address": "test_address" },
    "testData": { "testDataId": "some_id", "description": "test_description" }
  },
  {
    "name": "test_user_2",
    "additionalInfo": { "phoneNumber": "00000000", "address": "test_address" },
    "testData": { "description": "test_description" }
  },
  {
    "name": "test_user_3",
    "additionalInfo": { "phoneNumber": "00000000", "address": "test_address" }
  }
]

我希望只检索test_user_2

Answer 1

由于您正在处理嵌套字段，因此需要使用嵌套查询。

GET /72491619/_search
{
  "query": {
    "nested": {
      "path": "testData",
      "query": {
        "bool": {
          "must_not": [
            {
              "exists": {
                "field": "testData.testDataId"
                }
            }
          ]
        }
      }
    }
  }
}

为了设置索引和数据，我使用了下面的api调用：

PUT /72491619/
{
  "mappings": {
    "properties": {
      "name": {
        "type": "keyword"
      },
      "additionalInfo":{
        "type": "nested",
        "properties": {
          "phoneNumber": {
            "type": "keyword"
          },
          "address": {
            "type": "keyword"
          }
        }
      },
      "testData":{
        "type": "nested",
        "properties": {
          "testDataId": {
            "type": "keyword"
          },
          "description": {
            "type": "keyword"
          }
        }
      }
    }
  }
}

POST /_bulk
{"index":{"_index":"72491619"}}
{"name":"test_user_1","additionalInfo":{"phoneNumber":"00000000","address":"test_address"},"testData":{"testDataId":"some_id","description":"test_description"}}
{"index":{"_index":"72491619"}}
{"name":"test_user_2","additionalInfo":{"phoneNumber":"00000000","address":"test_address"},"testData":{"description":"test_description"}}
{"index":{"_index":"72491619"}}
{"name":"test_user_3","additionalInfo":{"phoneNumber":"00000000","address":"test_address"}}