ElasticSearch按时间聚合统计

查询语句，统计每天的浏览量

--聚合条件为

方式一

DateHistogramAggregationBuilder dateHistogramAgg = AggregationBuilders.dateHistogram("groupDate").field("create_time")
 .dateHistogramInterval(DateHistogramInterval.DAY).offset("-8h").minDocCount(0);

方式二

DateHistogramAggregationBuilder dateHistogramAgg = AggregationBuilders
.dateHistogram("groupDate")
.field("update_time")
.dateHistogramInterval(DateHistogramInterval.DAY)
.timeZone(DateTimeZone.forTimeZone(TimeZone.getTimeZone("Asia/Chongqing")))
.format("yyyy-MM-dd").minDocCount(0);

为什么offset("-8h")，经排查发现es在做时区聚合时，自身不是东八区时间（中国时间），需要offset属性减去8小时。根据es的时间格式选择方式二

返回结果处理 下面是api的应用

 List<Point> result = new ArrayList<>();
        SearchSourceBuilder builder = QueryBuilder.buildGroup(stockContion);
        DateHistogramAggregationBuilder dateHistogramAggregationBuilder = AggregationBuilders.dateHistogram("groupDate").field("update_time")
                .dateHistogramInterval(DateHistogramInterval.DAY).offset("-8h").format("yyyy-MM-dd").minDocCount(0);
        dateHistogramAggregationBuilder.subAggregation(AggregationBuilders.sum("totalQty").field("total_sku_qty"));
        builder.aggregation(dateHistogramAggregationBuilder);
        builder.size(0);      
        SearchResponse sr = esQueryService.queryByIndexAndSourceBuilder(index, type, builder);      
        Map<String, Aggregation> aggMap = sr.getAggregations().getAsMap();
        ParsedDateHistogram terms = (ParsedDateHistogram) aggMap.get("groupDate");
        for (Histogram.Bucket entry : terms.getBuckets()) {
            Point point = new Point();
            point.setXName(entry.getKeyAsString());
            if (entry.getAggregations().get("totalQty") != null) {
                ParsedSum sum = entry.getAggregations().get("totalQty");
                point.setYValue(ReportUtils.double2BigDecimal(sum.getValue(), 2).toString());
            }
            result.add(point);
        }
        return result;

结果展示

{
  "took" : 84,
  "timed_out" : false,
  "_shards" : {
    "total" : 5,
    "successful" : 5,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : 223501,
    "max_score" : 0.0,
    "hits" : [ ]
  },
  "aggregations" : {
    "groupDate" : {
      "buckets" : [
        {
          "key_as_string" : "2020-02-17",
          "key" : 1581897600000,
          "doc_count" : 168,
          "totalQty" : {
            "value" : 3108.0
          }
        },
        {
          "key_as_string" : "2020-02-18",
          "key" : 1581984000000,
          "doc_count" : 840,
          "totalQty" : {
            "value" : 383124.0
          }
        },
        {
          "key_as_string" : "2020-02-19",
          "key" : 1582070400000,
          "doc_count" : 168,
          "totalQty" : {
            "value" : 1680.0
          }
        },
        {
          "key_as_string" : "2020-02-20",
          "key" : 1582156800000,
          "doc_count" : 0,
          "totalQty" : {
            "value" : 0.0
          }
        },
        {
          "key_as_string" : "2020-02-21",
          "key" : 1582243200000,
          "doc_count" : 0,
          "totalQty" : {
            "value" : 0.0
          }
        },
        {
          "key_as_string" : "2020-02-22",
          "key" : 1582329600000,
          "doc_count" : 0,
          "totalQty" : {
            "value" : 0.0
          }
        },
        {
          "key_as_string" : "2020-02-23",
          "key" : 1582416000000,
          "doc_count" : 0,
          "totalQty" : {
            "value" : 0.0
          }
        },
        {
          "key_as_string" : "2020-02-24",
          "key" : 1582502400000,
          "doc_count" : 3192,
          "totalQty" : {
            "value" : 26763.0
          }
        },
        {
          "key_as_string" : "2020-02-25",
          "key" : 1582588800000,
          "doc_count" : 3864,
          "totalQty" : {
            "value" : 25116.0
          }       
         }
        }
      ]
    }
  }
}