文章目錄

• 概述
• 官方指導(dǎo)
• • Metrics Aggregations
  • Min Aggregation
  • Max Aggregation
  • Sum Aggregation
• 案例：統(tǒng)計(jì)每種顏色電視最大最小價(jià)格

---

概述

繼續(xù)跟中華石杉老師學(xué)習(xí)ES，第35篇

課程地址： https://www.roncoo.com/view/55

---

官方指導(dǎo)

Metrics Aggregations

• count：bucket，terms，自動(dòng)就會(huì)有一個(gè)doc_count，就相當(dāng)于是count

• avg：avg aggs，求平均值

• max：求一個(gè)bucket內(nèi)，指定field值最大的那個(gè)數(shù)據(jù)

• min：求一個(gè)bucket內(nèi)，指定field值最小的那個(gè)數(shù)據(jù)

• sum：求一個(gè)bucket內(nèi)，指定field值的總和

太多了，挑幾個(gè)常用的說吧

---

Min Aggregation

Min Aggregation ： 戳這里

---

Max Aggregation

Max Aggregation ： 戳這里

---

Sum Aggregation

Sum Aggregation： 戳這里

---

案例：統(tǒng)計(jì)每種顏色電視最大最小價(jià)格

原始數(shù)據(jù)：

DSL:

#統(tǒng)計(jì)每種顏色電視最大最小價(jià)格 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": "藍(lán)色","doc_count": 2,"max_price": {"value": 2500},"min_price": {"value": 1500},"avg_price": {"value": 2000},"sum_price": {"value": 4000}}]}} }

總結(jié)

以上是生活随笔為你收集整理的白话Elasticsearch35-深入聚合数据分析之案例实战更多metrics用法：统计每种颜色电视最大最小价格的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。