搜索address中包含mill的所有年龄分布和平均年龄
##搜索address中包含mill的所有年龄分布和平均年龄
GET bank/_search
{
"query":{
"match": {
"address":"mill"
}
},
"aggs": {
"ageAgg": {
"terms": {
"field": "age",
"size": 10
}
},
"ageAvg":{
"avg": {
"field": "age"
}
}
}
}
按年龄聚合，并且算出这些不同年龄分布的平均薪资
##按年龄聚合，并且算出这些不同年龄分布的平均薪资
GET bank/_search
{
"query": {
"match_all": {}
},
"aggs": {
"ageAgg": {
"terms": {
"field": "age",
"size": 100
},
"aggs": {
"balanceAvg": {
"avg": {
"field": "balance"
}
}
}
}
}
}
