在 elasticsearch 中，如何根据不影响实际查询命中的特定条件过滤特定的内部对象

Question

如何根据特定条件仅过滤内部对象。例如，我有产品存储在 es 中。根据某些字段，我想查询产品，例如型号和其他一些条件。但是我想只在传递的语言值中列出查询结果的名称和描述。

架构如下

PUT /product/
{"mappings":{"productTypeA":{"dynamic":"strict","properties":{"id":{"type":"keyword"},"model":{"type":"keyword"},"version":{"type":"keyword"},"launchDate":{"type":"date","format":"yyyyMMdd'T'HHmmss.SSSZ","fields":{"keyword":{"type":"keyword"}}},"names":{"type":"object","properties":{"locale":{"type":"keyword"},"value":{"type":"keyword"}}},"descriptions":{"type":"object","properties":{"locale":{"type":"keyword"},"value":{"type":"keyword"}}}}}}}

我的产品 1

POST /product/productTypeA/1
{"id":"1","model":"modelA","version":"1.0","launchDate":"20190924T175212.057+0000","names":[{"locale":"en","value":"product one"},{"locale":"fr","value":"produit un"},{"locale":"de","value":"Produkt eins"}],"descriptions":[{"locale":"en","value":"product one description"},{"locale":"fr","value":"description du produit un"},{"locale":"de","value":"Produkt eins Beschreibung"}]}

我的产品2

POST /product/productTypeA/2
{"id":"2","model":"modelA","version":"1.0","launchDate":"20190924T175212.057+0000","names":[{"locale":"en","value":"product two"},{"locale":"fr","value":"produit deux"},{"locale":"de","value":"Produkt zwei"}],"descriptions":[{"locale":"en","value":"product two description"},{"locale":"fr","value":"description du produit deux"},{"locale":"de","value":"Produkt zwei Beschreibung"}]}

我尝试对以下产品数据进行以下查询post_filter

GET /product/productTypeA/_search
{"query":{"bool":{"must":[{"term":{"model":"modelA"}}]}},"post_filter":{"bool":{"should":{"term":{"names.locale":"fr"}}}}}

但是我的结果有所有语言的名称和描述，正如我所期望的那样，每个查询结果只有法语

{"took":1,"timed_out":false,"_shards":{"total":5,"successful":5,"skipped":0,"failed":0},"hits":{"total":2,"max_score":0.2876821,"hits":[{"_index":"product","_type":"productTypeA","_id":"2","_score":0.2876821,"_source":{"id":"2","model":"modelA","version":"1.0","launchDate":"20190924T175212.057+0000","names":[{"locale":"en","value":"product two"},{"locale":"fr","value":"produit deux"},{"locale":"de","value":"Produkt zwei"}],"descriptions":[{"locale":"en","value":"product two description"},{"locale":"fr","value":"description du produit deux"},{"locale":"de","value":"Produkt zwei Beschreibung"}]}},{"_index":"product","_type":"productTypeA","_id":"1","_score":0.2876821,"_source":{"id":"1","model":"modelA","version":"1.0","launchDate":"20190924T175212.057+0000","names":[{"locale":"en","value":"product one"},{"locale":"fr","value":"produit un"},{"locale":"de","value":"Produkt eins"}],"descriptions":[{"locale":"en","value":"product one description"},{"locale":"fr","value":"description du produit un"},{"locale":"de","value":"Produkt eins Beschreibung"}]}}]}}

Answer 1

如果要过滤"描述"，则需要将映射从对象更改为嵌套类型。 对象类型存储为平面字段，因此无法对其进行筛选 例如，当描述类型为对象时，其下的字段存储为描述.区域设置等。

下面的查询将返回所有具有法语描述的模型A，法语描述将出现在inner_hits

GET /product/_search
{
"query": {
"bool": {
"must": [
{
"term": {
"model": "modelA"
}
},
{
"nested": {
"path": "descriptions",
"query": {
"match": {
"descriptions.locale": "fr"
}
},
"inner_hits": {}
}
}
]
}
}
}

编辑 1：

GET /product/_search
{
"query": {
"bool": {
"must": [
{
"term": {
"model": "modelA"
}
}
],
"should": [
{
"nested": {
"path": "descriptions",
"query": {
"match": {
"descriptions.locale": "fr"
}
},
"inner_hits": {}
}
}
]
}
}
}