ElasticSearch可以执行复杂的条件查询,下面直接举例子:
首先先添加文档:
PUT /user_dao/user_table/1
{
"name":"baby",
"sex":0,
"age":1
}
PUT /user_dao/user_table/2
{
"name":"father",
"sex":0,
"age":26
}
PUT /user_dao/user_table/3
{
"name":"mother",
"sex":1,
"age":24
}
PUT /user_dao/user_table/4
{
"name":"grandfather",
"sex":1,
"age":60
}
PUT /user_dao/user_table/5
{
"name":"grandmother",
"sex":1,
"age":58
}
1. 根据id进行查询
GET /user_dao/user_table/1
2.查询当前所有类型的文档
GET /user_dao/user_table/_search
3.根据多个ID批量查询 ,查询多个id分别为1、2
GET /user_dao/user_table/_mget
{
"ids":["1","2"]
}
4.查询年龄为年龄24岁
GET /user_dao/user_table/_search?q=age:24
5. 查询年龄20岁-60岁之间(注意:TO 一定要大写)
GET /user_dao/user_table/_search?q=age[20 TO 60]
返回结果:
{
"took": 77,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 4,
"max_score": 1,
"hits": [
{
"_index": "user_dao",
"_type": "user_table",
"_id": "5",
"_score": 1,
"_source": {
"name": "grandmother",
"sex": 1,
"age": 58
}
},
{
"_index": "user_dao",
"_type": "user_table",
"_id": "2",
"_score": 1,
"_source": {
"name": "father",
"sex": 0,
"age": 26
}
},
{
"_index": "user_dao",
"_type": "user_table",
"_id": "4",
"_score": 1,
"_source": {
"name": "grandfather",
"sex": 1,
"age": 60
}
},
{
"_index": "user_dao",
"_type": "user_table",
"_id": "3",
"_score": 1,
"_source": {
"name": "mother",
"sex": 1,
"age": 24
}
}
]
}
}
6.查询年龄20岁-60岁之间并且年龄降序、从0条数据到第1条数据
GET /user_dao/user_table/_search?q=age[30 TO 60]&sort=age:desc&from=0&size=1
返回内容:
{
"took": 57,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 2,
"max_score": null,
"hits": [
{
"_index": "user_dao",
"_type": "user_table",
"_id": "4",
"_score": null,
"_source": {
"name": "grandfather",
"sex": 1,
"age": 60
},
"sort": [
60
]
}
]
}
}
7.查询年龄20岁-60岁之间并且年龄降序、从0条数据到第1条数据,展示name和age字段
GET /user_dao/user_table/_search?q=age[30 TO 60]&sort=age:desc&from=0&size=1&_source=name,age
返回结果:
{
"took": 48,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 2,
"max_score": null,
"hits": [
{
"_index": "user_dao",
"_type": "user_table",
"_id": "4",
"_score": null,
"_source": {
"name": "grandfather",
"age": 60
},
"sort": [
60
]
}
]
}
}