首页 文章 精选 留言 我的

Elasticsearch常用操作API

2017-11-14 728

1. 查询所有的索引

1
2
3
4
[root@Server01 cx] # curl '10.0.0.5:9200/_cat/indices?v'
health status index    pri rep docs.count docs.deleted store.size pri.store.size 
yellow  open    customer   5   1          2            0      6.6kb          6.6kb 
yellow  open    bank       5   1       1000            0    442.1kb        442.1kb


2. 查询bank表中的所有数据

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
195
[root@Server01 cx] # curl '10.0.0.5:9200/bank/_search?q=*&pretty'
{
   "took"  : 41,
   "timed_out"  :  false ,
   "_shards"  : {
     "total"  : 5,
     "successful"  : 5,
     "failed"  : 0
   },
   "hits"  : {
     "total"  : 1000,
     "max_score"  : 1.0,
     "hits"  : [ {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "25" ,
       "_score"  : 1.0,
       "_source"  : {
         "account_number"  : 25,
         "balance"  : 40540,
         "firstname"  :  "Virginia" ,
         "lastname"  :  "Ayala" ,
         "age"  : 39,
         "gender"  :  "F" ,
         "address"  :  "171 Putnam Avenue" ,
         "employer"  :  "Filodyne" ,
         "email"  :  "virginiaayala@filodyne.com" ,
         "city"  :  "Nicholson" ,
         "state"  :  "PA"
       }
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "44" ,
       "_score"  : 1.0,
       "_source"  : {
         "account_number"  : 44,
         "balance"  : 34487,
         "firstname"  :  "Aurelia" ,
         "lastname"  :  "Harding" ,
         "age"  : 37,
         "gender"  :  "M" ,
         "address"  :  "502 Baycliff Terrace" ,
         "employer"  :  "Orbalix" ,
         "email"  :  "aureliaharding@orbalix.com" ,
         "city"  :  "Yardville" ,
         "state"  :  "DE"
       }
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "99" ,
       "_score"  : 1.0,
       "_source"  : {
         "account_number"  : 99,
         "balance"  : 47159,
         "firstname"  :  "Ratliff" ,
         "lastname"  :  "Heath" ,
         "age"  : 39,
         "gender"  :  "F" ,
         "address"  :  "806 Rockwell Place" ,
         "employer"  :  "Zappix" ,
         "email"  :  "ratliffheath@zappix.com" ,
         "city"  :  "Shaft" ,
         "state"  :  "ND"
       }
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "119" ,
       "_score"  : 1.0,
       "_source"  : {
         "account_number"  : 119,
         "balance"  : 49222,
         "firstname"  :  "Laverne" ,
         "lastname"  :  "Johnson" ,
         "age"  : 28,
         "gender"  :  "F" ,
         "address"  :  "302 Howard Place" ,
         "employer"  :  "Senmei" ,
         "email"  :  "lavernejohnson@senmei.com" ,
         "city"  :  "Herlong" ,
         "state"  :  "DC"
       }
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "126" ,
       "_score"  : 1.0,
       "_source"  : {
         "account_number"  : 126,
         "balance"  : 3607,
         "firstname"  :  "Effie" ,
         "lastname"  :  "Gates" ,
         "age"  : 39,
         "gender"  :  "F" ,
         "address"  :  "620 National Drive" ,
         "employer"  :  "Digitalus" ,
         "email"  :  "effiegates@digitalus.com" ,
         "city"  :  "Blodgett" ,
         "state"  :  "MD"
       }
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "145" ,
       "_score"  : 1.0,
       "_source"  : {
         "account_number"  : 145,
         "balance"  : 47406,
         "firstname"  :  "Rowena" ,
         "lastname"  :  "Wilkinson" ,
         "age"  : 32,
         "gender"  :  "M" ,
         "address"  :  "891 Elton Street" ,
         "employer"  :  "Asimiline" ,
         "email"  :  "rowenawilkinson@asimiline.com" ,
         "city"  :  "Ripley" ,
         "state"  :  "NH"
       }
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "183" ,
       "_score"  : 1.0,
       "_source"  : {
         "account_number"  : 183,
         "balance"  : 14223,
         "firstname"  :  "Hudson" ,
         "lastname"  :  "English" ,
         "age"  : 26,
         "gender"  :  "F" ,
         "address"  :  "823 Herkimer Place" ,
         "employer"  :  "Xinware" ,
         "email"  :  "hudsonenglish@xinware.com" ,
         "city"  :  "Robbins" ,
         "state"  :  "ND"
       }
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "190" ,
       "_score"  : 1.0,
       "_source"  : {
         "account_number"  : 190,
         "balance"  : 3150,
         "firstname"  :  "Blake" ,
         "lastname"  :  "Davidson" ,
         "age"  : 30,
         "gender"  :  "F" ,
         "address"  :  "636 Diamond Street" ,
         "employer"  :  "Quantasis" ,
         "email"  :  "blakedavidson@quantasis.com" ,
         "city"  :  "Crumpler" ,
         "state"  :  "KY"
       }
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "208" ,
       "_score"  : 1.0,
       "_source"  : {
         "account_number"  : 208,
         "balance"  : 40760,
         "firstname"  :  "Garcia" ,
         "lastname"  :  "Hess" ,
         "age"  : 26,
         "gender"  :  "F" ,
         "address"  :  "810 Nostrand Avenue" ,
         "employer"  :  "Quiltigen" ,
         "email"  :  "garciahess@quiltigen.com" ,
         "city"  :  "Brooktrails" ,
         "state"  :  "GA"
       }
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "222" ,
       "_score"  : 1.0,
       "_source"  : {
         "account_number"  : 222,
         "balance"  : 14764,
         "firstname"  :  "Rachelle" ,
         "lastname"  :  "Rice" ,
         "age"  : 36,
         "gender"  :  "M" ,
         "address"  :  "333 Narrows Avenue" ,
         "employer"  :  "Enaut" ,
         "email"  :  "rachellerice@enaut.com" ,
         "city"  :  "Wright" ,
         "state"  :  "AZ"
       }
     } ]
   }
}

  • took –  Elasticsearch执行查询的毫秒响应时间

  • timed_out – 是否超时

  • _shards – 查询过的分片，包含成功的分片和失败的分片

  • hits – 搜索结果

  • hits.total – 符合搜索结果的记录数

  • hits.hits – 默认显示前10条搜索结果

  • _score and max_score - ignore these fields for now


