ElasticSearch多字段分组查询

最新推荐文章于 2024-08-16 11:00:41 发布

qq_775879106

最新推荐文章于 2024-08-16 11:00:41 发布

阅读量1.6k

点赞数 2

分类专栏： es聚合搜索

本文链接：https://blog.csdn.net/qq_36245532/article/details/118522787

版权

es聚合搜索专栏收录该内容

4 篇文章 0 订阅

订阅专栏


private String final SPLIT= ",";


public List<Option> errorCount() {
    List<Option> result = new ArrayList<Option>();
    SearchRequest searchRequest = new SearchRequest(INDEX_NAME);
    searchRequest.types(SEARCH_TYPE);
    SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();      
    TermsAggregationBuilder groupAgg = 
    buildTermsAggregationBuilder(Arrays.asList("user_no","user_name"), "agg_group");
    searchSourceBuilder.aggregation(groupAgg).size(0);
    searchRequest.source(searchSourceBuilder);
    SearchResponse sr = restHighLevelClient.search(searchRequest);
    Map<String, Aggregation> aggMap = sr.getAggregations().getAsMap();
    if (aggMap.containsKey("agg_group")) {
        ParsedStringTerms teams = (ParsedStringTerms) aggMap.get("agg_group");
        if (CollectionUtils.isNotEmpty(teams.getBuckets())) {
           for (Terms.Bucket bucket : teams.getBuckets()) {
                String key = bucket.getKey() == null ? "" : bucket.getKey().toString();
                if (StringUtils.isNotBlank(key) && !key.contains("null")) {
                     String[] split = StringUtils.split(key, SPLIT);
                     Option option = new Option();
                     option.setCode(split[0]);
                     option.setName(split[1]);
                     result.add(option);
                 }
             }
         }
     }
    return result;
}



private TermsAggregationBuilder buildTermsAggregationBuilder(List<String>     
      aggregationFields, String termsName) {
      String content = aggregationFields.stream().map(one ->          
      String.format("doc['%s'].value", one)).collect(Collectors.joining("+'" + SPLIT + 
      "'+"));
      TermsAggregationBuilder builder = AggregationBuilders.terms(termsName);
      builder.script(new Script(ScriptType.INLINE, "painless", content, new HashMap<>()));
      builder.size(Integer.MAX_VALUE);
      return builder;
}

es 查询语句

GET /index/type/_search
{
    "size":0,
    "query":{
        "bool":{
            "adjust_pure_negative":true,
            "boost":1
        }
    },
    "aggregations":{
        "agg_group":{
            "terms":{
                "script":{
                    "source":"doc['user_no'].value+','+doc['user_name'].value",
                    "lang":"painless"
                },
                "size":2147483647,              
                "order":[
                    {
                        "_count":"desc"
                    },
                    {
                        "_key":"asc"
                    }
                ]
            }
        }
    }
}