es实现桶聚合 - ToB企服应用市场:ToB评测及商务社交产业平台

GET /hotel/_search
{
"size":0, //返回命中文档的详细信息的数量，（默认执行match_all）,这里设置为0就是不返回文档的详细信息
"aggs":{ //聚合查询关键字
"brandSum":{ //桶名字
"trems":{ //聚合的类型，这里使用brand字段聚合，所以使用terms
"field":"brand",
"size":20 //返回最多的桶数量，如果设置为1，就只返回一个桶的信息
}
}
}
}

复制代码

GET /hotel/_search
{
"size":0,
"aggs":{
"brandSum":{
"terms":{
"field":"brand",
"size":20,
"order":{ #自定义排序规则
"_count":asc #使用桶内的文档数进行升序排序
}
}
}
}
}

复制代码

GET /hotel/_search
{
"aggs":{
"brandSum":{
"terms":{
"field":"brand",
"size":20
},
"aggs":{ //brandSum聚合下的子聚合
"scoreStats":{//子聚合名字
"stats":{ //聚合的类型·。stats会把max,min,avg,sum,count都算出来
"field":"score"
}
}
}
}
}
}

复制代码

@SpringBootTest
public class TestAggregation {
@Autowired
private RestHighLevelClient restHighLevelClient;
@Test
public void test01() throws IOException {
//构建查询对象
SearchRequest request = new SearchRequest("hotel");
//设置dsl语句
request.source().size(0);
request.source().aggregation(AggregationBuilders
.terms("brandSum")//指定聚合的名字为brandSum，且聚合的类型是terms
.field("brand")//指定聚合的字段是brand
.size(20));
//发送请求
SearchResponse response = restHighLevelClient.search(request, RequestOptions.DEFAULT);
//解析响应数据
Aggregations aggregations = response.getAggregations();
Terms brandSum= aggregations.get("brandSum");
List<? extends Terms.Bucket> buckets = brandSum.getBuckets();
for (Terms.Bucket bucket : buckets) {
String key = bucket.getKeyAsString();
System.out.println(key);
}
}
}

复制代码

package com.hhh.hotel.pojo;
import lombok.Data;
@Data
public class RequestParams {
private String key;
private Integer page;
private Integer size;
private String sortBy;
// 下面是新增的过滤条件参数
private String city;
private String brand;
private String starName;
private Integer minPrice;
private Integer maxPrice;
//坐标
private String location;
}

复制代码

@RestController
@RequestMapping("/hotel")
public class HotelController {
@Autowired
private HotelService hotelService;
@PostMapping("/list")
public PageResult getPageResult(@RequestBody RequestParams params){
return hotelService.getPageResult(params);
}
/**
* 获取传入条件过滤出星级，城市，品牌
*/
@PostMapping("/filters")
public Map<String, List<String>> getFilters(@RequestBody RequestParams params){
return hotelService.getFilters(params);
}
}

复制代码

