这是一个创建于 1373 天前的主题，其中的信息可能已经有所发展或是发生改变。
es 是不是不能能 AggregationBuilders.terms 的字段进行排序，用了后报这个错。 Buckets can only be sorted on a sub-aggregator path that is built out of zero or more single-bucket aggregations within the path and a final single-bucket or a metrics aggregation at the path end
第 1 条附言 · 2021-03-10 14:30:16 +08:00
这个是查询条件，排序后的结果和期望的不一样，通过 trace_no 分组，用求和的 order_money 来排序
{
"query": {
"bool": {
"filter": [{
"term": {
"order_market_id": {
"value": "1828"
}
}
}, {
"term": {
"member_id": {
"value": "0012695142"
}
}
}]
}
},
"aggregations": {
"agg": {
"terms": {
"field": "trace_no",
"size": 2147483647,
"order": {
"latestOrder": "desc"
}
},
"aggregations": {
"latestOrder": {
"sum": {
"field": "order_money"
}
},
"top": {
"top_hits": {
"version": false,
"seq_no_primary_term": false,
"explain": false,
"_source": {
"includes": [
"order_time","order_money","trace_no","card_no","bill_no","member_id","sku_name"
],
"excludes": [
]
}
}
},
"bucket_field": {
"bucket_sort": {
"sort": [{
"latestOrder": {
"order": "desc"
}
}],
"from": 0,
"size": 10
}
}
}
}
}
}
{
"query": {
"bool": {
"filter": [{
"term": {
"order_market_id": {
"value": "1828"
}
}
}, {
"term": {
"member_id": {
"value": "0012695142"
}
}
}]
}
},
"aggregations": {
"agg": {
"terms": {
"field": "trace_no",
"size": 2147483647,
"order": {
"latestOrder": "desc"
}
},
"aggregations": {
"latestOrder": {
"sum": {
"field": "order_money"
}
},
"top": {
"top_hits": {
"version": false,
"seq_no_primary_term": false,
"explain": false,
"_source": {
"includes": [
"order_time","order_money","trace_no","card_no","bill_no","member_id","sku_name"
],
"excludes": [
]
}
}
},
"bucket_field": {
"bucket_sort": {
"sort": [{
"latestOrder": {
"order": "desc"
}
}],
"from": 0,
"size": 10
}
}
}
}
}
}
 |
1
456789 2021-03-10 10:36:24 +08:00
插眼问下 有没有好的使用 es 的例子，主要是对 RestHighLevelClient 的关闭管理这里想看看有没有好的
|
1 |
3
sinux 2021-03-10 14:22:58 +08:00
没 query 不太懂想怎么排序。建议看看 bucket sort aggregation 那部分 。
|
Select Language