#聚合查询
#总和
GET /lib2/item/_search
{
"size": 0,
"aggs": {
"price_of_sum":{
"sum": {
"field": "price"
}
}
}
}
#最小值
GET /lib2/item/_search
{
"size": 0,
"aggs": {
"price_of_sum":{
"min": {
"field": "price"
}
}
}
}
#平均值
GET /lib2/item/_search
{
"size": 0,
"aggs": {
"price_of_sum":{
"avg": {
"field": "price"
}
}
}
}
#求基数
#求某个属性有多少个不同的值
GET /lib2/item/_search
{
"size": 0,
"aggs": {
"price_of_sum":{
"cardinality": {
"field": "price"
}
}
}
}
#分组
GET /lib2/item/_search
{
"size": 0,
"aggs": {
"price_of_group":{
"terms": {
"field": "price"
}
}
}
}
#查询兴趣为唱歌的按年龄进行分组,分组求平均值,降序排序
GET /lib/user/_search
{
"size": 0,
"query": {
"match": {
"interests": "song"
}
},
"aggs": {
"age_of_group":{
"terms": {
"field": "age",
"order": {
"age_of_avg":"desc"
}
},
"aggs": {
"age_of_avg":{
"avg": {
"field": "age"
}
}
}
}
}
}