概述
继续跟中华石杉老师学习ES，第35篇
课程地址： https://www.roncoo.com/view/55
官方指导
Metrics Aggregations
- count：bucket，terms，自动就会有一个doc_count，就相当于是count
- avg：avg aggs，求平均值
- max：求一个bucket内，指定field值最大的那个数据
- min：求一个bucket内，指定field值最小的那个数据
- sum：求一个bucket内，指定field值的总和
太多了，挑几个常用的说吧
Min Aggregation
Min Aggregation ： 戳这里
Max Aggregation
Max Aggregation ： 戳这里
Sum Aggregation
Sum Aggregation： 戳这里
案例：统计每种颜色电视最大最小价格
原始数据：
DSL:
#统计每种颜色电视最大最小价格 GET /tvs/sales/_search { "size": 0, "aggs": { "colors": { "terms": { "field": "color" }, "aggs": { "avg_price": { "avg": { "field": "price" } }, "min_price": { "min": { "field": "price" } }, "max_price": { "max": { "field": "price" } }, "sum_price": { "sum": { "field": "price" } } } } } }
返回：
{ "took": 4, "timed_out": false, "_shards": { "total": 5, "successful": 5, "skipped": 0, "failed": 0 }, "hits": { "total": 8, "max_score": 0, "hits": [] }, "aggregations": { "color": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "红色", "doc_count": 4, "max_price": { "value": 8000 }, "min_price": { "value": 1000 }, "avg_price": { "value": 3250 }, "sum_price": { "value": 13000 } }, { "key": "绿色", "doc_count": 2, "max_price": { "value": 3000 }, "min_price": { "value": 1200 }, "avg_price": { "value": 2100 }, "sum_price": { "value": 4200 } }, { "key": "蓝色", "doc_count": 2, "max_price": { "value": 2500 }, "min_price": { "value": 1500 }, "avg_price": { "value": 2000 }, "sum_price": { "value": 4000 } } ] } } }
