ES聚合查询，折线图统计

原创

已于 2022-07-05 10:35:34 修改 · 1.1k 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#elasticsearch #聚合查询 #折线图 #柱状图 #java实现

于 2021-09-07 14:59:05 首次发布

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,
                    "doc_count": 3
                },
                {

最低0.47元/天解锁文章