Es Java多字段分组查询-Toy模板网

这篇具有很好参考价值的文章主要介绍了Es Java多字段分组查询。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

es按照多个字段分组查询

GET /你的索引/_search
{
	"size": 0,
	"aggregations": {
		"字段一的结果命名": {
			"terms": {
				"field": "startTime.keyword"
			},
			"aggregations": {
				"字段二的结果命名": {
					"terms": {
						"field": "aa.keyword"
					}
				}
			}
		}
	}
}

es分组查询,ES,java,elasticsearch,开发语言
java 代码实现：文章来源地址https://www.toymoban.com/news/detail-523746.html


    @Autowired
    private RestHighLevelClient client;
    
public Map<Object,List<Map<Object,Long>>> searchStationLineChart(String index,String stationId,String time) throws IOException {
        //搜索请求
        SearchRequest request = new SearchRequest(index);
        //请求条件构建器,这里和mybatis中的自定义查询有点类型
        SearchSourceBuilder builder = new SearchSourceBuilder();
        // 分组
        TermsAggregationBuilder oneBuilder = AggregationBuilders.terms("one").field("startTime.keyword");
        TermsAggregationBuilder twoBuilder = AggregationBuilders.terms("two").field("aa.keyword");
        oneBuilder.subAggregation(twoBuilder);
        builder.aggregation(oneBuilder);
        BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();

        //条件
        boolQueryBuilder.must(QueryBuilders.termsQuery("字段" + ".keyword","字段值"));

        builder.query(boolQueryBuilder);
        request.source(builder);
        //建立SearchResponse
        SearchResponse response;
        //从Spring中拿ES连接
        response = client.search(request, RequestOptions.DEFAULT);
        Map<Object,List<Map<Object,Long>>> returnMap = new HashMap<>(16);
        if (response.getAggregations() != null) {
            Terms oneTerm = (Terms) response.getAggregations().asMap().get("one");
            for (Terms.Bucket bucket : oneTerm.getBuckets()) {
                List<Map<Object,Long>> list = new ArrayList<>();
                System.out.println("one下面的" + bucket.getKey() + ", count是: " + bucket.getDocCount());
                Terms twoTerm = (Terms) bucket.getAggregations().asMap().get("two");
                for (Terms.Bucket twoTermBucket : twoTerm.getBuckets()) {
                    System.out.println("two下面的" + twoTermBucket.getKey() + ", count是: " + twoTermBucket.getDocCount());
                    Map<Object, Long> map = new HashMap<>(16);
                    map.put(twoTermBucket.getKey(),twoTermBucket.getDocCount());
                    list.add(map);
                }
                returnMap.put(bucket.getKey(),list);
            }
        }
         return returnMap;
    }