GET ana-apk/_search
{
"query": {
"match_all": {}
}
}
GET ana-apk/_search #查询不重复的mac地址
{
"size": 10,
"aggs": {
"MAC": {
"cardinality": {
"field": "MAC.keyword"
}
}
},
"_source":{
"include":["MAC","ProbeOUI","RTPLossRate"]
}
}
GET ana-apk/_search #计算RTPLossRate的平均值
{
"size": 0,
"aggs": {
"avg_RTPLossRate": {
"avg": {
"field": "RTPLossRate"
}
}
}
}
GET ana-apk/_search #查询RTPLossRate小于0的值
{
"size": 10,
"query": {
"range": {
"RTPLossRate": {
"lt": 0
}
}
},
"_source":{
"include":["MAC","ProbeOUI","RTPLossRate","message"]
}
}
GET ana-apk/_search #查询RTPLossRate大于等于0小于等于1000的值
{
"size": 10,
"query": {
"range": {
"RTPLossRate": {
"gte": 0,
"lte": 1000
}
}
},
"aggs": {
"avg_RTPLossRate": {
"avg": {
"field": "RTPLossRate"
}
}
}
}
GET ana-apk/_search #查询RTPLossRate在0到1000之间的数据,并输出字段为OUI的10个值
{
"size": 0,
"query": {
"range": {
"RTPLossRate": {
"gte": 0,
"lte": 1000
}
}
es查询,聚合、平均值、值范围、cardinality去重查询
最新推荐文章于 2024-06-17 16:55:24 发布