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

张声录1

已于 2024-11-25 15:40:33 修改

阅读量1.4k

点赞数 7

CC 4.0 BY-SA版权

文章标签： java elasticsearch 开发语言

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

本文链接：https://blog.csdn.net/zhangshenglu1/article/details/135486990

一、使用环境

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)