Elasticsearch:如何对同一个值应用多个过滤器?

您的问题是由Elasticsearch引起的 flattens objects

{
    "name": "John",
    "tickets.color": ["green", "red"],
    "tickets.code": ["001", "002"]
},
{
    "name": "Frank",
    "tickets.color": ["red", "green"],
    "tickets.code": ["001", "002"]
}

不可能知道同一物体上的颜色和代码。(原始源也会存储,以便在您发出请求时返回,但这不是搜索时查询的数据。)

这里有两种可能的解决方案: denormalization 或 nested data type . 如果你能侥幸逃脱,反规范化是更好的选择,因为它更有效。如果对数据进行非规范化,可能会得到如下表示:

{
    "name": "John",
    "ticket": {
        "color": "green",
        "code": "001"
    }
},
{
    "name": "John",
    "ticket": {
        "color": "red",
        "code": "002"
    }

},
{
    "name": "Frank",
    "ticket": {
        "color": "red",
        "code": "001"
    }
},
{
    "name": , "Frank",
    "ticket": {
        "color": "green",
        "code": "002"
    }
}

如果使用嵌套数据类型,则必须使用如下映射:

{
     "ticket": {
         "type": "nested",
         "properties": {
             "color": {"type": "keyword"},
             "code": {"type": "keyword"}
         }
     }
}