gpt4 book ai didi

elasticsearch - 如何获得按类型分隔的聚合?

转载 作者:行者123 更新时间:2023-12-02 23:30:41 24 4
gpt4 key购买 nike

我有一个索引“my_index”和2个类型“color1”和“color2”。两种类型的每个文档都有一个“颜色”字段。

对“颜色”和整个索引进行聚合,我将得到如下信息:

[{ "key": "red", "doc_count": 10},  
{ "key": "blue", "doc_count": 9},
{ "key": "green", "doc_count": 8}]

没有两个查询,是否有可能得到类似的结果:
[{ "key": "color1.red", "doc_count": 7},  
{ "key": "color1.blue", "doc_count": 6},
{ "key": "color1.green", "doc_count": 5},
{ "key": "color2.red", "doc_count": 3},
{ "key": "color2.blue", "doc_count": 3},
{ "key": "color2.green", "doc_count": 3}]

要么:
{"color1":    
[{ "key": "red", "doc_count": 7},
{ "key": "blue", "doc_count": 6},
{ "key": "green", "doc_count": 5}],
"color2":
[{ "key": "red", "doc_count": 3},
{ "key": "blue", "doc_count": 3},
{ "key": "green", "doc_count": 3}]}

最佳答案

有可能的:

{
"size": 0,
"aggs": {
"by_type": {
"terms": {
"field": "_type",
"size": 10
},
"aggs": {
"by_color": {
"terms": {
"field": "color",
"size": 10
}
}
}
}
}
}

关于elasticsearch - 如何获得按类型分隔的聚合?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/36762556/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com