聚合
功能
- 聚合提供了對(duì)數(shù)據(jù)進(jìn)行組合和提取統(tǒng)計(jì)結(jié)果的能力坛悉。
- 同一個(gè)返回中可以分別返回hits結(jié)果和聚合結(jié)果
例子
-
GET /bank/_search
{
"size": 0,
"aggs": { //聚合
"group_by_state": { //聚合名字
"terms": {
"field": "state.keyword", //按照state.keyword字段聚合
"order": { //排序
"average_balance": "desc" //按照average_balance倒序排序
}
},
"aggs": { //聚合
"average_balance": { //聚合名字
"avg": { //平均值
"field": "balance" //計(jì)算balance字段的平均值
}
}
}
}
}
}
-
GET /bank/_search
{
"size": 0,
"aggs": {
"group_by_age": { //通過(guò)age分組
"range": {
"field": "age", //按照age字段
"ranges": [ //年齡分段范圍
{
"from": 20,
"to": 30
},
{
"from": 30,
"to": 40
},
{
"from": 40,
"to": 50
}
]
},
"aggs": {
"group_by_gender": { //按照gender聚合
"terms": {
"field": "gender.keyword"
},
"aggs": {
"average_balance": { //按照balance聚合
"avg": {
"field": "balance"
}
}
}
}
}
}
}
}
