1.简介
Range Query(范围查询)主要针对的是数值和日期类型。支持的四种范围分别为gte(大于等于)、gt(大于)、lte(小于等于)以及lt(小于)。
2.数值类
查询年龄大于等于25且小于30岁的文档。
POST /people/_search
{
"query": {
"range": {
"age": {
"gte": 25,
"lt": 30
}
}
}
}{
"took" : 215,
"timed_out" : false,
"_shards" : {
"total" : 5,
"successful" : 5,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 1,
"relation" : "eq"
},
"max_score" : 1.0,
"hits" : [
{
"_index" : "people",
"_type" : "_doc",
"_id" : "nh1itXsBP1atFW21Keav",
"_score" : 1.0,
"_source" : {
"name" : "Mike Steven",
"country" : "China",
"age" : 26,
"date" : "1995-01-01",
"description" : "I am Mike Steven."
}
}
]
}
}3.日期类
查询出生日期在1995-01-01之前的文档。
POST /people/_search
{
"query": {
"range": {
"date": {
"lt": "1995-01-01"
}
}
}
}{
"took" : 1,
"timed_out" : false,
"_shards" : {
"total" : 5,
"successful" : 5,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 4,
"relation" : "eq"
},
"max_score" : 1.0,
"hits" : [
{
"_index" : "people",
"_type" : "_doc",
"_id" : "oB1itXsBP1atFW21SuZG",
"_score" : 1.0,
"_source" : {
"name" : "Deron Williams",
"country" : "Englend",
"age" : 32,
"date" : "1989-01-01",
"description" : "How are you!"
}
},
{
"_index" : "people",
"_type" : "_doc",
"_id" : "ox1itXsBP1atFW21bObu",
"_score" : 1.0,
"_source" : {
"name" : "Mike Owen",
"country" : "Englend",
"age" : 34,
"date" : "1987-03-12",
"description" : "Are you?"
}
},
{
"_index" : "people",
"_type" : "_doc",
"_id" : "oR1itXsBP1atFW21Vubm",
"_score" : 1.0,
"_source" : {
"name" : "LeBron James",
"country" : "USA",
"age" : 37,
"date" : "1984-06-26",
"description" : "How old are you?"
}
},
{
"_index" : "people",
"_type" : "_doc",
"_id" : "oh1itXsBP1atFW21V-Zw",
"_score" : 1.0,
"_source" : {
"name" : "LeBron James",
"country" : "USA",
"age" : 37,
"date" : "1984-06-26",
"description" : "How old are you?"
}
}
]
}
}
