【大数据】elasticsearch聚合查询

杰肥啊

已于 2022-07-22 09:47:29 修改

阅读量1k

点赞数 1

分类专栏：大数据文章标签： elasticsearch es

于 2021-03-30 17:39:31 首次发布

本文链接：https://blog.csdn.net/javaboyweng/article/details/115331489

版权

大数据专栏收录该内容

6 篇文章 2 订阅

订阅专栏

本文详细介绍了如何使用Elasticsearch进行聚合查询，包括查看每个年龄段的分布、整体平均薪资以及每个年龄段的平均薪资，并提供了相应的Java客户端代码示例。通过对`age`字段的术语聚合和`balance`字段的平均值聚合，实现了数据的深度分析。

摘要由CSDN通过智能技术生成

关于elasticsearch聚合查询

命令如下

#查看每个年龄段的分布情况
GET bank/_search
{
  "aggregations": {
    "ageAgg": {
      "terms": {
        "field": "age", 
        "size": 10
      }
    }
  }
}

#查看每个年龄段的分布情况。 查看整体的平均工资
GET bank/_search
{
  "aggregations": {
    "ageAgg": {
      "terms": {
        "field": "age", 
        "size": 10,
        "min_doc_count": 1,
        "shard_min_doc_count": 0,
        "show_term_doc_count_error": false,
        "order": [
          {
            "_count": "desc"
          },
          {
            "_key": "asc"
          }
        ]
      }
    },
    "balanceAvg":{
      "avg": {
        "field": "balance"
      }
    }
  }
}

#聚合中的聚合 查看每个年龄段的平均薪资
GET bank/_search
{
  "aggs": {
    "ageAgg": {
      "terms": {
        "field": "age",
        "size": 10
      },
      "aggs": {
        "balanceAvg": {
          "avg": {
            "field": "balance"
          }
        }
      }
    }
  }
}

Java客户端代码如下

@SpringBootTest
public class AggregationsTest {

    private String indexName = "bank";

    @Autowired
    RestHighLevelClient restHighLevelClient;

    /**
     * term聚合 查看每个年龄段的分布情况
     */
    @Test
    public void test1() throws IOException {
        String ageAggName = "ageAgg";
        SearchRequest searchRequest = new SearchRequest();
        searchRequest.indices(indexName);
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        TermsAggregationBuilder termsBuilder = AggregationBuilders.terms(ageAggName).field("age");
        searchSourceBuilder.aggregation(termsBuilder);
        System.out.println("输出查询参数:"+searchSourceBuilder.toString());
        searchRequest.source(searchSourceBuilder);
        SearchResponse searchResponse = restHighLevelClient.search(searchRequest, RequestOptions.DEFAULT);
        Terms term = searchResponse.getAggregations().get(ageAggName);
        for (Terms.Bucket bucket : term.getBuckets()) {
            System.out.println("文档的key:"+bucket.getKeyAsString());
            System.out.println("文档的值:"+bucket.getDocCount());
        }
    }

    /**
     * avg 平均聚合 查看整体的平均薪资
     * @throws IOException
     */
    @Test
    public void test2() throws IOException {
        String ageAggName = "ageAgg";
        String balanceAvgName = "balanceAvg";
        SearchRequest searchRequest = new SearchRequest();
        searchRequest.indices(indexName);
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        searchSourceBuilder.aggregation(AggregationBuilders.terms(ageAggName).field("age"));
        searchSourceBuilder.aggregation(AggregationBuilders.avg(balanceAvgName).field("balance"));
        searchRequest.source(searchSourceBuilder);
        SearchResponse searchResponse = restHighLevelClient.search(searchRequest, RequestOptions.DEFAULT);
        Terms terms = searchResponse.getAggregations().get(ageAggName);
        if (terms != null) {
            for (Terms.Bucket bucket : terms.getBuckets()) {
                System.out.println("文档的key:"+bucket.getKeyAsString());
                System.out.println("文档的值:"+bucket.getDocCount());
            }
        }

        //查询整体平均薪资
        Avg balanceAvg = searchResponse.getAggregations().get(balanceAvgName);
        if (balanceAvg != null) {
            System.out.println("平均薪资:"+balanceAvg.getValue());
        }
    }

    /**
     * 聚合中的聚合 查看每个年龄段的平均薪资
     */
    @Test
    public void test3() throws IOException {
        String ageAggName = "ageAgg";
        String balanceAvgName = "balanceAvg";
        SearchRequest searchRequest = new SearchRequest(indexName);
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        searchSourceBuilder.aggregation(AggregationBuilders.terms(ageAggName).field("age").subAggregation(AggregationBuilders.avg(balanceAvgName).field("balance")));
        searchRequest.source(searchSourceBuilder);
        SearchResponse search = restHighLevelClient.search(searchRequest, RequestOptions.DEFAULT);
        Terms terms = search.getAggregations().get(ageAggName);
        if (terms != null) {
            for (Terms.Bucket bucket : terms.getBuckets()) {
                System.out.println("文档的key:"+bucket.getKeyAsString()+"-----"+"文档的值:"+bucket.getDocCount());
                Avg balanceAvg = bucket.getAggregations().get(balanceAvgName);
                System.out.println("平均薪资:"+balanceAvg.getValue());
            }
        }
    }
}