说明
Elasticsearch版本：6.3.2
索引
创建索引
1
| PUT /items?master_timeout=30s&timeout=30s
|
body
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
| {
"settings": {},
"mappings": {
"_doc": {
"_doc": {
"properties": {
"category1_id": {
"type": "long"
},
"category2_id": {
"type": "long"
},
"create_date": {
"format": "epoch_second",
"type": "date"
},
"item_unique_id": {
"type": "long"
},
"status": {
"type": "integer"
}
}
}
}
},
"aliases": {}
}
|
修改索引
1
| PUT /items/_mapping/_doc?master_timeout=30s&timeout=30s
|
body
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| {
"_doc": {
"properties": {
"brand_id": {
"type": "long"
},
"category1_id": {
"type": "long"
},
"category2_id": {
"type": "long"
},
"common_flag": {
"type": "integer"
}
}
}
}
|
删除索引
索引别名
通过别名不停机修改Mapping结构
https://841809077.github.io/2019/11/29/index-alias-and-modify-index-mapping.html
查询
查询全部
1
2
3
4
5
6
| GET /items/_search
{
"query": {
"match_all": {}
}
}
|
items:索引名称，支持正则表达式、多个 index 以逗号分隔
查询时创建新字段
1
2
3
4
5
6
7
8
9
10
11
12
13
14
| GET /items/_search
{
"query": {
"match_all":{}
},
"script_fields": {
"field_name": {
"script": {
"lang": "painless",
"source":"doc['category0.id'].value+'-'+doc['category1.id'].value+'-'+doc['category2.id'].value"
}
}
}
}
|
查询时通过脚本生成新的字段
Script Query
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| GET items/_search
{
"query": {
"bool": {
"filter": [
{
"script": {
"script": {
"source": "if(doc['cart_uv'].value == 0){return false;}doc['detail_times'].value/doc['cart_uv'].value > 0",
"lang": "painless"
}
}
}
]
}
}
}
|
统计
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
| GET items/_search
{
"query": {
"match_all": {}
},
"size": 10,
"aggs": {
"aaa":{
"range": {
"field": "sale_price",
"ranges": [
{
"from": 0,
"to": 1000
}
]
}
},
"bbb":{
"terms": {
"field": "category0.id",
"size": 5
}
},
"ccc":{
"terms": {
"field": "category1.id",
"size": 5
},
"aggs": {
"total_price": {
"sum": {
"field": "sale_price"
}
}
}
}
}
}
|
analyze
1
2
3
4
5
| GET _analyze
{
"analyzer": "stop",
"text": "2 running Quick brown-foxes leap over lazy dogs in the summer evening."
}
|
1
2
3
4
5
| GET index_name/_analyze
{
"field": "url_path",
"text": "/a/b/c"
}
|
explain
1
2
3
4
5
6
7
8
| GET items/doc/BTKJzWwBgRpDanj3GP9G/_explain
{
"query": {
"match":{
"tag_name":"苹果"
}
}
}
|
如何做 reindex
参考：
http://bk.poph163.com/2018/07/04/elk%E7%94%B1%E6%B5%85%E5%85%A5%E6%B7%B1/