ElasticsearchDSL查詢-可選的應該條款和分數

我對 Elasticsearch 世界還很陌生，我可能會遺漏一些概念。

這是我不理解的場景：

我想從以下標準中找到一個檔案：

• 類別.級別 = A
• category.name = "John .G" 或 "Chris T."
• 批準 = 是（可選）

映射：

PUT data
{
  "mappings": {
    "properties": {
      "createdAt": {
        "type":   "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSZ"
      },
      "category": {
        "type": "nested",
        "properties": {
          "name": {
            "type":   "text",
            "analyzer": "keyword"
          }
        }
      },
      "approved": {
        "type":   "text",
        "analyzer": "keyword"
      }
    }
  }
}

資料：

POST data/_create/1
{  
  "category": [
      {
        "name": "John G.",
        "level": "A"
      },
      {
        "name": "Mary F.",
        "level": "A"
      }
  ],
  "createdBy": "John",
  "createdAt": "2022-04-18 19:09:27.527 0200",
  "approved": "yes"
}

POST data/_create/2
{  
  "category": [
      {
        "name": "John G.",
        "level": "A"
      },
      {
        "name": "Chris T.",
        "level": "A"
      }
  ],
  "createdBy": "John",
  "createdAt": "2022-04-18 19:09:27.527 0200",
  "approved": "no"
}

POST data/_create/3
{  
  "category": [
      {
        "name": "John G.",
        "level": "C"
      },
      {
        "name": "Phil C.",
        "level": "C"
      }
  ],
  "createdBy": "John",
  "createdAt": "2022-04-18 19:09:27.527 0200",
  "approved": "no"
}

POST data/_create/4
{  
  "category": [
      {
        "name": "John G.",
        "level": "A"
      },
      {
        "name": "Chris T.",
        "level": "A"
      }
  ],
  "createdBy": "John",
  "createdAt": "2020-04-18 19:09:27.527 0200",
  "approved": "yes"
}

POST data/_create/5
{  
  "category": [
      {
        "name": "Unknown A.",
        "level": "A"
      },
      {
        "name": "Unknown B.",
        "level": "A"
      }
  ],
  "createdBy": "Unknown",
  "createdAt": "2020-08-18 19:09:27.527 0200",
  "approved": "yes"
}

詢問：

GET data/_search
{
  "query": {
    "nested": {
      "path": "category",
      "query": {
        "bool": {
          "must": [
            {"match": {"category.level": "A"}}
          ],
          "should": [
            {"term": {"category.name": "John G."}},
            {"term": {"category.name": "Chris T."}},
            {"term": {"approved": "yes"}}
          ],
          "minimum_should_match": 1
        }
      }
    }
  }
}

回復：

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 3,
      "relation" : "eq"
    },
    "max_score" : 1.4455402,
    "hits" : [
      {
        "_index" : "data",
        "_id" : "2",
        "_score" : 1.4455402,
        "_source" : {
          "category" : [
            {
              "name" : "John G.",
              "level" : "A"
            },
            {
              "name" : "Chris T.",
              "level" : "A"
            }
          ],
          "createdBy" : "John",
          "createdAt" : "2022-04-18 19:09:27.527 0200",
          "approved" : "no"
        }
      },
      {
        "_index" : "data",
        "_id" : "4",
        "_score" : 1.4455402,
        "_source" : {
          "category" : [
            {
              "name" : "John G.",
              "level" : "A"
            },
            {
              "name" : "Chris T.",
              "level" : "A"
            }
          ],
          "createdBy" : "John",
          "createdAt" : "2020-04-18 19:09:27.527 0200",
          "approved" : "yes"
        }
      },
      {
        "_index" : "data",
        "_id" : "1",
        "_score" : 1.151647,
        "_source" : {
          "category" : [
            {
              "name" : "John G.",
              "level" : "A"
            },
            {
              "name" : "Mary F.",
              "level" : "A"
            }
          ],
          "createdBy" : "John",
          "createdAt" : "2022-04-18 19:09:27.527 0200",
          "approved" : "yes"
        }
      }
    ]
  }
}

問題：

1. 為什么回傳的第一個檔案是一個approval = no? 我期待與 docsapproval = yes得分更高。
2. 為什么沒有回傳 index = 5 的檔案（它不符合條件category.name，但它符合approved = yes）？
3. approved = yes上述查詢中沒有表示的可選性。我怎么能用 創造一種額外的分離should術語minimum_should_match: 0？可以增加分數但不會過濾結果的東西。

uj5u.com熱心網友回復：

您需要使用以下具有主要查詢的bool查詢。它有第一個must帶有嵌套查詢的子句，它有欄位bool查詢category.level，然后是另一個bool帶有欄位should子句的查詢category.name。

現在主bool查詢有 should 子句，approved用于用yes值提升結果（這是外部nested查詢）。

POST data/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "category",
            "query": {
              "bool": {
                "must": [
                  {
                    "term": {
                      "category.level": {
                        "value": "a"
                      }
                    }
                  },
                  {
                    "bool": {
                      "should": [
                        {
                          "term": {
                            "category.name": "John G."
                          }
                        },
                        {
                          "term": {
                            "category.name": "Chris T."
                          }
                        }
                      ]
                    }
                  }
                ]
              }
            }
          }
        }
      ],
      "should": [
        {
          "term": {
            "approved": "yes"
          }
        }
      ]
    }
  }
}

