ES常用聚合查询

最新推荐文章于 2022-08-17 10:57:15 发布

无名小卒菜

最新推荐文章于 2022-08-17 10:57:15 发布

阅读量237

点赞数

分类专栏： ES 文章标签： elasticsearch

本文链接：https://blog.csdn.net/weixin_39428938/article/details/121404051

版权

ES 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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
    }
  }
}