2024年大数据最全Elasticsearch 分组分页排序查询_elasticsearch分组查询，2024年最新年末阿里百度等大厂技术面试题汇总

本文链接：https://blog.csdn.net/2401_84159813/article/details/138810770

网上学习资料一大堆，但如果学到的知识不成体系，遇到问题时只是浅尝辄止，不再深入研究，那么很难做到真正的技术提升。

一个人可以走的很快，但一群人才能走的更远！不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人，都欢迎加入我们的的圈子（技术交流、学习资源、职场吐槽、大厂内推、面试辅导），让我们一起学习成长！

//es查询分页指标和分组terms要同级

//hit查询返回0条数据
searchSourceBuilder.size(0);
searchSourceBuilder.from(0);
//排序
searchRequest.source(searchSourceBuilder.sort(“visit_time_long”, SortOrder.DESC));
//query条件–正常查询条件
searchRequest.source(searchSourceBuilder.query(boolBuilder));
//聚合条件分组+分页指标 searchRequest.source(searchSourceBuilder.aggregation(termsAggregationBuilder));
searchRequest.source(searchSourceBuilder.aggregation(cardinalityAggregation));




2、es语句

GET /xxxxx/_search
{
“from”: 0,
“size”: 0,
“query”: {
“bool”: {
“must”: [
{
“term”: {
“del_flag”: {
“value”: false,
“boost”: 1
}
}
}
],
“adjust_pure_negative”: true,
“boost”: 1
}
},
“sort”: [
{
“visit_time_long”: {
“order”: “desc”
}
}
],
“aggregations”: {
“topCustomer”: {
“terms”: {
“field”: “customer_no.keyword”,
“size”: 5,
“min_doc_count”: 1,
“shard_min_doc_count”: 0,
“show_term_doc_count_error”: false,
“order”: [
{
“_count”: “desc”
},
{
“_key”: “asc”
}
]
},
“aggregations”: {
“latestCust”: {
“top_hits”: {
“from”: 0,
“size”: 1,
“version”: false,
“seq_no_primary_term”: false,
“explain”: false,
“_source”: {
“includes”: [
“customer_no”,
“customer_name”,
“identify_no”,
“visit_time”,
“service_item_names”,
“id”,
“type”
],
“excludes”: []
},
“sort”: [
{
“visit_time_long”: {
“order”: “desc”
}
}
]
}
},
“sortCustomer”: {
“bucket_sort”: {
“sort”: [],
“from”: 0,
“size”: 5,
“gap_policy”: “SKIP”
}
}
}
},
“custCard”: {
“cardinality”: {
“field”: “customer_no.keyword”
}
}