"hits": [
{
"_index": "mytest",
"_type": "doc",
"_id": "2",
"_score": 1,
"_source": {
"AuthorObjectJson": [
{
"Name": "wang wu",
"Org": "beihang university"
},
{
"Name": "zhao liu",
"Org": "chongqing university"
}
]
}
},
{
"_index": "mytest",
"_type": "doc",
"_id": "1",
"_score": 1,
"_source": {
"AuthorObjectJson": [
{
"Name": "zhang san",
"Org": "beihang university"
},
{
"Name": "li si",
"Org": "chongqing university"
}
]
}
}
]
我的索引中有如上的資料，AuthorObjectJson是nested型別。現在我想對Org是beihang university的人進行聚合統計，使用如下的查詢
GET mytest/_search
{
"query": {
"bool": {
"must": [
{
"nested": {
"path": "AuthorObjectJson",
"query": {
"match_phrase": {
"AuthorObjectJson.Org": "beihang university"
}
}
}
}
]
}
},
"aggs": {
"NAME": {
"nested": {
"path": "AuthorObjectJson"
},
"aggs": {
"SDF": {
"terms": {
"field": "AuthorObjectJson.Name.keyword",
"size": 10
}
}
}
}
}
}
得到如下結果：
"aggregations": {
"NAME": {
"doc_count": 4,
"SDF": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "li si",
"doc_count": 1
},
{
"key": "wang wu",
"doc_count": 1
},
{
"key": "zhang san",
"doc_count": 1
},
{
"key": "zhao liu",
"doc_count": 1
}
]
}
}
}這不是我想要的結果，我想要的是zhang san 和 wangwu 他們兩個才是beihang university的學生。這個怎么解決？
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/208592.html
標籤：搜索引擎技術
上一篇：如何將lineEdit中的text寫入tablewidget中
下一篇：AttributeError: module 'tensorflow' has no attribute 'Summary'