ES 聚合-先group 在sum

最新推荐文章于 2024-05-27 11:19:49 发布

colie_li

最新推荐文章于 2024-05-27 11:19:49 发布

阅读量9.4k

点赞数 1

分类专栏： elasticsearch

本文链接：https://blog.csdn.net/liyantianmin/article/details/65446991

版权

elasticsearch 专栏收录该内容

68 篇文章 0 订阅

订阅专栏

实现一个SQL: SELECT sum(field) from table group by field2

使用：AggregationBuilders.sum("name").field("field");

public static void searchTest() throws IOException {
        TermsBuilder companyNameAgg = AggregationBuilders.terms("companyName").field("companyName").size(10);
        SumBuilder companyNameAggSum = AggregationBuilders.sum("companyNameSum").field("cvcount");
        companyNameAgg.subAggregation(companyNameAggSum);//把sum聚合器放入到Term聚合器中，相当于先group by在sum
        SearchRequestBuilder searchBuilder = ElasticClientFactory.getClient().prepareSearch(indexname).setTypes(typeName).addAggregation(companyNameAgg);
        SearchResponse searchResponse = searchBuilder.execute().actionGet();
        Terms terms = searchResponse.getAggregations().get("companyName");
        List<Terms.Bucket> buckets = terms.getBuckets();
        List<String> list = Lists.newArrayList();
        for (Terms.Bucket bucket : buckets) {
            InternalSum internalSum = bucket.getAggregations().get("companyNameSum");//注意从bucket而不是searchResponse
            System.out.println(bucket.getKeyAsString() + "\t" + bucket.getDocCount() + "\t"+internalSum.getValue());
        }
        System.out.println("done");
    }