GET /user_request_record/_search
{
"size": 1,
"query": {
"match_all": {}
},
"aggs": {
"recordCount":{
"value_count": {
"field": "userId"
}
},
"distinctUserId": {
"cardinality": {
"field": "userId"
}
},
"groupByUserId": {
"terms": {
"field": "userId",
"size": 100
},
"aggs": {
"countBetween": {
"bucket_selector": {
"buckets_path": {
"view_count": "_count"
},
"script": "params.view_count >5000"
}
}
}
},
"sumGroupByUserId": {
"sum_bucket": {
"buckets_path": "groupByUserId>_count"
}
},
"filterByUserId": {
"filter": {
"term": {
"userId": "4"
}
},
"aggs": {
"filterByMethod": {
"filters": {
"filters": {
"GETmethod": {
"term": {
"method": "GET"
}
},
"POSTmethod": {
"term": {
"method": "POST"
}
}
}
}
},
"groupByMethod": {
"terms": {
"field": "method",
"size": 10
},
"aggs": {
"filterByDate": {
"filter": {
"range": {
"requestTime": {
"gte": "2021-02-22 15:14:05",
"lte": "2021-02-22 15:14:05"
}
}
}
}
}
}
}
}
}
}
返回结果大概如下,
{
"took" : 39,
"timed_out" : false,
"_shards" : {
"total" : 120,
"successful" : 120,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : 59832,
"max_score" : 0.0,
"hits" : [ ]
},
"aggregations" : {
"groupByUserId" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : 4,
"doc_count" : 17560
},
{
"key" : 15,
"doc_count" : 9565
},
{
"key" : 5,
"doc_count" : 8614
}
]
},
"filterByUserId" : {
"meta" : { },
"doc_count" : 17560,
"filterByMethod" : {
"buckets" : {
"GETmethod" : {
"doc_count" : 2803
},
"POSTmethod" : {
"doc_count" : 14757
}
}
},
"groupByMethod" : {
"meta" : { },
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "POST",
"doc_count" : 14757,
"filterByDate" : {
"doc_count" : 0
}
},
{
"key" : "GET",
"doc_count" : 2803,
"filterByDate" : {
"doc_count" : 1
}
}
]
}
},
"recordCount" : {
"value" : 59832
},
"distinctUserId" : {
"value" : 24
},
"sumGroupByUserId" : {
"value" : 35739.0
}
}
}