devbox
繁依Fanyi0
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Elasticsearch 聚合函数返回空数组|查询返回空内容 rs里有数据

作者：繁依Fanyi0 | 2024-04-08 07:46:33

赞

踩

Elasticsearch 聚合函数返回空数组|查询返回空内容 rs里有数据

问题场景：

        今天用聚合函数想查询出catename不重复列表，类似于Mysql的group by函数。但返回的确是空数组[]，再三确认是有数据的。输出response：

{"took":1,"timed_out":false,"_shards":{"total":1,"successful":1,"skipped":0,"failed":0},"hits":{"total":{"value":360,"relation":"eq"},"max_score":1.0,"hits":[{"_index":"goods","_type":"_doc","_id":"552","_score":1.0,"_source":{"cateName":"狗罐头","createTime":1673165093,"description":"","fullTextSearch":"PRINTPAW宠物狗零食鸡肉绕花生饼干成犬幼犬全犬种通用训犬奖励磨牙棒 【实惠装】鸡肉绕花生饼干360g狗罐头PRINTPAW官方旗舰店","id":552,"image":"//img10.360buyimg.com/n7/jfs/t1/228575/36/11044/79383/65976d82Fb5f1b102/48af91d69659fa57.jpg","price":36.9,"shopName":"PRINTPAW官方旗舰店","stock":1000,"title":"PRINTPAW宠物狗零食鸡肉绕花生饼干成犬幼犬全犬种通用训犬奖励磨牙棒 【实惠装】鸡肉绕花生饼干360g","updateTime":1680094862,"views":0}},{"_index":"goods","_type":"_doc","_id":"584","_score":1.0,"_source":{"cateName":"狗罐头","createTime":1673165093,"description":"","fullTextSearch":"麦富迪 狗狗零食 成犬幼犬全犬种通用训犬奖励 蛋黄缠肉100g 混合口味 全阶段 国产狗罐头麦富迪官方旗舰店","id":584,"image":"//img11.360buyimg.com/n7/jfs/t1/227452/12/4395/157612/655efca3F444b9b85/06932f5d20c97662.jpg","price":15.0,"shopName":"麦富迪官方旗舰店","stock":1000,"title":"麦富迪 狗狗零食 成犬幼犬全犬种通用训犬奖励 蛋黄缠肉100g 混合口味 全阶段 国产","updateTime":1680094862,"views":0}},{"_index":"goods","_type":"_doc","_id":"614","_score":1.0,"_source":{"cateName":"钓竿","createTime":1673165093,"description":"","fullTextSearch":"爱心东东 2022新款轻奢美人鱼鱼竿6h 美人鱼钓鱼竿轻硬19调6H碳素鲤鱼竿5.4 6.3 7.2米鱼台钓竿 超硬19调6H5.4米+礼包 新人首单满200多件多折！关注小店，更有粉丝价钓竿宽逸旗舰店","id":614,"image":"//img10.360buyimg.com/n7/jfs/t1/186750/35/19688/469778/61236599E7ca37659/d6efab66c7a0ad87.jpg","price":278.0,"shopName":"宽逸旗舰店","stock":1000,"title":"爱心东东 2022新款轻奢美人鱼鱼竿6h 美人鱼钓鱼竿轻硬19调6H碳素鲤鱼竿5.4 6.3 7.2米鱼台钓竿 超硬19调6H5.4米+礼包 新人首单满200多件多折！关注小店，更有粉丝价","updateTime":1680094862,"views":0}},{"_index":"goods","_type":"_doc","_id":"604","_score":1.0,"_source":{"cateName":"钓竿","createTime":1673165093,"description":"","fullTextSearch":"特狼王鱼竿手竿4.5米5.4米6.3米7.2米钓鱼竿超轻超硬碳素台钓竿 4.5米杆稍+钩漂线 本产品为预售定制款，下单前请先联系客服咨询哦！钓竿汇斯盾彩泥店","id":604,"image":"//img10.360buyimg.com/n7/jfs/t1/139661/9/21538/211718/619f872bEed3fafb8/c5b4c0906e308c44.jpg","price":87.0,"shopName":"汇斯盾彩泥店","stock":1000,"title":"特狼王鱼竿手竿4.5米5.4米6.3米7.2米钓鱼竿超轻超硬碳素台钓竿 4.5米杆稍+钩漂线 本产品为预售定制款，下单前请先联系客服咨询哦！","updateTime":1680094862,"views":0}},{"_index":"goods","_type":"_doc","_id":"340","_score":1.0,"_source":{"cateName":"汽车音箱","createTime":1673165093,"description":"","fullTextSearch":"6.5寸大柏林之声喇叭音箱空箱体汽车DIY水桶音响改装家用书架制作 如需定制钻孔/改孔请联系客服汽车音箱豪车拆车喇叭小店","id":340,"image":"//img11.360buyimg.com/n7/jfs/t1/229538/29/7287/214554/6575620aFe254e913/2af724e95d01ab53.jpg","price":198.0,"shopName":"豪车拆车喇叭小店","stock":1000,"title":"6.5寸大柏林之声喇叭音箱空箱体汽车DIY水桶音响改装家用书架制作 如需定制钻孔/改孔请联系客服","updateTime":1680094862,"views":0}},{"_index":"goods","_type":"_doc","_id":"360","_score":1.0,"_source":{"cateName":"手机","createTime":1673165093,"description":"","fullTextSearch":"三星（SAMSUNG） Galaxy S24 Al智享生活办公 超视觉影像 第三代骁龙8 8GB+256GB 水墨黑 5G AI手机手机三星京东自营官方旗舰店","id":360,"image":"//img11.360buyimg.com/n7/jfs/t1/105669/35/48470/88509/65eadd08F50ab3480/c96b46bc41de9d0b.jpg","price":4999.0,"shopName":"三星京东自营官方旗舰店","stock":1000,"title":"三星（SAMSUNG） Galaxy S24 Al智享生活办公 超视觉影像 第三代骁龙8 8GB+256GB 水墨黑 5G AI手机","updateTime":1680094862,"views":0}},{"_index":"goods","_type":"_doc","_id":"341","_score":1.0,"_source":{"cateName":"汽车音箱","createTime":1673165093,"description":"","fullTextSearch":"6.5寸大柏林之声喇叭音箱空箱体汽车DIY水桶音响改装家用书架制作 柏林分频器一只汽车音箱豪车拆车喇叭小店","id":341,"image":"//img14.360buyimg.com/n7/jfs/t1/229538/29/7287/214554/6575620aFe254e913/2af724e95d01ab53.jpg","price":70.0,"shopName":"豪车拆车喇叭小店","stock":1000,"title":"6.5寸大柏林之声喇叭音箱空箱体汽车DIY水桶音响改装家用书架制作 柏林分频器一只","updateTime":1680094862,"views":0}},{"_index":"goods","_type":"_doc","_id":"597","_score":1.0,"_source":{"cateName":"狗罐头","createTime":1673165093,"description":"","fullTextSearch":"麦富迪（Myfoodie） 狗零食成幼犬通用营养拌饭狗湿粮包 羊奶肉包混合装70g*10袋 混合口味 全阶段 国产狗罐头麦富迪京东自营旗舰店","id":597,"image":"//img14.360buyimg.com/n7/jfs/t1/237833/8/13993/123403/65f57aa0F4f863c55/534fa4382e52005e.jpg","price":26.0,"shopName":"麦富迪京东自营旗舰店","stock":1000,"title":"麦富迪（Myfoodie） 狗零食成幼犬通用营养拌饭狗湿粮包 羊奶肉包混合装70g*10袋 混合口味 全阶段 国产","updateTime":1680094862,"views":0}},{"_index":"goods","_type":"_doc","_id":"587","_score":1.0,"_source":{"cateName":"狗罐头","createTime":1673165093,"description":"","fullTextSearch":"麦富迪零食鸡胸肉干907g鸡肉干泰迪金毛幼犬磨牙补钙训练宠物狗狗零食 鸡肉味 全阶段 宠物狗罐头圣贝宠宠物生活专营店","id":587,"image":"//img10.360buyimg.com/n7/jfs/t1/175445/21/14350/367519/60c47a93E44b64e1e/3b02b0b509dc52f8.jpg","price":55.0,"shopName":"圣贝宠宠物生活专营店","stock":1000,"title":"麦富迪零食鸡胸肉干907g鸡肉干泰迪金毛幼犬磨牙补钙训练宠物狗狗零食 鸡肉味 全阶段 宠物","updateTime":1680094862,"views":0}},{"_index":"goods","_type":"_doc","_id":"598","_score":1.0,"_source":{"cateName":"狗罐头","createTime":1673165093,"description":"","fullTextSearch":"麦富迪 宠物狗狗零食 成犬幼犬训狗奖励鸡肉干400g 鸡肉味 全阶段 宠物狗罐头麦富迪京东自营旗舰店","id":598,"image":"//img11.360buyimg.com/n7/jfs/t1/181140/23/42682/127918/65f57aaeFac864a94/c2dbfdddc0a45d1a.jpg","price":35.0,"shopName":"麦富迪京东自营旗舰店","stock":1000,"title":"麦富迪 宠物狗狗零食 成犬幼犬训狗奖励鸡肉干400g 鸡肉味 全阶段 宠物","updateTime":1680094862,"views":0}}]},"aggregations":{"sterms#distinctCateName":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]}}}

