es7.1聚合查询 javaAPI(二)
按时间聚合
select DATE_FORMAT(date,"yyyy-MM-dd") as dates,count(1) as count from myIndex
where date between '2020-07-01 00:00:00' and '2020-07-10 00:00:00' group by dates;
DateHistogramAggregationBuilder days = AggregationBuilders.dateHistogram("day").field("date").timeZone(ZoneId.of("Asia/Shanghai")).dateHistogramInterval(DateHistogramInterval.DAY);
ps:
- es非常适合小量数据的精准查询, 查询大量数据或聚合查询往往会占用更多的资源。
- 根据测试,聚合平均每天4万数据量的数据能保持效率
- 如果每天的数据量远远高于4万,建议循环时间去多次请求
public void query1(){
RestHighLevelClient client = getClient();
QueryBuilder qBuilder = QueryBuilders.boolQuery()
.must(QueryBuilders.rangeQuery(esIndex_time)
.from(Util.date("2020-07-01 00:00:00"))
.to(Util.date("2020-07-10 00:00:00")))