elasticSearch多字段聚合查询示例【基于java api】

原创

已于 2024-11-25 15:40:33 修改 · 1.5k 阅读

12 ·

CC 4.0 BY-SA版权

文章标签：

#java #elasticsearch #开发语言

于 2024-01-09 18:13:08 首次发布

一、使用环境

jdk:1.8

es:7.15.2

背景：实现类似select count(*),name,age from table_name group by name,age功能

二、查询代码：

使用Terms聚合查询,示例代码如下：

public  static Map<String,Map<String,Long>> groupByFields(String index, QueryBuilder query, String... fieldNames) throws IOException {
   
   
       SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
       TermsAggregationBuilder aggregationBuilder=null;
       for(String fieldName: fieldNames) {
   
   
           if(aggregationBuilder == null) {
   
   
               aggregationBuilder =  AggregationBuilders.terms(fieldName)
                       .field(fieldName);
           }else {
   
   
               aggregationBuilder.subAggregation(AggregationBuilders.terms(fieldName)