elasticsearch過濾嵌套物件

我有一個帶有嵌套物件的索引，其中包含兩個屬性，即scopeId和categoryName。以下是索引的映射部分

    "mappedCategories" : {
      "type" : "nested",
      "properties": {
        "scopeId": {"type":"long"},
        "categoryName": {"type":"text",
          "analyzer" : "productSearchAnalyzer",
          "search_analyzer" : "productSearchQueryAnalyzer"}
      }
    
    }

包含嵌套的 mappedCategories 物件的示例檔案如下：

POST productsearchna_2/_doc/1
{
          "categoryName" : "Operating Systems",
          "contexts" : [
            0
          ],
          "countryCode" : "US",
          "id" : "10076327-1",
          "languageCode" : "EN",
          "localeId" : 1,
          "mfgpartno" : "test123",
          "manufacturerName" : "Hewlett Packard Enterprise",
          "productDescription" : "HPE Microsoft Windows 2000 Datacenter Server - Complete Product - Complete Product - 1 Server - Standard",
          "productId" : 10076327,
          "skus" : [ 
            {"sku": "43233004",
              "skuName": "UNSPSC"},
            {"sku": "43233049",
              "skuName": "SP Richards"},
            {"sku": "43234949",
              "skuName": "Ingram Micro"}
          ],
          "mappedCategories" : [ 
            {"scopeId": 3228552,
              "categoryName": "Laminate Bookcases"},
            {"scopeId": 3228553,
              "categoryName": "Bookcases"},
            {"scopeId": 3228554,
              "categoryName": "Laptop"}
          ]
 }

我想在 scopeId: 3228553上過濾 categoryName“ lap ”，即我的查詢應該回傳 0 個命中，因為膝上型計算機映射到 scopeId 3228554。但我的以下查詢回傳 1 個命中，scopeId：3228554

POST productsearchna_2/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "mappedCategories",
            "query": {
              "term": {
                "mappedCategories.categoryName": "lap"
              }
            },
            "inner_hits": {}
          }
        }
      ],
      "filter": [
        {
          "nested": {
            "path": "mappedCategories",
            "query": {
              "term": {
                "mappedCategories.scopeId": {
                  "value": 3228552
                }
              }
            }
          }
        }
      ]
    }
  },
  "_source": ["mappedCategories.categoryName", "productId"]
} 

以下是查詢結果的一部分：

"inner_hits" : {
          "mappedCategories" : {
            "hits" : {
              "total" : {
                "value" : 1,
                "relation" : "eq"
              },
              "max_score" : 1.5586993,
              "hits" : [
                {
                  "_index" : "productsearchna_2",
                  "_type" : "_doc",
                  "_id" : "1",
                  "_nested" : {
                    "field" : "mappedCategories",
                    "offset" : 2
                  },
                  "_score" : 1.5586993,
                  "_source" : {
                    "scopeId" : 3228554,
                    "categoryName" : "Laptop"
                  }
                }
              ]
            }
          }

我希望我的查詢回傳零命中，如果我使用 scopeId：3228552 搜索“書”，我希望我的查詢回傳 2 個命中，1 個用于書柜，另一個用于層壓書柜類別名稱。請幫忙。

uj5u.com熱心網友回復：

此查詢解決了部分問題，但是當使用 scopeId: 3228552 搜索 book 時，它只會得到 1 個結果。

GET idx_test/_search?filter_path=hits.hits.inner_hits
{
  "query": {
    "nested": {
      "path": "mappedCategories",
      "query": {
        "bool": {
          "filter": [
            {
              "term": {
                "mappedCategories.scopeId": {
                  "value": 3228553
                }
              }
            }
          ],
          "must": [
            {
              "match": {
                "mappedCategories.categoryName": "laptop"
              }
            }
          ]
        }
      },
      "inner_hits": {}
    }
  }
} 

標籤：弹性搜索

上一篇：Elasticsearch基數聚合例外

下一篇：為什么在初始資料上傳時將refresh_interval設定為-1時ElasticSearch索引可搜索？