Mapping: customer里有nested address, address里有nested properties。
实际返回结果，不符合过滤条件的数据没有被统计到'其他'桶里。
buckets:[
{
"key":"上海市",
"doc_count":1
},
{
"key":"其他",
"doc_count":2
}]
curl -XPUT 'localhost:9200/customer/' -d '
{
"mappings": {
"doc": {
"properties": {
"address": {
"type": "nested",
"dynamic": "false",
"properties": {
"city": {
"properties": {
"name": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
},
"country": {
"properties": {
"name": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
},
"county": {
"properties": {
"name": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
},
"properties": {
"type": "nested",
"properties": {
"isPrimary": {
"type": "keyword"
},
"type": {
"type": "keyword"
}
}
},
"province": {
"properties": {
"name": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
}
}
}
}
}
}
}
'curl XPUT 'localhost:9200/customer/doc/1' -d
'{
"address": [
{
"country": {
"name": "中国"
},
"province": {
"name": "上海市"
},
"properties": [
{
"type": "BILLING",
"isPrimary": "Y"
}
]
},
{
"country": {
"name": "中国"
},
"province": {
"name": "北京市"
},
"properties": [
{
"type": "BILLING",
"isPrimary": "N"
}
]
}
]
}'
curl XPUT 'localhost:9200/customer/doc/2' -d
'{
"address": null
}'
curl XPUT 'localhost:9200/customer/doc/3' -d
'{
"address": [
{
"country": {
"name": "中国"
},
"province": {
"name": "上海市"
},
"properties": [
{
"type": "SHIPPING_TO",
"isPrimary": "Y"
}
]
}
]
}'
curl 'localhost:9200/customer/_search' -d
'{
"size": 0,
"aggs": {
"address": {
"nested": {
"path": "address"
},
"aggs": {
"shipping_to_address": {
"aggs": {
"province": {
"terms": {
"field": "address.province.name.keyword",
"size": 10,
"missing": "其他"
}
}
},
"filter": {
"bool": {
"must": [
{
"nested": {
"path": "address.properties",
"query": {
"bool": {
"filter": [
{
"term": {
"address.properties.isPrimary": "Y"
}
},
{
"term": {
"address.properties.type": "SHIPPING_TO"
}
}
]
}
}
}
}
]
}
}
}
}
}
}
}'实际返回结果，不符合过滤条件的数据没有被统计到'其他'桶里。
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 3,
"max_score": 0,
"hits":
},
"aggregations": {
"address": {
"doc_count": 3,
"shipping_to_address": {
"doc_count": 1,
"province": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "上海市",
"doc_count": 1
}
]
}
}
}
}
}buckets:[
{
"key":"上海市",
"doc_count":1
},
{
"key":"其他",
"doc_count":2
}]
2 个回复
alvin - 90后IT男
赞同来自: fantuan
laoyang360 - 《一本书讲透Elasticsearch》作者，Elastic认证工程师 [死磕Elasitcsearch]知识星球地址：http://t.cn/RmwM3N9；微信公众号：铭毅天下; 博客：https://elastic.blog.csdn.net
赞同来自: