原文:https://truemped.github.io/posts/search/campaigns-in-elasticsearch/
Mapping定义:
{
"mappings": {
"properties": {
"prices": {
"type": "nested",
"properties": {
"price": {"type": "integer"},
"from": {"type": "date"},
"to": {"type": "date"}
}
}
}
}
}
索引两个文档:
{
"prices": [
{
"price": 15,
"from": "2020-03-17T00:00:00Z",
"to": "2020-03-17T17:59:59Z"
},
{
"price": 12,
"from": "2020-03-17T18:00:00Z",
"to": "2020-03-18T23:59:59Z"
},
{
"price": 15,
"from": "2020-03-19T00:00:00Z",
"to": "2020-03-31T23:59:59Z"
}
]
}
{
"prices": [
{
"price": 20,
"from": "2020-03-17T00:00:00Z",
"to": "2020-03-17T17:59:59Z"
},
{
"price": 10,
"from": "2020-03-17T19:00:00Z",
"to": "2020-03-18T09:59:59Z"
},
{
"price": 20,
"from": "2020-03-19T00:00:00Z",
"to": "2020-03-31T23:59:59Z"
}
]
}