elasticsearch query DSL学习及使用—

elasticsearch query DSL学习及使用——part1

本文主要参考：

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-body.html

好，下面上货。

查询年龄为30岁的学生的信息

GET xytest/sutdent/_search
{
“query” : {
“term”: {
“age”: {
“value”: “30”
}
}
}
}

结果为：

{
“took”: 1,
“timed_out”: false,
“_shards”: {
“total”: 5,
“successful”: 5,
“failed”: 0
},
“hits”: {
“total”: 1,
“max_score”: 0.2876821,
“hits”: [
{
“_index”: “xytest”,
“_type”: “sutdent”,
“_id”: “5”,
“_score”: 0.2876821,
“_source”: {
“sid”: “00005”,
“name”: “范旭”,
“age”: “30”,
“region”: “新疆维吾尔自治区和田地区和田县”,
“grade”: [
{
“数学”: 90
},
{
“语文”: 69
},
{
“英语”: 60
}
]
}
}
]
}
}

查询学生中前两条数据（这是基础的分页，关于深度分页，会单独再说，这里空着url）

GET xytest/sutdent/_search
{
“from”: 0,
“size”: 2
}

结果为：

{
“took”: 1,
“timed_out”: false,
“_shards”: {
“total”: 5,
“successful”: 5,
“failed”: 0
},
“hits”: {
“total”: 6,
“max_score”: 1,
“hits”: [
{
“_index”: “xytest”,
“_type”: “sutdent”,
“_id”: “5”,
“_score”: 1,
“_source”: {
“sid”: “00005”,
“name”: “范旭”,
“age”: “30”,
“region”: “新疆维吾尔自治区和田地区和田县”,
“grade”: [
{
“数学”: 90
},
{
“语文”: 69
},
{
“英语”: 60
}
]
}
},
{
“_index”: “xytest”,
“_type”: “sutdent”,
“_id”: “2”,
“_score”: 1,
“_source”: {
“sid”: “00002”,
“name”: “符巧”,
“age”: “26”,
“region”: “河北省廊坊市霸州市”,
“grade”: [
{
“数学”: 70
},
{
“语文”: 89
},
{
“英语”: 79
}
]
}
}
]
}
}

查询数学成绩前两名的学生

GET xytest/sutdent/_search
{
“sort”: [
{
“grade.数学”: {
“order”: “desc”
}
}
]
, “from”: 0
, “size”: 2
}

运行结果：

{
“took”: 1,
“timed_out”: false,
“_shards”: {
“total”: 5,
“successful”: 5,
“failed”: 0
},
“hits”: {
“total”: 6,
“max_score”: null,
“hits”: [
{
“_index”: “xytest”,
“_type”: “sutdent”,
“_id”: “5”,
“_score”: null,
“_source”: {
“sid”: “00005”,
“name”: “范旭”,
“age”: “30”,
“region”: “新疆维吾尔自治区和田地区和田县”,
“grade”: [
{
“数学”: 90
},
{
“语文”: 69
},
{
“英语”: 60
}
]
},
“sort”: [
90
]
},
{
“_index”: “xytest”,
“_type”: “sutdent”,
“_id”: “4”,
“_score”: null,
“_source”: {
“sid”: “00004”,
“name”: “符龙”,
“age”: “37”,
“region”: “河北省保定市清苑县”,
“grade”: [
{
“数学”: 80
},
{
“语文”: 79
},
{
“英语”: 69
}
]
},
“sort”: [
80
]
}
]
}
}

使用_source过滤属性

不显示所有属性

GET xytest/sutdent/_search
{
“_source”: false,
“from”: 0
, “size”: 2
}

结果为：

包含age和name列，不包含grade列。

GET xytest/sutdent/_search
{
“_source”: {
“include”: [“age”,”name”],
“excludes”: [ “grade” ]
},
“from”: 0
, “size”: 2
}

结果：

{
“took”: 1,
“timed_out”: false,
“_shards”: {
“total”: 5,
“successful”: 5,
“failed”: 0
},
“hits”: {
“total”: 6,
“max_score”: 1,
“hits”: [
{
“_index”: “xytest”,
“_type”: “sutdent”,
“_id”: “5”,
“_score”: 1,
“_source”: {
“name”: “范旭”,
“age”: “30”
}
},
{
“_index”: “xytest”,
“_type”: “sutdent”,
“_id”: “2”,
“_score”: 1,
“_source”: {
“name”: “符巧”,
“age”: “26”
}
}
]
}
}