ElasticSearch 聚合查询(2)桶聚合学习

最新推荐文章于 2025-03-28 09:30:00 发布

原创最新推荐文章于 2025-03-28 09:30:00 发布 · 325 阅读

0 ·

CC 4.0 BY-SA版权

Java 专栏收录该内容

8 篇文章

订阅专栏

本文深入解析Elasticsearch中的TermsAggregation、filterAggregation、RangeAggregation等聚合查询技术，通过具体示例展示了如何根据字段值项、过滤条件及数值范围进行高效的数据分组与统计。

1. Terms Aggregation 根据字段值项分组聚合

GET /megacorp/employee/_search?size=0 HTTP/1.1
Host: 192.168.31.233:9200
Content-Type: application/json

{
    "aggs": {
        "age_terms": {
            "terms": {
                "field": "age"
            }
        }
    }
}

Results:

{
    "took": 42,
    "timed_out": false,
    "_shards": {
        "total": 5,
        "successful": 5,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": 7,
        "max_score": 0.0,
        "hits": []
    },
    "aggregations": {
        "age_terms": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": 35,
                    "doc_count": 3
                },
                {
                    "key": 25,
                    "doc_count": 2
                },
                {
                    "key": 32,
                    "doc_count": 2
                }
            ]
        }
    }
}

结果说明：

“doc_count_error_upper_bound”: 0：文档计数的最大偏差值

“sum_other_doc_count”: 463：未返回的其他项的文档数

默认情况下返回按文档计数从高到低的前10个分组：

2. filter Aggregation 对满足过滤查询的文档进行聚合计算

POST /megacorp/employee/_search?size=0
{
  "aggs": {
    "age_terms": {
      "filter": {"match":{"gender":"F"}},
      "aggs": {
        "avg_age": {
          "avg": {
            "field": "age"
          }
        }
      }
    }
  }
}

3. Range Aggregation 范围分组聚合

GET /megacorp/employee/_search?size=0 HTTP/1.1
Host: 192.168.31.233:9200
Content-Type: application/json

{
    "aggs": {
        "age_range": {
            "range": {
                "field": "age",
                "ranges": [
                    {
                        "to": 25
                    },
                    {
                        "from": 25,
                        "to": 35
                    },
                    {
                        "from": 35
                    }
                ]
            }
        }
    }
}

Results:

{
    "took": 7,
    "timed_out": false,
    "_shards": {
        "total": 5,
        "successful": 5,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": 7,
        "max_score": 0.0,
        "hits": []
    },
    "aggregations": {
        "age_range": {
            "buckets": [
                {
                    "key": "*-25.0",
                    "to": 25.0,
                    "doc_count": 0
                },
                {
                    "key": "25.0-35.0",
                    "from": 25.0,
                    "to": 35.0,
                    "doc_count": 4
                },
                {
                    "key": "35.0-*",
                    "from": 35.0,
                    "doc_count": 3
                }
            ]
        }
    }
}