3. 另外一种查询全部结果的方法

1
2
3
4
curl -XPOST  '10.0.0.5:9200/bank/_search?pretty'  -d '
{
   "query" : {  "match_all" : {} }
}'


4. 分页排序的检索例子

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
[root@Server01 cx] # curl -XPOST '10.0.0.5:9200/bank/_search?pretty' -d '
{
   "query" : {  "match_all" : {} },
   "from" : 10,
   "size" : 3,
   "sort" : {  "balance" : {  "order" :  "desc"  } }
}'
{
   "took"  : 8,
   "timed_out"  :  false ,
   "_shards"  : {
     "total"  : 5,
     "successful"  : 5,
     "failed"  : 0
   },
   "hits"  : {
     "total"  : 1000,
     "max_score"  : null,
     "hits"  : [ {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "255" ,
       "_score"  : null,
       "_source"  : {
         "account_number"  : 255,
         "balance"  : 49339,
         "firstname"  :  "Iva" ,
         "lastname"  :  "Rivers" ,
         "age"  : 38,
         "gender"  :  "M" ,
         "address"  :  "470 Rost Place" ,
         "employer"  :  "Mantrix" ,
         "email"  :  "ivarivers@mantrix.com" ,
         "city"  :  "Disautel" ,
         "state"  :  "MD"
       },
       "sort"  : [ 49339 ]
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "524" ,
       "_score"  : null,
       "_source"  : {
         "account_number"  : 524,
         "balance"  : 49334,
         "firstname"  :  "Salas" ,
         "lastname"  :  "Farley" ,
         "age"  : 30,
         "gender"  :  "F" ,
         "address"  :  "499 Trucklemans Lane" ,
         "employer"  :  "Xumonk" ,
         "email"  :  "salasfarley@xumonk.com" ,
         "city"  :  "Noxen" ,
         "state"  :  "AL"
       },
       "sort"  : [ 49334 ]
     }, {
       "_index"  :  "bank" ,
       "_type"  :  "account" ,
       "_id"  :  "751" ,
       "_score"  : null,
       "_source"  : {
         "account_number"  : 751,
         "balance"  : 49252,
         "firstname"  :  "Patrick" ,
         "lastname"  :  "Osborne" ,
         "age"  : 23,
         "gender"  :  "M" ,
         "address"  :  "915 Prospect Avenue" ,
         "employer"  :  "Gynko" ,
         "email"  :  "patrickosborne@gynko.com" ,
         "city"  :  "Takilma" ,
         "state"  :  "MO"
       },
       "sort"  : [ 49252 ]
     } ]
   }
}


