ElasticSearch6.x 基于SpringBoot 实现ElasticSearch之分组统计查询

最新推荐文章于 2024-11-08 18:12:22 发布

原创最新推荐文章于 2024-11-08 18:12:22 发布 · 5.3k 阅读

6 ·

CC 4.0 BY-SA版权

elasticsearch 学习笔记专栏收录该内容

53 篇文章

订阅专栏

本文深入解析了Elasticsearch中的各种聚合查询方法，包括分组统计、过滤器统计、多过滤器统计、区间统计、日期区间统计及Missing统计。通过具体代码示例，详细介绍了如何使用AggregationBuilders进行不同类型的聚合操作，为用户提供全面的数据分析视角。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

AggregationUtil.java中添加如下方法，

 /**
	     * 分组统计
	     * @param index 索引
	     * @param field 文档属性
	     * @return
	     */
	    public Terms terms(String index,String field){
	    	String name = "terms";
	        AggregationBuilder agg=AggregationBuilders.terms(name).field(field);
	        SearchResponse response=client.prepareSearch(index).addAggregation(agg).execute().actionGet();
	        return response.getAggregations().get(name);
	    }
	    
	    /**
	     * 过滤器统计
	     * @param index 索引
	     * @param field 文档属性
	     * @return
	     */
	    public Filter filter(String index, String field, String key){
	        QueryBuilder query=QueryBuilders.termQuery(field,key);
	        String name ="filter";
	        AggregationBuilder agg=AggregationBuilders.filter(name,query);
	        SearchResponse response=client.prepareSearch(index).addAggregation(agg).execute().actionGet();
	        return response.getAggregations().get(name);
	    }
	    
	    /**
	     * 多过滤器统计
	     * @param index 索引
	     * @param list  过滤条件队列
	     * @return
	     */
	    public Filters filters(String index, List<TermQueryBuilder> list){
	    	String name = "filters";
	    	
	    	FiltersAggregator.KeyedFilter[] filters = new FiltersAggregator.KeyedFilter[list.size()];
	    	for(int i=0; i <list.size(); i++){
	    		TermQueryBuilder obj = list.get(i);
	    		FiltersAggregator.KeyedFilter item = new FiltersAggregator.KeyedFilter(obj.fieldName(),obj);
	    		filters[i] = item;
	    	}
	    	
	        AggregationBuilder agg=AggregationBuilders.filters(name, filters);
	        SearchResponse response=client.prepareSearch(index).addAggregation(agg).execute().actionGet();
	        return response.getAggregations().get(name);
	    }
	    
	    /**
	     * 区间统计
	     * @param index 索引
	     * @param field 文档属性
	     * @return
	     */
	    public Range range(String index, String field, double to, double from){
	    	String name ="range";
	        AggregationBuilder agg=AggregationBuilders
	                .range(name)
	                .field(field)
	                .addUnboundedTo(to)//第1个范围 ( ,to)
	                .addRange(to,from)//第2个范围[to,from)
	                .addUnboundedFrom(from);//第3个范围[from,)
	        SearchResponse response=client.prepareSearch(index).addAggregation(agg).execute().actionGet();
	        return response.getAggregations().get(name);
	    }

	

	    /**
	     * 日期区间统计
	     * @param index 索引
	     * @param field 文档属性
	     * @return
	     */
	    public Range dateRange(String index, String field,String to,String from, String formated){
	    	String name ="dateRange";
	        AggregationBuilder agg=AggregationBuilders
	                .dateRange(name)
	                .field(field)
	                .format(formated)
	                .addUnboundedTo(to)
	                .addUnboundedFrom(from);
	        SearchResponse response=client.prepareSearch(index).addAggregation(agg).execute().actionGet();
	        return response.getAggregations().get(name);
	    }
	    
	    /**
	     * Missing统计
	     * @param field
	     * @return
	     */
	    public Missing missing(String index, String field){
	    	String name ="missing";
	        AggregationBuilder agg=AggregationBuilders.missing(name).field(field);
	        SearchResponse response=client.prepareSearch(index).addAggregation(agg).execute().actionGet();
	        return response.getAggregations().get(name);
	    }