可以看到有数据，但是聚合函数为空。

附带上代码：

  1. public List<HashMap<String, Object>> getCategoryList() {
  2.  
  3.         SearchRequest searchRequest = new SearchRequest(EsIndex.GOODS.getValue());
  4.         // 创建一个搜索源构建器，用于构建搜索请求的主体部分
  5.         SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
  6.  
  7.         // ### 定义聚合条件，按cate_name字段分组
  8.         // 聚合名称
  9.         String termsName = "distinctCateName";
  10.         TermsAggregationBuilder aggregation = AggregationBuilders.terms(termsName).field("cate_name.keyword");
  11.         searchSourceBuilder.aggregation(aggregation);
  12.         searchRequest.source(searchSourceBuilder);
  13.  
  14.         try {
  15.             SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
  16.  
  17.             ParsedStringTerms categories = response.getAggregations().get(termsName);
  18.             ArrayList<HashMap<String, Object>> result = new ArrayList<>();
  19.             System.out.println(
  20.                     categories.getBuckets()
  21.             );
  22.  
  23.             // // 遍历每个具体的分组及其包含的结果
  24.             // for (Terms.Bucket bucket : categories.getBuckets()) {
  25.             //     HashMap<String, Object> cateMap = new HashMap<>();
  26.             //     cateMap.put("name", bucket.getKeyAsString());
  27.             //     cateMap.put("value", bucket.getKeyAsString());
  28.             //     result.add(cateMap);
  29.             // }
  30.  
  31.             return result;
  32.         } catch (CustomizeException exception) { // 自定义异常一般是对外暴露的异常错误
  33.             throw new CustomizeException(exception.getCode(), exception.getMessage(), exception);
  34.         } catch (Exception exception) { // 全局异常处理500不打算对外暴露的异常错误
  35.             throw new CustomizeException(500, exception.getMessage(), exception);
  36.         }
  37.     }

