弹性搜索将文本字段添加到我的聚合中

Question

我在弹性搜索中有类似的文章信息：

{
   "ArticleId":355027,
   "ArticleNumber":"433398",
   "CharacteristicsMultiValue":[
      {
         "Name":"Aantal cartridges",
         "Value":"4",
         "NumValue":4,
         "Priority":2147483647
      },
      {
         "Name":"ADF",
         "Value":"Ja",
         "Priority":10,
         "Description":"Een Automatic Document Feeder (ADF), of automatische documentinvoer, laat een multifunctionele printer (all-in-one) automatisch meerdere vellen na elkaar verwerken. Door meerdere vellen in de ADF te plaatsen, wordt ieder vel papier stuk voor stuk automatisch gekopieerd of gescand."
      },
      {
         "Name":"Scanresolutie",
         "Value":"600x600 DPI",
         "Priority":2147483647
      }
   ]
}

我正在运行以下查询，以检索我的搜索所有可能值的tremitasissmultivalue，并将它们对我的喜好进行分类。

{
  "query": {
    "query_string": {
     "query": "433398",
     "default_operator": "and"
    }
  },
  "aggs":{
    "CharacteristicsMultiValue":{
      "nested":{
        "path":"CharacteristicsMultiValue"
       },
       "aggs":{
         "Name":{
           "terms":{
            "field":"CharacteristicsMultiValue.Name",
            "size":25
          },
          "aggs":{
            "Value":{
              "terms":{
                "field":"CharacteristicsMultiValue.Value",
                "size":25
              }
            }, 
            "Priority":{
              "avg":{
                "field":"CharacteristicsMultiValue.Priority"
              }
            },
            "Characteristics_sort": {
              "bucket_sort": {
                "sort": [
                  { "Priority": { "order": "asc" } } 
                ]                               
              }
            }       
          }
        }
      }
    }
  }
}

结果显示了tremitiatesMultivalue的列表。

{
   "key":"ADF",
   "doc_count":1,
   "Priority":{
      "value":10
   },
   "Value":{
      "doc_count_error_upper_bound":0,
      "sum_other_doc_count":0,
      "buckets":[
         {
            "key":"Ja",
            "doc_count":1
         }
      ]
   }
}

这一切都很好。我想进行更改，以便trumitiessmultivalue.description字段包含在聚合中。我并不是真正的弹性搜索经验，但是我觉得我应该很容易做到这一点。

我做了一些研究，要我理解，我需要为描述列添加一个新的子聚合。我试图通过将下面的JSON添加到当前查询中的几个地方来做到这一点，但是我一直在404错误。谁能告诉我如何添加（第一个找到）描述字段到我的聚合中。

"aggs":{
    "Description":{
        "terms":{
            "field":"CharacteristicsMultiValue.Description",
            "size":1
        }
    }
}

---

我测试了乔提出的解决方案。这会导致以下错误响应：

{ 
  "error": { 
    "root_cause": [ 
      {
        "type": "illegal_argument_exception",
        "reason": "Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [CharacteristicsMultiValue.Description] in order to load field data by uninverting the inverted index. Note that this can use significant memory."
      }
    ],
    "type": "search_phase_execution_exception",
    "reason": "all shards failed",
    "phase": "query",
    "grouped": true,
    "failed_shards": [
      {
        "shard": 0,
        "index": "articles_dev1_nl",
        "node": "HiGH6JY9QvOozRSWJmFXpw",
        "reason": {
          "type": "illegal_argument_exception",
          "reason": "Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [CharacteristicsMultiValue.Description] in order to load field data by uninverting the inverted index. Note that this can use significant memory."
        }
      }
    ],
    "caused_by": {
      "type": "illegal_argument_exception",
      "reason": "Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [CharacteristicsMultiValue.Description] in order to load field data by uninverting the inverted index. Note that this can use significant memory.",
      "caused_by": {
        "type": "illegal_argument_exception",
        "reason": "Text fields are not optimised for operations that require per-document field data like aggregations and sorting, so these operations are disabled by default. Please use a keyword field instead. Alternatively, set fielddata=true on [CharacteristicsMultiValue.Description] in order to load field data by uninverting the inverted index. Note that this can use significant memory."
      }
    }
  },
  "status": 400
}

Answer 1

我不知道为什么您会得到404错误 - 如果您的汇总语法已关闭，通常是400不良请求。

无论哪种方式，如果您想在每个桶装value下找到顶部descript术语，则可以使用：

{
  "query": {
    "query_string": {
      "query": "433398",
      "default_operator": "and"
    }
  },
  "aggs": {
    "CharacteristicsMultiValue": {
      "nested": {
        "path": "CharacteristicsMultiValue"
      },
      "aggs": {
        "Name": {
          "terms": {
            "field": "CharacteristicsMultiValue.Name",
            "size": 25
          },
          "aggs": {
            "Value": {
              "terms": {
                "field": "CharacteristicsMultiValue.Value",
                "size": 25
              },
    -->       "aggs": {
                "Description": {
                  "terms": {
                    "field": "CharacteristicsMultiValue.Description",
                    "size": 1
                  }
                }
              }
            },
            "Priority": {
              "avg": {
                "field": "CharacteristicsMultiValue.Priority"
              }
            },
            "Characteristics_sort": {
              "bucket_sort": {
                "sort": [
                  {
                    "Priority": {
                      "order": "asc"
                    }
                  }
                ]
              }
            }
          }
        }
      }
    }
  }
}

一般而言，

{
  "query": { },  // optional query
  "aggs": {
    "your_agg_name": {
      "agg_type": {
        // agg spec
      },
      "aggs": {
        "your_sub_agg_name_1": {
          "agg_type": {
            // agg spec
          }
        },
        "your_sub_agg_name_2_if_needed": {
          "agg_type": {
            // agg spec
          }
        },
        ...
      }
    }
  }
}

​

• ​strong> nest进一步sub-aggs 就像您已经使用了name-＆gt; value或value-＆gt; description从我的示例
• 中相同的级别像name-＆gt; value和name-＆gt; Priority一样。

---