一区二区三区在线-一区二区三区亚洲视频-一区二区三区亚洲-一区二区三区午夜-一区二区三区四区在线视频-一区二区三区四区在线免费观看

服務器之家:專注于服務器技術及軟件下載分享
分類導航

PHP教程|ASP.NET教程|Java教程|ASP教程|編程技術|正則表達式|C/C++|IOS|C#|Swift|Android|VB|R語言|JavaScript|易語言|vb.net|

服務器之家 - 編程語言 - Java教程 - ES結合java代碼聚合查詢詳細示例

ES結合java代碼聚合查詢詳細示例

2023-05-08 01:02未知服務器之家 Java教程

思路不清晰的小伙伴可以先在es中把聚合代碼寫出來 { "aggs": { "brandAgg": { "terms": { "field": "brandName.keyword" }, "aggs": { "typeAgg": { "terms": { "field": "typeTwoName.keyword" } }, "ruleAgg": { "terms": { "field": "ruleName.keyword" }, "aggs": { "ruleValueAgg": { "terms":

思路不清晰的小伙伴可以先在es中把聚合代碼寫出來

 
{
  "aggs": {
    "brandAgg": {
      "terms": {
        "field": "brandName.keyword"
      },
      "aggs": {
        "typeAgg": {
        "terms": {
          "field": "typeTwoName.keyword"
        }
        },
        "ruleAgg": {
          "terms": {
            "field": "ruleName.keyword"
          },
            "aggs": {
                "ruleValueAgg": {
                  "terms": {
                    "field": "ruleAttrValue.keyword"
                  }
                }
              }
        }
      }
    }
  }

注:字段名稱加keyword是精準查詢,模糊查詢可以去掉

?查詢完成后這是聚合的結構

ES結合java代碼聚合查詢詳細示例

?在java代碼中先把要聚合的名稱創建出來

根據剛剛的es代碼設置java中的terms名稱和field后面的名稱相對應

//構建聚合名稱
TermsAggregationBuilder brandAgg = AggregationBuilders.terms("brandAgg").field("brandName.keyword");
TermsAggregationBuilder typeAgg = AggregationBuilders.terms("typeAgg").field("typeTwoName.keyword");
TermsAggregationBuilder ruleAgg = AggregationBuilders.terms("ruleAgg").field("ruleName.keyword");
TermsAggregationBuilder ruleValueAgg = AggregationBuilders.terms("ruleValueAgg").field("ruleAttrValue.keyword");

這里是根據es代碼中創建的層級關系來依次分配?

//根據聚合分配層級
brandAgg.subAggregation(typeAgg);
brandAgg.subAggregation(ruleAgg);
ruleAgg.subAggregation(ruleValueAgg);
//添加最外層聚合
searchSourceBuilder.aggregation(brandAgg);

創建實體類來接參

 
    /*=====================聚合分析=====================*/
    /**
     * 查詢到的所有商品所涉及的所有品牌
     */
    private Set<BrandVO> brands = new HashSet<>();
 
    /**
     * 查詢到的所有商品所涉及的所有分類
     */
    private Set<TypeVO> types = new HashSet<>();
 
    /**
     * 查詢到的所有商品所涉及的所有屬性(規格)
     */
    private Set<AttrVO> attrs = new HashSet<>();
 
    @Data
    public static class BrandVO {
        private Long brandId;
        private String brandName;
        private String brandImg;
    }
 
    @Data
    public static class TypeVO {
        private Long TypeId;
        private String TypeName;
    }
 
    @Data
    public static class AttrVO {
        private Long attrId;
        private String attrName;
        private List<String> attrValue;
    }
 
    @Data
    public static class BreadCrumbsVO {
        private String attrName;
        private String attrValue;
        private String link;
    }

在方法中把參數先備好

//定義參數
Set<SearchResult.BrandVO> brandVOList = new HashSet<>();
Set<SearchResult.TypeVO> typeList = new HashSet<>();
Set<SearchResult.AttrVO> attrList = new HashSet<>();

首先獲取最外層的參數

有一點需要更改的 回調參數是Aggregations需要改成Terms才能調取方法

//獲取聚合參數
Aggregations brandAggregations = response.getAggregations();
//獲取品牌
Terms brandGations = brandAggregations.get("brandAgg");

循環獲取參數添加到指定的集合當中,這個獲取的就相當于是es當中key的值

for (Terms.Bucket bucket : brandGations.getBuckets()) {
//添加品牌
SearchResult.BrandVO brandVO = new SearchResult.BrandVO();
brandVO.setBrandName(bucket.getKeyAsString());
brandVOList.add(brandVO);
}

ES結合java代碼聚合查詢詳細示例

ES結合java代碼聚合查詢詳細示例

?最后在添加到實體類的對象當中

//添加對象中數據
result.getProductInfoList().addAll(productInfoList);
result.getBrands().addAll(brandVOList);
result.getAttrs().addAll(attrList);
result.getTypes().addAll(typeList);

最后查詢,就獲取到了我們聚合后的值了,在根據業務進行下一步的操作

最后展示一下所有的代碼

SearchResult result = new SearchResult();
try {
    //構建對象
    SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    //構建聚合名稱
    TermsAggregationBuilder brandAgg = AggregationBuilders.terms("brandAgg").field("brandName.keyword");
    TermsAggregationBuilder typeAgg = AggregationBuilders.terms("typeAgg").field("typeTwoName.keyword");
    TermsAggregationBuilder ruleAgg = AggregationBuilders.terms("ruleAgg").field("ruleName.keyword");
    TermsAggregationBuilder ruleValueAgg = AggregationBuilders.terms("ruleValueAgg").field("ruleAttrValue.keyword");
    //根據聚合分配層級
    brandAgg.subAggregation(typeAgg);
    brandAgg.subAggregation(ruleAgg);
    ruleAgg.subAggregation(ruleValueAgg);
    //添加最外層聚合
    searchSourceBuilder.aggregation(brandAgg);
    //定義參數
    Set<SearchResult.BrandVO> brandVOList = new HashSet<>();
    Set<SearchResult.TypeVO> typeList = new HashSet<>();
    Set<SearchResult.AttrVO> attrList = new HashSet<>();
    //獲取聚合參數
    Aggregations brandAggregations = response.getAggregations();
    //獲取品牌
    Terms brandGations = brandAggregations.get("brandAgg");
    for (Terms.Bucket bucket : brandGations.getBuckets()) {
        //添加品牌
        SearchResult.BrandVO brandVO = new SearchResult.BrandVO();
        brandVO.setBrandName(bucket.getKeyAsString());
        brandVOList.add(brandVO);
        //獲取類型
        Aggregations aggregations = bucket.getAggregations();
        Terms typeGations = aggregations.get("typeAgg");
        //添加類型
        for (Terms.Bucket typeGationsBucket : typeGations.getBuckets()) {
            SearchResult.TypeVO typeVO = new SearchResult.TypeVO();
            typeVO.setTypeName(typeGationsBucket.getKeyAsString());
            typeList.add(typeVO);
        }
        //獲取spu
        Terms ruleGations = aggregations.get("ruleAgg");
        //添加spu
        for (Terms.Bucket ruleGationsBucket : ruleGations.getBuckets()) {
            SearchResult.AttrVO attrVO = new SearchResult.AttrVO();
            attrVO.setAttrName(ruleGationsBucket.getKeyAsString());
            //獲取sku
            Aggregations attrValueAggregations = ruleGationsBucket.getAggregations();
            Terms ruleValueGations = attrValueAggregations.get("ruleValueAgg");
            //添加sku
            for (Terms.Bucket ruleValueGationsBucket : ruleValueGations.getBuckets()) {
                ArrayList<String> attrValueList = new ArrayList<>();
                for (String attrValue : ruleValueGationsBucket.getKeyAsString().split(",")) {
                    attrValueList.add(attrValue);
                }
                attrVO.setAttrValue(attrValueList);
            }
            attrList.add(attrVO);
        }
    }
        //添加對象中數據
        result.getProductInfoList().addAll(productInfoList);
        result.getBrands().addAll(brandVOList);
        result.getAttrs().addAll(attrList);
        result.getTypes().addAll(typeList);
    }
}catch (Exception ex){
    log.error("檢索ES失敗: {}", ex);
}

總結

原文地址:https://blog.csdn.net/qq_34160849/article/details/128120124

延伸 · 閱讀

精彩推薦
主站蜘蛛池模板: 欧美久久久久久久一区二区三区 | xxx88视频在线观看 | 好 舒服 好 粗 好硬免费视频 | 国产国语在线播放视频 | 精品免费久久久久久成人影院 | 四虎影视在线观看2413 | www在线观看视频免费 | 免费一级毛片在线播放放视频 | 无人在线高清免费看 | 小小水蜜桃3视频在线观看 小鸟酱喷水 | 99国产小视频 | 亚洲精品一 | 免费大片 | 国产欧美久久一区二区 | yellow在线| 日本免费在线播放 | 7mav视频 | 美式禁忌在线 | ts人妖另类国产 | 亚洲天堂影院在线观看 | 国产麻豆网 | 色网免费观看 | 青青草视频国产 | 99精品久久精品一区二区小说 | 国产一成人精品福利网站 | 国产日韩欧美在线观看不卡 | 久久久久久久久a免费 | 日韩精品亚洲专区在线影视 | 满溢游泳池免费土豪全集下拉版 | 3x3x3x短视频在线看 | 日本高清在线精品一区二区三区 | 帅老头恋帅老头同性tv | 91超级碰| 亚洲国产精品第一区二区三区 | 99精品久久精品一区二区 | www.青青操 | 国产精品午夜久久 | 国产成人在线播放 | 精品视频一区二区三区 | 国产成+人+综合+亚洲不卡 | 我与肥熟老妇的性事 |