5. 添加文档，如果id存在则更新文档

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
[root@Server01 data] # curl -XPUT '10.0.0.5:9200/customer/external/1?pretty' -d '
> { "name" : "John Doe" }'
{
   "_index"  :  "customer" ,
   "_type"  :  "external" ,
   "_id"  :  "1" ,
   "_version"  : 1,
   "_shards"  : {
     "total"  : 2,
     "successful"  : 1,
     "failed"  : 0
   },
   "created"  :  true
}
[root@Server01 data] # curl -XPUT '10.0.0.5:9200/customer/external/1?pretty' -d '
{ "name" : "Jane Doe" }'
{
   "_index"  :  "customer" ,
   "_type"  :  "external" ,
   "_id"  :  "1" ,
   "_version"  : 2,
   "_shards"  : {
     "total"  : 2,
     "successful"  : 1,
     "failed"  : 0
   },
   "created"  :  false
}


6. 不指定Id时创建文档，可以发现自动生成一个随机Id

1
2
3
4
5
6
7
8
9
10
11
12
13
[root@Server01 data] # curl -XPOST '10.0.0.5:9200/customer/external?pretty' -d '{"name": "Jane Doe"}'
{
   "_index"  :  "customer" ,
   "_type"  :  "external" ,
   "_id"  :  "AVTh53KZ4Pj5B2ZQ2voK" ,
   "_version"  : 1,
   "_shards"  : {
     "total"  : 2,
     "successful"  : 1,
     "failed"  : 0
   },
   "created"  :  true
}


7. 修改文档

1
2
3
4
5
6
7
8
9
10
11
12
[root@Server01 data] # curl -XPOST '10.0.0.5:9200/customer/external/2/_update?pretty' -d '{"doc":{"name":"favourite boy","age":18}}'
{
   "_index"  :  "customer" ,
   "_type"  :  "external" ,
   "_id"  :  "2" ,
   "_version"  : 3,
   "_shards"  : {
     "total"  : 2,
     "successful"  : 1,
     "failed"  : 0
   }
}


8. 在开启javascript后，可以使用JS脚本更新文档

1
[root@Server01 data] # curl -XPOST '10.0.0.5:9200/customer/external/2/_update?pretty' -d '{"script":"ctx._source.age+=5"}'


9. 删除文档

1
2
3
4
5
6
7
8
9
10
11
12
13
[root@Server01 data] # curl -XDELETE '10.0.0.5:9200/customer/external/1?pretty'
{
   "found"  :  true ,
   "_index"  :  "customer" ,
   "_type"  :  "external" ,
   "_id"  :  "1" ,
   "_version"  : 4,
   "_shards"  : {
     "total"  : 2,
     "successful"  : 1,
     "failed"  : 0
   }
}


10. 批量更新文档

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
[root@Server01 data] # curl -XPOST '10.0.0.5:9200/customer/external/_bulk?pretty' -d '
{ "index" :{ "_id" : "1" }}
{ "name" :  "John Doe"  }
{ "index" :{ "_id" : "2" }}
{ "name" :  "Jane Doe"  }'
{
   "took"  : 33,
   "errors"  :  false ,
   "items"  : [ {
     "index"  : {
       "_index"  :  "customer" ,
       "_type"  :  "external" ,
       "_id"  :  "1" ,
       "_version"  : 3,
       "_shards"  : {
         "total"  : 2,
         "successful"  : 1,
         "failed"  : 0
       },
       "status"  : 200
     }
   } ]
}
[root@Server01 data] # curl -XPOST '10.0.0.5:9200/customer/external/_bulk?pretty' -d '
> { "update" :{ "_id" : "1" }}
> { "doc" : {  "name" :  "John Doe becomes Jane Doe"  } }
> { "delete" :{ "_id" : "2" }}
> '
{
   "took"  : 34,
   "errors"  :  false ,
   "items"  : [ {
     "update"  : {
       "_index"  :  "customer" ,
       "_type"  :  "external" ,
       "_id"  :  "1" ,
       "_version"  : 4,
       "_shards"  : {
         "total"  : 2,
         "successful"  : 1,
         "failed"  : 0
       },
       "status"  : 200
     }
   }, {
     "delete"  : {
       "_index"  :  "customer" ,
       "_type"  :  "external" ,
       "_id"  :  "2" ,
       "_version"  : 5,
       "_shards"  : {
         "total"  : 2,
         "successful"  : 1,
         "failed"  : 0
       },
       "status"  : 200,
       "found"  :  true
     }
   } ]
}





