查询语句,统计每天的浏览量
--聚合条件为
方式一
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
}
}
}
]
}
}
}