@Service
public class HotelServiceImpl extends ServiceImpl<HotelMapper, Hotel>
implements HotelService {
@Autowired
private RestHighLevelClient restHighLevelClient;
@Override
public PageResult getPageResult(RequestParams params) {
//1.构建查询请求对象
SearchRequest request = new SearchRequest("hotel");
//2.编写dsl语句
/* //2.1如果key为空，即搜索的内容为空，就全文查询
if(StringUtils.isBlank(params.getKey())){
request.source().query(QueryBuilders.matchAllQuery());
}else {
request.source().query(QueryBuilders.matchQuery("all",params.getKey()));
}*/
assembleBasicQuery(params,request);
//构建高亮显示
request.source().highlighter(new HighlightBuilder().field("name").requireFieldMatch(false));
//3.构建分页信息
Integer pageNum=params.getPage()==null?1:params.getPage();//默认是第一页
Integer pageSize=params.getSize()==null?5:params.getSize();//默认每页大小为5
request.source().from((pageNum-1)*pageSize).size(pageSize);
//TODO:维护距离排序
if(StringUtils.isNotBlank(params.getLocation())) {
GeoDistanceSortBuilder geoDistanceSortBuilder = new GeoDistanceSortBuilder("location", new GeoPoint(params.getLocation()))
.order(SortOrder.ASC) // 升序排序
.unit(DistanceUnit.KILOMETERS); // 单位为千米
request.source().sort(geoDistanceSortBuilder);
}
if(params.getSortBy().equals("price")){
request.source().sort("price",SortOrder.ASC);
} else if (params.getSortBy().equals("score")) {
request.source().sort("score",SortOrder.DESC);
}
//4.发送请求
SearchResponse response = null;
try {
response = restHighLevelClient.search(request, RequestOptions.DEFAULT);
} catch (IOException e) {
throw new RuntimeException("查询异常");
}
//5.解析数据
Boolean isEnableKm=false;
if(params.getLocation()!=null){
isEnableKm=true;//location字段不为null,才设置为true，然后获取排序值
}
return ParseResponse(response,isEnableKm);
}
/**
* 获取传入条件过滤出星级，城市，品牌
*/
@Override
public Map<String, List<String>> getFilters(RequestParams params) {
SearchRequest request = new SearchRequest("hotel");
request.source().size(0);
//设置query DSL语句
assembleBasicQuery(params,request);
//构建桶聚合
request.source().aggregation(AggregationBuilders
.terms("brandSum")
.field("brand")
.size(20));
request.source().aggregation(AggregationBuilders
.terms("citySum")
.field("city")
.size(20));
request.source().aggregation(AggregationBuilders
.terms("starNameSum")
.field("starName")
.size(20));
//发起请求
SearchResponse response = null;
try {
response = restHighLevelClient.search(request, RequestOptions.DEFAULT);
} catch (IOException e) {
throw new RuntimeException(e);
}
//解析返回数据
List<String>brands=parseAggreData(response,"brandSum");
List<String>citys=parseAggreData(response,"citySum");
List<String>startNames=parseAggreData(response,"starNameSum");
Map<String, List<String>> info = new HashMap<>();
info.put("brand",brands);
info.put("city",citys);
info.put("starName",startNames);
return info;
}
/**
* 解析桶数据
* @return
*/
private List<String> parseAggreData(SearchResponse response, String sum) {
Aggregations aggregations = response.getAggregations();
Terms aggregation = aggregations.get(sum);
if(aggregation==null||CollectionUtils.isEmpty(aggregation.getBuckets())){
return null;
}
ArrayList<String> list = new ArrayList<>();
for (Terms.Bucket bucket : aggregation.getBuckets()) {
String key = bucket.getKeyAsString();
list.add(key);
}
return list;
}
/**
* 组装dsl查询语句
* @param params 前端封装类
* @param request 查询请求对象
*/
private void assembleBasicQuery(RequestParams params,SearchRequest request){
BoolQueryBuilder boolQuery = QueryBuilders.boolQuery();
//1.判断key是否为空
if(StringUtils.isBlank(params.getKey())){
boolQuery.must(QueryBuilders.matchAllQuery());
}else{
boolQuery.must(QueryBuilders.matchQuery("all",params.getKey()));
}
//品牌名不为空,对品牌过滤
if(StringUtils.isNotBlank(params.getBrand())){
boolQuery.filter(QueryBuilders.termQuery("brand",params.getBrand()));
}
//城市
if(StringUtils.isNotBlank(params.getCity())){
boolQuery.filter(QueryBuilders.termQuery("city",params.getCity()));
}
//星级
if(StringUtils.isNotBlank(params.getStarName())){
boolQuery.filter(QueryBuilders.termQuery("startName",params.getStarName()));
}
//价格范围
if(params.getMaxPrice()!=null&&params.getMinPrice()!=null){
boolQuery.filter(QueryBuilders.rangeQuery("price").gte(params.getMinPrice()).lte(params.getMaxPrice()));
}
//定义算分函数
//设置排名，根据算分设置level排名
FieldValueFactorFunctionBuilder functionBuilder = ScoreFunctionBuilders.fieldValueFactorFunction("value").modifier(FieldValueFactorFunction.Modifier.NONE).factor(1.5F).missing(1);
FunctionScoreQueryBuilder.FilterFunctionBuilder[] functions = new FunctionScoreQueryBuilder.FilterFunctionBuilder[] {
new FunctionScoreQueryBuilder.FilterFunctionBuilder(
QueryBuilders.termQuery("isAD",true),
//ScoreFunctionBuilders.weightFactorFunction(10) // 权重因子，乘以基础得分
functionBuilder
)
};
FunctionScoreQueryBuilder functionScoreQuery = QueryBuilders.functionScoreQuery(boolQuery, functions).boostMode(CombineFunction.SUM);
request.source().query(functionScoreQuery);
}
/**
* 解析es响应的数据
*/
private PageResult ParseResponse(SearchResponse response,Boolean isEnableKm) {
SearchHits hits = response.getHits();
//1.获取总命中文档数
long size = hits.getTotalHits().value;
SearchHit[] hits1 = hits.getHits();
ArrayList<HotelDoc> docs = new ArrayList<>();
if(ArrayUtils.isNotEmpty(hits1)){
for (SearchHit searchHit : hits1) {
String jsonData = searchHit.getSourceAsString();
HotelDoc hotelDoc = JSON.parseObject(jsonData, HotelDoc.class);
if(isEnableKm) {
//获取排序后的距离
Object[] sortValues = searchHit.getSortValues();
if (ArrayUtils.isNotEmpty(sortValues)) {
hotelDoc.setDistance(sortValues[0]);
}
}
//获取高亮
Map<String, HighlightField> fieldMap = searchHit.getHighlightFields();
if(!CollectionUtils.isEmpty(fieldMap)){
HighlightField highlightField = fieldMap.get("name");
String highName = highlightField.getFragments()[0].string();
//替换hotel实体类的name属性
hotelDoc.setName(highName);
}
docs.add(hotelDoc);
}
}
return new PageResult(size,docs);
}
}

复制代码