結果：

{
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 3,
      "relation" : "eq"
    },
    "max_score" : 1.9845366,
    "hits" : [
      {
        "_index" : "data",
        "_type" : "_doc",
        "_id" : "4",
        "_score" : 1.9845366,
        "_source" : {
          "category" : [
            {
              "name" : "John G.",
              "level" : "A"
            },
            {
              "name" : "Chris T.",
              "level" : "A"
            }
          ],
          "createdBy" : "John",
          "createdAt" : "2020-04-18 19:09:27.527 0200",
          "approved" : "yes"
        }
      },
      {
        "_index" : "data",
        "_type" : "_doc",
        "_id" : "1",
        "_score" : 1.6906434,
        "_source" : {
          "category" : [
            {
              "name" : "John G.",
              "level" : "A"
            },
            {
              "name" : "Mary F.",
              "level" : "A"
            }
          ],
          "createdBy" : "John",
          "createdAt" : "2022-04-18 19:09:27.527 0200",
          "approved" : "yes"
        }
      },
      {
        "_index" : "data",
        "_type" : "_doc",
        "_id" : "2",
        "_score" : 1.4455402,
        "_source" : {
          "category" : [
            {
              "name" : "John G.",
              "level" : "A"
            },
            {
              "name" : "Chris T.",
              "level" : "A"
            }
          ],
          "createdBy" : "John",
          "createdAt" : "2022-04-18 19:09:27.527 0200",
          "approved" : "no"
        }
      }
    ]
  }
}

為什么回傳的第一個檔案是批準 = 否？我期望獲得批準 = yes 的檔案會得到更好的評分。

因為您should在查詢中有子句，并且它與外部nested的任何檔案都不匹配，因此它不會改變分數。approvedcategory

為什么沒有回傳索引 = 5 的檔案（它不符合條件 category.name，但它適用于已批準 = 是）？

它被您的 must 子句洗掉，但如果您還需要 index =5 檔案，那么您可以添加兩個should子句，一個用于嵌套，一個用于approved，它將解決您的問題。

我的回答也解決了您的問題 3。

uj5u.com熱心網友回復：

我用你的映射和示例資料嘗試了你的場景，發現了問題，你在導致問題approved:yes的nested查詢背景關系中使用，這導致問題，如果你將查詢更改為下面（基本上approved:yes在應該塊中使用，但是在nested查詢之外），它可以解決您的所有問題。

{
    "query": {
        "bool": {
            "should": [
                {
                    "nested": {
                        "path": "category",
                        "query": {
                            "bool": {
                                "must": [
                                    {
                                        "match": {
                                            "category.level": "A"
                                        }
                                    }
                                ],
                                "should": [
                                    {
                                        "term": {
                                            "category.name": "John G."
                                        }
                                    },
                                    {
                                        "term": {
                                            "category.name": "Chris T."
                                        }
                                    }
                                ]
                            }
                        }
                    }
                },
                {
                    "term": {
                        "approved": "yes"
                    }
                }
            ]
        }
    }
}

和搜索結果

"hits": [
            {
                "_index": "71967271",
                "_id": "4",
                "_score": 1.9845366,
                "_source": {
                    "category": [
                        {
                            "name": "John G.",
                            "level": "A"
                        },
                        {
                            "name": "Chris T.",
                            "level": "A"
                        }
                    ],
                    "createdBy": "John",
                    "createdAt": "2020-04-18 19:09:27.527 0200",
                    "approved": "yes"
                }
            },
            {
                "_index": "71967271",
                "_id": "2",
                "_score": 1.4455402,
                "_source": {
                    "category": [
                        {
                            "name": "John G.",
                            "level": "A"
                        },
                        {
                            "name": "Chris T.",
                            "level": "A"
                        }
                    ],
                    "createdBy": "John",
                    "createdAt": "2022-04-18 19:09:27.527 0200",
                    "approved": "no"
                }
            },
            {
                "_index": "71967271",
                "_id": "1",
                "_score": 1.2437345,
                "_source": {
                    "category": [
                        {
                            "name": "John G.",
                            "level": "A"
                        },
                        {
                            "name": "Mary F.",
                            "level": "A"
                        }
                    ],
                    "createdBy": "John",
                    "createdAt": "2022-04-18 19:09:27.527 0200",
                    "approved": "yes"
                }
            },
            {
                "_index": "71967271",
                "_id": "5",
                "_score": 0.7968255,
                "_source": {
                    "category": [
                        {
                            "name": "Unknown A.",
                            "level": "A"
                        },
                        {
                            "name": "Unknown B.",
                            "level": "A"
                        }
                    ],
                    "createdBy": "Unknown",
                    "createdAt": "2020-08-18 19:09:27.527 0200",
                    "approved": "yes"
                }
            }
        ]

標籤：弹性搜索 弹性搜索查询 弹性搜索嵌套

上一篇：如何匹配Elasticsearch中物件陣列中的所有物件？

下一篇：彈性搜索分析API回應并出現錯誤