es 聚合dls

最新推荐文章于 2024-01-10 17:14:39 发布

确定过眼神！

最新推荐文章于 2024-01-10 17:14:39 发布

阅读量1k

点赞数

分类专栏： java 文章标签： elasticsearch 大数据 big data

本文链接：https://blog.csdn.net/qq_33684240/article/details/122940829

版权

java 专栏收录该内容

34 篇文章 1 订阅

订阅专栏

最近做微服务监控系统,用到es,自己做定制的查询api,发现需要dls语言,
下面给个示例给xdm做个参考.

首先根据给定字段过滤空的空字段记录,然后根据组合字段过滤掉重复的记录,最后选择需要显示的字段
使用时要去掉注释

GET monitorapi-2022.02/_search
{"query": {//先过滤有空的记录
  "bool": {
    "must": [
      {
        "script": {
          "script": {
          "lang": "painless",   
          "source": "doc['modelName.keyword'].size()*doc['clazzName.keyword'].size()*doc['methodName.keyword'].size()*doc['hostname.keyword'].size()>0"
          } 
          
        }
      }
  ]
  }
}, 
	"aggs": {
	  "my":{
	    "terms":{//组合字段，过滤重复的记录
	      "script": "doc['modelName.keyword'].value+'#'+doc['clazzName.keyword'].value+'#'+doc['methodName.keyword'].value+'#'+doc['hostname.keyword'].value"
	    },
	    "aggs":{//展示需要的字段
	      "my_top_hits":{
	        "top_hits":{
            "_source": {
              "includes": [
                "modelName",
                "hostname", 
                "clazzName",
                "clazzInfo", 
                "methodName",
                "methodInfo"
              ]
            },
	          "size":1
	        }
	      }
	    }
	  }
	}
}

java 代码实现

        String[] indexNames = "monitorapi-*".split(",");
        SearchRequest request = new SearchRequest(indexNames);
        SearchSourceBuilder builder = new SearchSourceBuilder();
        BoolQueryBuilder boolQueryBuilder = new BoolQueryBuilder();
        ScriptQueryBuilder scriptQueryBuilder = new ScriptQueryBuilder(Script.parse("doc['modelName.keyword'].size()*doc['clazzName.keyword'].size()*doc['methodName.keyword'].size()*doc['hostname.keyword'].size()>0"));
        boolQueryBuilder.must(scriptQueryBuilder);
        builder.query(boolQueryBuilder);
        TermsAggregationBuilder termsSourceTypeSourcePlaceGroup = AggregationBuilders.terms("my")
                .script(Script.parse("doc['modelName.keyword'].value+'#'+doc['clazzName.keyword'].value+'#'+doc['methodName.keyword'].value+'#'+doc['hostname.keyword'].value"));
        String[] arr = {"modelName", "hostname", "clazzName", "clazzInfo", "methodName", "methodInfo"};
        String[] strings = new String[6];
        TopHitsAggregationBuilder topHitsAggregationBuilder = AggregationBuilders.topHits("myTopHits")
                .fetchSource(arr,null).size(1);
        TermsAggregationBuilder aggregationBuilder = termsSourceTypeSourcePlaceGroup.subAggregation(topHitsAggregationBuilder);
        builder.aggregation(aggregationBuilder);
        request.source(builder);