搜索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"
}
}
}
}
}
}
