elasticsearch对text类型进行聚合时遇到的问题

luslin1711

于 2020-05-27 17:25:06 发布

阅读量1.7k

点赞数

分类专栏：错误工具使用后端

本文链接：https://blog.csdn.net/luslin1711/article/details/106386040

版权

在Elasticsearch中对text类型字段进行聚合时遇到错误，需将字段的fielddata设为true。但这样做会导致每个字段被分词，解决方案是添加一个keyword类型的字段用于聚合，最终成功获取每个来源的数据量。

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

在elasticsearch中对数据进行聚合，想得出每个来源的数据量，mapping:

  "news_source": {
   
     "type": "text"
   },
   "related_freq": {
   
     "type": "integer"
   },

查询条件:

GET /event_news/_search
{
  "size": 0, 
  "aggs": {
    "news_source_info":{
      "terms": {
        "field": "news_source"
      },
      "aggs": {
        "total_sum": {
          "sum": {"field": "related_freq"}
        }
      }
    }
  }
}

结果报错

{
   
  "error": {
   
    "root_cause": [
      {
   
        "type": "illegal_argument_exception",
        "reason": "Fielddata is disabled on text fields by default. Set fielddata=true on [news_abstract] in order to load fielddata in memory by uninverting the inverted index. Note that this can however use significant memory. Alternatively use a keyword field instead."
      }
    ],
    "type": "search_phase_execution_exception",
    "reason": "all shards failed",
    "phase": "query",
    "grouped": true,
    "failed_shards": [
      {
   
        "shard": 0,
        "index": "event_news",