本文转自 genuinecx 51CTO博客，原文链接：http://blog.51cto.com/favccxx/1793613，如需转载请自行联系原作者
上一篇 下一篇
优秀的个人博客,低调大师

微信关注我们

原文链接：https://yq.aliyun.com/articles/413839

转载内容版权归作者及来源网站所有！

低调大师中文资讯倾力打造互联网数据资讯、行业资源、电子商务、移动互联网、网络营销平台。持续更新报道IT业界、互联网、市场资讯、驱动更新,是最及时权威的产业资讯及硬件资讯报道平台。

ES doc_values的来源，field data——就是doc->terms的正向索引啊，不过它是在查询阶段通过读取倒排索引loadi...

Support in the Wild: My Biggest Elasticsearch Problem at Scale Java Heap Pressure Elasticsearch has so many wildly different use cases that I could not write a reasonably short blog post describing what can and cannot consume memory. However, there is one thing that constantly stands out above all of the other concerns that you might have while running an Elasticsearch cluster at scale. For the users that I help,fielddatais the problem that is the most likely to cause their cluster's instability...
2017-11-15
518
上一篇

How to reduce Index size on disk?减少ES索引大小的一些小手段

ES索引文件瘦身总结如下： 原始数据： （1）学习splunk，原始data存big string （2）原始文件还可以再度压缩 倒排索引： （1）去掉不必要的倒排索引信息：例如文件位置倒排、_source和field store选择之一 （2）合并倒排文件，去掉一些冗余的小文件 （3）原始数据big string存储后负责ES聚合功能的doc_values去掉 （4）其他方面：倒排列表数据结构是skiplist本质是空间换时间，可考虑用有序数组存储。 Strange that I haven't receive any suggestion on my query anyways following are some steps which I performed to reduce index size .Hope it will help someone .Please feel free to add more in case I miss something . 1)Delete unnecessary fields(or do not index unwanted fi...
2017-11-15
603
下一篇

相关文章

发表评论

资源下载

更多资源
优质分享App

优质分享App

近一个月的开发和优化，本站点的第一个app全新上线。该app采用极致压缩，本体才4.36MB。系统里面做了大量数据访问、缓存优化。方便用户在手机上查看文章。后续会推出HarmonyOS的适配版本。

时间: 2025-12-03 大小: 4.36MB 下载: 23次
Mario

Mario

马里奥是站在游戏界顶峰的超人气多面角色。马里奥靠吃蘑菇成长，特征是大鼻子、头戴帽子、身穿背带裤，还留着胡子。与他的双胞胎兄弟路易基一起，长年担任任天堂的招牌角色。

时间: 2025-12-12 大小: 211.28KB 下载: 54次
Rocky Linux

Rocky Linux

Rocky Linux（中文名：洛基）是由Gregory Kurtzer于2020年12月发起的企业级Linux发行版，作为CentOS稳定版停止维护后与RHEL（Red Hat Enterprise Linux）完全兼容的开源替代方案，由社区拥有并管理，支持x86_64、aarch64等架构。其通过重新编译RHEL源代码提供长期稳定性，采用模块化包装和SELinux安全架构，默认包含GNOME桌面环境及XFS文件系统，支持十年生命周期更新。

时间: 2026-01-03 大小: 1.42GB 下载: 2次
Sublime Text

Sublime Text

Sublime Text具有漂亮的用户界面和强大的功能，例如代码缩略图，Python的插件，代码段等。还可自定义键绑定，菜单和工具栏。Sublime Text 的主要功能包括：拼写检查，书签，完整的 Python API ， Goto 功能，即时项目切换，多选择，多窗口等等。Sublime Text 是一个跨平台的编辑器，同时支持Windows、Linux、Mac OS X等操作系统。

时间: 2025-12-03 大小: 9.84MB 下载: 39次
手机查看

扫码在手机上查看文章

扫描二维码，手机阅读更方便

热门标签
Rocky SpringBoot4 Docker DeepSeek SpringCloud Service Mesh Kubernetes Redis Gemini3 HarmonyOS6 Jdk25 Nacos3 OpenAi

欢迎您来访！

登录后，您将获得更多功能！
热门文章
联系我们

有任何问题或合作意向欢迎联系我们

Email: 99873273@qq.com

QQ: 99873273

用户登录
用户注册