解决：

        原因是：字段问题，由于我使用的实体类bean写入ES，字段名都是大写，但是实际ES中是小写，但是实际写入也不会报错。

        查看es字段列表：

  1. GET goods
  2. # 打印结果：
  3. {
  4.   "goods" : {
  5.     "aliases" : { },
  6.     "mappings" : {
  7.       "properties" : {
  8.         "cate_name" : {
  9.           "type" : "text",
  10.           "fields" : {
  11.             "keyword" : {
  12.               "type" : "keyword"
  13.             }
  14.           },
  15.           "analyzer" : "ik_max_word"
  16.         },
  17.         "cate_name" : {
  18.           "type" : "text",
  19.           "fields" : {
  20.             "keyword" : {
  21.               "type" : "keyword",
  22.               "ignore_above" : 256
  23.             }
  24.           }
  25.         },
  26.         "create_time" : {
  27.           "type" : "date"
  28.         },
  29.         "description" : {
  30.           "type" : "keyword",
  31.           "index" : false
  32.         },
  33.         "full_text_search" : {
  34.           "type" : "text",
  35.           "copy_to" : [
  36.             "title",
  37.             "cate_name",
  38.             "shop_name"
  39.           ],
  40.           "analyzer" : "ik_max_word"
  41.         },
  42.         "id" : {
  43.           "type" : "keyword"
  44.         },
  45.         "image" : {
  46.           "type" : "keyword",
  47.           "index" : false
  48.         },
  49.         "price" : {
  50.           "type" : "scaled_float",
  51.           "scaling_factor" : 100.0
  52.         },
  53.         "shopName" : {
  54.           "type" : "text",
  55.           "analyzer" : "ik_max_word"
  56.         },
  57.         "shop_name" : {
  58.           "type" : "text",
  59.           "fields" : {
  60.             "keyword" : {
  61.               "type" : "keyword",
  62.               "ignore_above" : 256
  63.             }
  64.           }
  65.         },
  66.         "status" : {
  67.           "type" : "short"
  68.         },
  69.         "stock" : {
  70.           "type" : "integer"
  71.         },
  72.         "title" : {
  73.           "type" : "text",
  74.           "analyzer" : "ik_max_word"
  75.         },
  76.         "update_time" : {
  77.           "type" : "date"
  78.         },
  79.         "views" : {
  80.           "type" : "integer"
  81.         }
  82.       }
  83.     },
  84.     "settings" : {
  85.       "index" : {
  86.         "routing" : {
  87.           "allocation" : {
  88.             "include" : {
  89.               "_tier_preference" : "data_content"
  90.             }
  91.           }
  92.         },
  93.         "number_of_shards" : "1",
  94.         "provided_name" : "goods",
  95.         "creation_date" : "1712113365252",
  96.         "number_of_replicas" : "1",
  97.         "uuid" : "UyIaiESoTSyhWJO4CuhZnw",
  98.         "version" : {
  99.           "created" : "7120199"
  100.         }
  101.       }
  102.     }
  103.   }
  104. }

