1
2
3
4
5
6
| # create index
curl -X PUT http://192.168.0.10:20000/test6 --header "Content-Type: application/json" -d index.json
cat index.json
# delete index
curl -X DELETE http://192.168.0.10:20000/test6
|
1.单字段查询相对简单,批量查询相当于in,范围查询相当于between and
2.should,must,must_not等可用于or and操作
3.bool里面嵌套should,must,must_not
4.bool里面should,must之类不能再嵌套should,must,而是要用bool进行嵌套should,must
5.精准搜索控制,是es特有,也是搜索引擎特性
Bool查询包括四种子句，
我这里只介绍下must和filter两种子句，因为是我们今天要讲的重点。其它的可以自行查询官方文档。
- must， 返回的文档必须满足must子句的条件，并且参与计算分值
- filter， 返回的文档必须满足filter子句的条件。但是跟Must不一样的是，不会计算分值， 并且可以使用缓存
在不需要相关性算分的查询场景，尽量使用filter context可以让你的查询更加高效。
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
| //单字段条件查询(term)
select * from user where name="wxx"
GET index3/_search
{
"query": {
"term": {
"name": {
"value": "wxx"
}
}
}
}
// match
select * from user where address="抚州"
GET index3/_search
{
"query": {
"match": {
"address": {
"value": "抚州"
}
}
}
}
// terms
select * from user where name in ("wxx","zhangxianbo")
GET index3/_search
{
"query": {
"terms": {
"name": [
"zhangxianbo",
"wxx"
]
}
}
}
// range
select * from user where age between 10 and 26
GET user/_search
{
"query": {
"range": {
"age": {
"gte": 10,
"lte": 26
}
}
}
}
// or
select * from user where name="wxx" or age =26
GET index3/_search
{
"query": {
"bool": {
"should": [
{
"term": {
"name": {
"value": "wxx"
}
}
},
{
"term": {
"age": {
"value": "26"
}
}
}
]
}
}
}
//and
select * from user where name="liujing" and age =18
GET user/_search
{
"query": {
"bool": {
"must": [
{
"term": {
"name": {
"value": "liujing"
}
}
},
{
"term": {
"age": {
"value": "18"
}
}
}
]
}
}
}
// and-or
select * from user where (sex=wman) or (name=wangjian and age=26)
GET index3/_search
{
"query": {
"bool": {
"should": [
{
"term": {
"sex": {
"value": "wman"
}
}
},
{
"bool": {
"must": [
{
"term": {
"name": {
"value": "wangjian"
}
}
},
{
"term": {
"age": {
"value": "26"
}
}
}
]
}
}
]
}
}
}
select * from user where (sex=man) and (name=wangjian or name=zhangxianbo or age=18)
2.es查询
GET index3/_search
{
"query": {
"bool": {
"must": [
{
"term": {
"sex": {
"value": "man"
}
}
},{
"bool": {
"should": [
{
"term": {
"name": {
"value": "wangjian"
}
}
},
{
"term": {
"name": {
"value": "zhangxianbo"
}
}
},
{
"term": {
"age": {
"value": "18"
}
}
}
]
}
}
]
}
}
}
|
- https://juejin.cn/post/6998403625982623780
- https://segmentfault.com/a/1190000022611664
- Elasticsearch DSL查询常用语法，es构建复杂查询条件 - 掘金
- https://www.jianshu.com/p/6333940621ec