ES 两次group by,先按照每天的时间力度，在统计每天的指定字段的值出现的次数

原创

于 2023-10-11 10:35:39 发布 · 366 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#es

文章介绍了如何在Elasticsearch中使用DateHistogram聚合器按天对数据进行分组，并获取agg_tw_id字段的子聚合结果。

    public void addPubtimeAgg(){

        DateHistogramBuilder dateHistogramBuilder = AggregationBuilders.dateHistogram("pubtime_histogram")
                .field("pubtime").interval(DateHistogram.Interval.days(1))
                .minDocCount(0L);
        dateHistogramBuilder.format("yyyy-MM-dd");

        TermsBuilder field = AggregationBuilders.terms("agg_tw_id").field("tw_id").size(30);
        dateHistogramBuilder.subAggregation(field);

        searchbuilder.addAggregation(dateHistogramBuilder);
        if (this.query != null) {
            this.searchbuilder.setQuery(this.query);
        }
        SearchResponse sr = searchbuilder.execute().actionGet();

        Map<String, Aggregation> aggMap = sr.getAggregations().asMap();
        DateHistogram classTerms = (DateHistogram)aggMap.get("pubtime_histogram");
        Iterator<org.elasticsearch.search.aggregations.bucket.histogram.DateHistogram.Bucket> classBucketIt = (Iterator<Bucket>) cla