ES聚合查询,折线图统计

ES版本
{
   
    "name": "node133-1",
    "cluster_name": "cluster_name",
    "cluster_uuid": "NHsCrgJ4SReF_i7uz1s9cw",
    "version": {
   
        "number": "6.2.1",
        "build_hash": "7299dc3",
        "build_date": "2018-02-07T19:34:26.990113Z",
        "build_snapshot": false,
        "lucene_version": "7.2.1",
        "minimum_wire_compatibility_version": "5.6.0",
        "minimum_index_compatibility_version": "5.0.0"
    },
    "tagline": "You Know, for Search"
}
需求一

查询数据时间在a-b间,且serviceId=1的数量折线图

{
   
  "size": 0,
  "query": {
   
    "bool": {
   
      "must": [
        {
   
          "range": {
   
            "startTime": {
   
              "gte": 1630857600000, 
              "lt": 1630943999000  
            }
          }
        },
        {
   
          "match": {
   
            "serviceId": "3b5a659a719d6a1353f71a20197f9c78"
          }
        }
      ]
    }
  },
  "aggs": {
   
    "agg_by_time": {
   
      "date_histogram": {
   
        "field": "startTime",
        "interval": "1m",
        "time_zone": "+08:00",
        "format": "yyyy-MM-dd HH:mm:ss",
        "min_doc_count": 0
      }
    }
  }
}

结果

{
   
    "took": 1,
    "timed_out": false,
    "_shards": {
   
        "total": 6,
        "successful": 6,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
   
        "total": 24,
        "max_score": 0.0,
        "hits": []
    },
    "aggregations": {
   
        "agg_by_time": {
   
            "buckets": [
                {
   
                    "key_as_string": "2021-09-06 16:45:00",
                    "key": 1630917900000,
                    "doc_count": 3
                },
                {
   
                    "key_as_string": "2021-09-06 16:46:00",
                    "key": 1630917960000,
                    "doc_count": 4
                },
                {
   
                    "key_as_string": "2021-09-06 16:47:00",
                    "key": 1630918020000,
                    "doc_count": 0
                },
                {
   
                    "key_as_string": "2021-09-06 16:48:00",
                    "key": 1630918080000,
                    "doc_count": 0
                },
                {
   
                    "key_as_string": "2021-09-06 16:49:00",
                    "key": 1630918140000,
                    "doc_count": 0
                },
                {
   
                    "key_as_string": "2021-09-06 16:50:00",
                    "key": 1630918200000,
                    "doc_count": 0
                },
                {
   
                    "key_as_string": "2021-09-06 16:51:00",
                    "key": 1630918260000,
                    "doc_count": 0
                },
                {
   
                    "key_as_string": "2021-09-06 16:52:00",
                    "key": 1630918320000,
                    "doc_count": 0
                },
                {
   
                    "key_as_string": "2021-09-06 16:53:00",
                    "key": 1630918380000,
                    "doc_count": 0
                },
                {
   
                    "key_as_string": "2021-09-06 16:54:00",
                    "key": 1630918440000,
                    "doc_count": 0
                },
                {
   
                    "key_as_string": "2021-09-06 16:55:00",
                    "key": 1630918500000,
                    "doc_count": 3
                },
                {
   
                    "key_as_string": "2021-09-06 16:56:00",
                    "key": 1630918560000,
                    
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值