ElasticSearch ES 常用语句

时间 2020/7/30 21:28:07 加载中...

新建索引库

  1. PUT /nv_normal_value
  2. {
  3. "settings": {
  4. "number_of_shards" : 1,
  5. "number_of_replicas" : 0
  6. },
  7. "mappings":{
  8. "properties":{
  9. "Id":{"type":"long"},
  10. "CreateUser":{"type":"keyword"},
  11. "CreateTime":{"type":"date"},
  12. "UpdateUser":{"type":"keyword"},
  13. "UpdateTime":{"type":"date"},
  14. "NormalName":{"type":"text"},
  15. "NormalCode":{"type":"keyword"},
  16. "NormalNameCn":{"type":"text"},
  17. "NormalDescribe":{"type":"text"},
  18. "NormalDescribeCn":{"type":"text"},
  19. "StandardID":{"type":"long"},
  20. "StandardName":{"type":"keyword"},
  21. "LableName":{"type":"keyword"},
  22. "EsTime":{"type":"date"}
  23. }
  24. }
  25. }

head 下创建

查询记录

查看所有索引库

  1. GET /_cat/indices?v

根据 id 查询记录

  1. GET /customer/_doc/1

新增记录

  1. PUT /customer/_doc/1
  2. {
  3. "name":"john tom"
  4. }
  1. POST /nv_normal_value/_doc/1
  2. {
  3. "Id": 1,
  4. "CreateUser": "sa",
  5. "CreateTime": "2020-06-19T06:29:04.192Z",
  6. "UpdateUser": "sa",
  7. "UpdateTime": "2020-06-19T06:29:04.192Z",
  8. "NormalName": "中国",
  9. "NormalCode": "",
  10. "NormalNameCn": "",
  11. "NormalDescribe": "",
  12. "NormalDescribeCn": "",
  13. "StandardID": 1,
  14. "StandardName": "国家规范表",
  15. "LableName": "",
  16. "EsTime": "2020-06-19T06:29:04.192Z"
  17. }

修改记录

nv_normal_value 是索引库名称,559 是 id。
将 id 是 559 的字段 NormalNameCn 的值修改为 abc

  1. POST nv_normal_value/_doc/559/_update
  2. {
  3. "doc": {
  4. "NormalNameCn":"abc"
  5. }
  6. }

删除记录(删除文档)

  1. DELETE /my-index-000001/_doc/1

删除索引库

  1. DELETE /my-index-000001

根据查询条件删除文档

  1. POST /my-index-000001/_delete_by_query
  2. {
  3. "query": {
  4. "match": {
  5. "user.id": "elkbee"
  6. }
  7. }
  8. }

删除所有的记录

  1. POST /my-index-000001/_delete_by_query
  2. {
  3. "query": { "match_all": {} }
  4. }
扫码分享
版权说明
作者:SQBER
文章来源:http://www.sqber.com/articles/elasticsearch-es-sql.html
本文版权归作者所有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。