Elasticsearch5.x版本中对Text类型进行聚合时提示illegal_argument_exception

怼烎@ 2022-09-06 13:29 50阅读 0赞

Having this field in my mapping

![复制代码][48304ba5e6f9fe08f3fa1abda7d326ab.png]

"answer": {
            "type": "text",
            "fields": {
              "keyword": {
                "type": "keyword",
                "ignore_above": 256
              }
            }
          },

![复制代码][48304ba5e6f9fe08f3fa1abda7d326ab.png]

I try to execute this aggregation

![复制代码][48304ba5e6f9fe08f3fa1abda7d326ab.png]

"aggs": {
    "answer": {
      "terms": {
        "field": "answer"
      }
    },

![复制代码][48304ba5e6f9fe08f3fa1abda7d326ab.png]

but I get this error

"type": "illegal_argument_exception",
          "reason": "Fielddata is disabled on text fields by default. Set fielddata=true on [answer] in order to load fielddata in memory by uninverting the inverted index. Note that this can however use significant memory."

得到解决
    You need to aggregate on the keyword sub-field, like this:

![复制代码][48304ba5e6f9fe08f3fa1abda7d326ab.png]

"aggs": {
    "answer": {
      "terms": {
        "field": "answer.keyword"
      }
    },

![复制代码][48304ba5e6f9fe08f3fa1abda7d326ab.png]

开始在网上查询解决方案时,有的是修改mapping 
    1.PUT my_index/_mapping/my_type
    {
      "properties": {
        "my_field": { 
          "type":     "text",
          "fielddata": true
        }
      }
    }
    
    或者

2.使用.keyword 推荐
    "aggs": {
    "answer": {
      "terms": {
        "field": "answer.keyword"
      }
    }

[48304ba5e6f9fe08f3fa1abda7d326ab.png]: /images/20220829/74f5f898bb344ee481765969596036d0.png