es聚合分组

两个条件聚合分组:例如统计国家下的所有级别的数量

 public void selectGroupBy() throws IOException {
        SearchRequest searchRequest = new SearchRequest("my_index_v1").types("_doc");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder().size(0);
        searchSourceBuilder.query(QueryBuilders.matchAllQuery());
        TermsAggregationBuilder aggregation = AggregationBuilders.terms("group_by_x").field("x");
        TermsAggregationBuilder aggregation2 = AggregationBuilders.terms("group_by_z").field("z");
        searchSourceBuilder.aggregation(aggregation.subAggregation(aggregation2));
        searchRequest.source(searchSourceBuilder);
        SearchResponse searchResponse = restHighLevelClient.search(searchRequest, RequestOptions.DEFAULT);
        Terms terms = searchResponse.getAggregations().get("group_by_x");
        List<? extends Terms.Bucket> buckets = terms.getBuckets();
        for (Terms.Bucket bucket : buckets) {
            String id = bucket.getKey().toString();//id
            Long docCount = bucket.getDocCount();//数量
            System.out.println("==" + id + "------" + docCount);
            Terms terms2 =  bucket.getAggregations().get("group_by_z");
            for (Terms.Bucket t2 : terms2.getBuckets()) {
                String id2 = t2.getKey().toString();//id
                Long docCount2 = t2.getDocCount();//数量
                System.out.println("==" + id2 + "------" + docCount2);
            }
        }
    }

对多个field求max/min/sum/avg:例如统计国家下的某个属性的max,min,sum,avg

public void selectGroupByMax() throws IOException {
        SearchRequest searchRequest = new SearchRequest("my_index_v1").types("_doc");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder().size(0);
        searchSourceBuilder.query(QueryBuilders.matchAllQuery());
        TermsAggregationBuilder aggregation = AggregationBuilders.terms("group_by_x").field("x");
        //AggregationBuilder aggregation2 = AggregationBuilders.sum("sum_z").field("z");
       // AggregationBuilder aggregation2 = AggregationBuilders.max("max_z").field("z");
      //  AggregationBuilder aggregation2 = AggregationBuilders.min("min_z").field("z");
        AggregationBuilder aggregation2 = AggregationBuilders.avg("avg_z").field("z");
        searchSourceBuilder.aggregation(aggregation.subAggregation(aggregation2));
        searchRequest.source(searchSourceBuilder);
        SearchResponse searchResponse = restHighLevelClient.search(searchRequest, RequestOptions.DEFAULT);
        Terms terms = searchResponse.getAggregations().get("group_by_x");
        List<? extends Terms.Bucket> buckets = terms.getBuckets();
        for (Terms.Bucket bucket : buckets) {
            String id = bucket.getKey().toString();//id
            Long docCount = bucket.getDocCount();//数量
            System.out.println("==" + id + "------" + docCount);
            Aggregations aggregations = bucket.getAggregations();
            List<Aggregation> aggregations1 = aggregations.asList();
            for (Aggregation agg:aggregations1){
              //  System.out.println("====" + agg.getName() + "------" + ((ParsedSum) agg).value());
              //  System.out.println("====" + agg.getName() + "------" + ((ParsedMax) agg).value());
              //  System.out.println("====" + agg.getName() + "------" + ((ParsedMin) agg).value());
                System.out.println("====" + agg.getName() + "------" + ((ParsedAvg) agg).value());
            }
        }
    }

借鉴于:https://www.cnblogs.com/chenyuanbo/p/9973311.html

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值