热门标签
热门文章
- 1Android Studio音乐播放器（使用sqlite创建数据库）_音乐播放器android studio
- 2Java NIO编程实例_java nio编程案例
- 3全网首发亲测有用：python免费将chatgpt机器人接入个人微信（同时支持钉钉、QQ 以及别的语言模型如文心一言等）_chatgpt怎么接入微信
- 4逻辑回归——牛顿法矩阵实现方式
- 5[ELK实战] Elasticsearch 聚合查询二: Bucketing/桶聚合_elk es查询时间查询
- 6辅警考试怎么搜题答案？八个受欢迎的搜题分享了 #学习方法#学习方法#媒体_千鸟搜题
- 7最优化算法之粒子群算法PSO_粒子群算法是谁提出的
- 8H3C SSH远程登录配置_h3c ssh配置
- 9第23篇 Android Studio第一个程序HelloWorld_android studio 4.2.2 helloworld
- 10Ubuntu20.04安装微信等软件全过程_ubantu20.04 安装微信
当前位置: article > 正文
elasticSearch核心概念的介绍（十）：指标聚合查询_elasticsearch指标聚会
作者：我家小花儿 | 2024-07-01 00:09:01
赞
踩
elasticsearch指标聚会
聚合查询之指标查询
上一章介绍基本的范围、布尔、排序查询，有兴趣的可以参考一下
elasticSearch核心概念的介绍（九）：范围、布尔、排序查询
这一章我们介绍了聚合查询的指标聚合
ES 聚合查询是什么
- 聚合查询时数据库中重要的功能特性，完成对一个查询得到的数据集的聚合计算，如：找出某字段（或计算表达式的结果）的最大值、最小值、计算和、平均值等。ES作为搜索引擎，同样提供了强大的聚合分析能力。
- 对一个数据集求最大、最小、和、平均值等指标的聚合，在ES 中成为指标聚合
- 而关系型数据中除了有集合函数外，还可以对查询出的数据进行分组group by，再在祖上进行指标聚合，在ES 中称为 桶聚合
| – | – |
|---|---|
| max | 最大数 |
| min | 最小数 |
| sum | 求和 |
| avg | 平均数 |
| value_count | 统计非空字段的文档数 |
| Cardinality | 值去重 |
| stats | 统计 count max min avg sum5个值 |
| Extended stats | 比stats多4个统计：平方和、方差、标准差、平均值加/减两个标准差的区间 |
| Percentiles | 占比百分位对应的值统计，默认返回[1,5,25,50,75,95,99]分位上的值 |
查询出平均球衣号
-
请求
curl -X POST "http://172.25.45.150:9200/nba/_search" -H 'Content-Type:application/json' -d ' { "query":{ "match":{ "name":"库里" } }, "aggs":{ "avgJer":{ "avg":{ "field":"jerse_no" } } } } '- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
-
响应
{ "took": 3, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 3, "relation": "eq" }, "max_score": 0.26706278, "hits": [ { "_index": "nba", "_type": "_doc", "_id": "l4cuG38B4RxnBaUYPdnZ", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 30 } }, { "_index": "nba", "_type": "_doc", "_id": "mIcuG38B4RxnBaUYWNko", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 23 } }, { "_index": "nba", "_type": "_doc", "_id": "mYcuG38B4RxnBaUYadlM", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 35 } } ] }, "aggregations": { "avgJer": { "value": 29.333333333333332 } } }- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
Cardinality 去重
-
请求
curl -X POST "http://172.25.45.150:9200/nba/_search" -H 'Content-Type:application/json' -d ' { "query":{ "match":{ "name":"库里" } }, "aggs":{ "avgJer":{ "cardinality":{ "field":"position" } } } } '- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
-
响应
{ "took": 21, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 3, "relation": "eq" }, "max_score": 0.26706278, "hits": [ { "_index": "nba", "_type": "_doc", "_id": "l4cuG38B4RxnBaUYPdnZ", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 30 } }, { "_index": "nba", "_type": "_doc", "_id": "mIcuG38B4RxnBaUYWNko", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 23 } }, { "_index": "nba", "_type": "_doc", "_id": "mYcuG38B4RxnBaUYadlM", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 35 } } ] }, "aggregations": { "avgJer": { "value": 1 } } }- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
stats 查出聚合集合
-
请求
curl -X POST "http://172.25.45.150:9200/nba/_search" -H 'Content-Type:application/json' -d ' { "query":{ "match":{ "name":"库里" } }, "aggs":{ "statsAge":{ "stats":{ "field":"jerse_no" } } } } '- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
-
响应
{ "took": 10, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 3, "relation": "eq" }, "max_score": 0.26706278, "hits": [ { "_index": "nba", "_type": "_doc", "_id": "l4cuG38B4RxnBaUYPdnZ", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 30 } }, { "_index": "nba", "_type": "_doc", "_id": "mIcuG38B4RxnBaUYWNko", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 23 } }, { "_index": "nba", "_type": "_doc", "_id": "mYcuG38B4RxnBaUYadlM", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 35 } } ] }, "aggregations": { "statsAge": { "count": 3, "min": 23.0, "max": 35.0, "avg": 29.333333333333332, "sum": 88.0 } } }- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
Extended stats
-
请求
curl -X POST "http://172.25.45.150:9200/nba/_search" -H 'Content-Type:application/json' -d ' { "query":{ "match":{ "name":"库里" } }, "aggs":{ "extendStats":{ "extended_stats":{ "field":"jerse_no" } } } } '- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
-
响应
{ "took": 20, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 3, "relation": "eq" }, "max_score": 0.26706278, "hits": [ { "_index": "nba", "_type": "_doc", "_id": "l4cuG38B4RxnBaUYPdnZ", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 30 } }, { "_index": "nba", "_type": "_doc", "_id": "mIcuG38B4RxnBaUYWNko", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 23 } }, { "_index": "nba", "_type": "_doc", "_id": "mYcuG38B4RxnBaUYadlM", "_score": 0.26706278, "_source": { "name": "库里", "team_name": "勇士", "position": "组织后卫", "play_year": "10", "jerse_no": 35 } } ] }, "aggregations": { "extendStats": { "count": 3, "min": 23.0, "max": 35.0, "avg": 29.333333333333332, "sum": 88.0, "sum_of_squares": 2654.0, "variance": 24.22222222222217, "std_deviation": 4.921607686744462, "std_deviation_bounds": { "upper": 39.17654870682226, "lower": 19.490117959844408 } } } }- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
Percentiles 统计球衣号的占比
-
请求
curl -X POST "http://172.25.45.150:9200/nba/_search" -H 'Content-Type:application/json' -d ' { "query":{ "match":{ "name":"库里" } }, "aggs":{ "percentJerse":{ "percentiles":{ "field":"jerse_no" } } } } '- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
-
当前我们也可以自定义百分位数，不使用默认的参数如下
{ "query":{ "match":{ "name":"库里" } }, "aggs":{ "percentJerse":{ "percentiles":{ "field":"jerse_no", "percents":[ 20, 50, 75 ] } } } }- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
-
响应
{
"took": 14,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 3,
"relation": "eq"
},
"max_score": 0.26706278,
"hits": [
{
"_index": "nba",
"_type": "_doc",
"_id": "l4cuG38B4RxnBaUYPdnZ",
"_score": 0.26706278,
"_source": {
"name": "库里",
"team_name": "勇士",
"position": "组织后卫",
"play_year": "10",
"jerse_no": 30
}
},
{
"_index": "nba",
"_type": "_doc",
"_id": "mIcuG38B4RxnBaUYWNko",
"_score": 0.26706278,
"_source": {
"name": "库里",
"team_name": "勇士",
"position": "组织后卫",
"play_year": "10",
"jerse_no": 23
}
},
{
"_index": "nba",
"_type": "_doc",
"_id": "mYcuG38B4RxnBaUYadlM",
"_score": 0.26706278,
"_source": {
"name": "库里",
"team_name": "勇士",
"position": "组织后卫",
"play_year": "10",
"jerse_no": 35
}
}
]
},
"aggregations": {
"percentJerse": {
"values": {
"1.0": 22.999999999999996,
"5.0": 23.0,
"25.0": 24.75,
"50.0": 30.0,
"75.0": 33.75,
"95.0": 35.0,
"99.0": 35.0
}
}
}
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/我家小花儿/article/detail/774458
推荐阅读
相关标签
