ES-illegal_argument_exception报错

最新推荐文章于 2023-08-30 10:33:26 发布

yangkei

最新推荐文章于 2023-08-30 10:33:26 发布

阅读量2.1k

点赞数

分类专栏： es 文章标签： ES

本文链接：https://blog.csdn.net/yangkei/article/details/128617303

版权

es 专栏收录该内容

18 篇文章 4 订阅

订阅专栏

文章描述了一个在Elasticsearch中执行搜索查询时遇到的问题，由于尝试对text字段进行排序或聚合操作，导致了非法参数异常。解决方案是使用keyword字段或设置field_data为true，但后者可能消耗大量内存。文章提供了一个修正后的查询示例，将排序字段更改为name.keyword。

摘要由CSDN通过智能技术生成

查询语句：

POST food-ingredients-ext/_search
{
"from": 0,
"size": 20,
"query": {
    "multi_match": {
      "query": "cake mix",
      "type": "phrase",
      "fields": [
        "manufacture",
        "brand",
        "name"
      ]
    }
},
"highlight": {
    "fields": {
      "name": {
        "pre_tags": [
          "<em>"
        ],
        "post_tags": [
          "</em>"
        ]
      }
    }
},
"sort": [
    {
      "name": {
        "order": "asc"
      },
      "_score": {
        "order": "desc"
      }
    }
]
}

报错：

{
"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 [name] 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" : "food-ingredients-ext",
        "node" : "XBz2-lMTTHaljuXUKeWzgw",
        "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 [name] 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 [name] 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 [name] in order to load field data by uninverting the inverted index. Note that this can use significant memory."
      }
    }
},
"status" : 400
}

原因分析：text字段作为一个整体，默认没有索引。不过text分词之后的keyword是有索引的，因而可以对name.keyword进行聚合。

POST food-ingredients-ext/_search
{
"from": 0,
"size": 20,
"query": {
    "multi_match": {
      "query": "cake mix",
      "type": "phrase",
      "fields": [
        "manufacture",
        "brand",
        "name"
      ]
    }
},
"highlight": {
    "fields": {
      "name": {
        "pre_tags": [
          "<em>"
        ],
        "post_tags": [
          "</em>"
        ]
      }
    }
},
"sort": [
    {
      "name.keyword": {
        "order": "asc"
      },
      "_score": {
        "order": "desc"
      }
    }
]
}