可以看到cate name是驼峰法，所以重建索引改为驼峰法即可。

  1. # 删除索引
  2. DELETE goods
  3.  
  4. PUT goods
  5. {
  6.   "properties": {
  7.     "id": {
  8.       "type": "keyword"
  9.     },
  10.     "cateName": {
  11.       "type": "text",
  12.       "analyzer": "ik_max_word",
  13.       "fields": {
  14.         "keyword": {
  15.           "type": "keyword"
  16.         }
  17.       }
  18.     },
  19.     "title": {
  20.       "type": "text",
  21.       "analyzer": "ik_max_word"
  22.     },
  23.     "image": {
  24.       "type": "keyword",
  25.       "index": false
  26.     },
  27.     "description": {
  28.       "type": "keyword",
  29.       "index": false
  30.     },
  31.     "price": {
  32.       "type": "scaled_float",
  33.       "scaling_factor": 100
  34.     },
  35.     "stock": {
  36.       "type": "integer"
  37.     },
  38.     "views": {
  39.       "type": "integer"
  40.     },
  41.     "status": {
  42.       "type": "short"
  43.     },
  44.     "createTime": {
  45.       "type": "date"
  46.     },
  47.     "updateTime": {
  48.       "type": "date"
  49.     },
  50.     "shopName": {
  51.       "type": "text",
  52.       "analyzer": "ik_max_word"
  53.     },
  54.     "fullTextSearch": {
  55.       "type": "text",
  56.       "analyzer": "ik_max_word",
  57.       "copy_to": [
  58.         "title",
  59.         "cate_name",
  60.         "shop_name"
  61.       ]
  62.     }
  63.   }
  64. }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/繁依Fanyi0/article/detail/383906
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号