ES常用命令

最新推荐文章于 2022-11-27 10:14:50 发布
最新推荐文章于 2022-11-27 10:14:50 发布
阅读量485 收藏
点赞数
分类专栏： ElasticSearch
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39561762/article/details/107202924
版权

初步检索

_cat

GET _cat/nodes：查看所有节点
GET _cat/health：查看es健康状况
GET _cat/master 查看主节点
GET _cat/indices：查看索引

索引一个文档

PUT http://10.1.100.10:9200/customer/external/1
{
	"name": "John Doe"
}

结果：

{
    "_index": "customer",
    "_type": "external",
    "_id": "1",
    "_version": 2,
    "result": "updated",
    "_shards": {
        "total": 2,
        "successful": 1,
        "failed": 0
    },
    "_seq_no": 1,
    "_primary_term": 1
}

带ID保存，保存多次的话为更新。

POST保存，不带ID操作

http://10.1.100.10:9200/customer/external/
{
	"name": "John Doe"
}

结果：

{
    "_index": "customer",
    "_type": "external",
    "_id": "ixGvLHMBhCErS6Ql1rmD",
    "_version": 1,
    "result": "created",
    "_shards": {
        "total": 2,
        "successful": 1,
        "failed": 0
    },
    "_seq_no": 2,
    "_primary_term": 1
}

ES自动生成一个ID。

POST和PUT不带ID都是新增，带ID就是更新，都是保存更新二合一，PUT与POST区别就是需要带ID。

查询文档

http://10.1.100.10:9200/customer/external/1

{
	"_index": "customer",	//在哪个索引
	"_type": "external",	//在哪个类型
	"_id": "1",				//记录ID
	"_version": 2,			//版本号
	"_seq_no": 1,			//并发控制字段，每次更新都会加1，用来做乐观锁
	"_primary_term": 1,		//同上。主分片重新分配，如重启，会有变化
	"found": true,
	"_source": {			//真正内容
		"name": "John Doe"
	}
}

乐观锁修改

PUT http://10.1.100.10:9200/customer/external/1?if_seq_no=1&if_primary_term=1
{
	"name": "1"
}

第一次执行结果：

{
    "_index": "customer",
    "_type": "external",
    "_id": "1",
    "_version": 3,
    "result": "updated",
    "_shards": {
        "total": 2,
        "successful": 1,
        "failed": 0
    },
    "_seq_no": 3,
    "_primary_term": 1
}

第二次执行结果：

{
    "error": {
        "root_cause": [
            {
                "type": "version_conflict_engine_exception",
                "reason": "[1]: version conflict, required seqNo [1], primary term [1]. current document has seqNo [3] and primary term [1]",
                "index_uuid": "vl1cfQwKRKSj9c4pe5Wglg",
                "shard": "0",
                "index": "customer"
            }
        ],
        "type": "version_conflict_engine_exception",
        "reason": "[1]: version conflict, required seqNo [1], primary term [1]. current document has seqNo [3] and primary term [1]",
        "index_uuid": "vl1cfQwKRKSj9c4pe5Wglg",
        "shard": "0",
        "index": "customer"
    },
    "status": 409
}

更新文档

http://10.1.100.10:9200/customer/external/1/_update
{
	"doc": {
        "name": "6"
    }
}

{
    "_index": "customer",
    "_type": "external",
    "_id": "1",
    "_version": 5,
    "result": "updated",
    "_shards": {
        "total": 2,
        "successful": 1,
        "failed": 0
    },
    "_seq_no": 5,
    "_primary_term": 1
}

第二次执行

{
    "_index": "customer",
    "_type": "external",
    "_id": "1",
    "_version": 4,
    "result": "noop",
    "_shards": {
        "total": 0,
        "successful": 0,
        "failed": 0
    },
    "_seq_no": 4,
    "_primary_term": 1
}

会对比原来数据看是否需要更新，如果不需要更新，则result为noop，版本号等不变，具体对比看上面结果。

POST http://10.1.100.10:9200/customer/external/1
{
    "name": "1"
}

第一次执行

{
    "_index": "customer",
    "_type": "external",
    "_id": "1",
    "_version": 8,
    "result": "updated",
    "_shards": {
        "total": 2,
        "successful": 1,
        "failed": 0
    },
    "_seq_no": 8,
    "_primary_term": 1
}

第二次执行

{
    "_index": "customer",
    "_type": "external",
    "_id": "1",
    "_version": 9,
    "result": "updated",
    "_shards": {
        "total": 2,
        "successful": 1,
        "failed": 0
    },
    "_seq_no": 9,
    "_primary_term": 1
}

两次执行结果_version和_seq_no会增加。

PUT http://10.1.100.10:9200/customer/external/1
{
    "name": "1"
}

第一次执行

{
    "_index": "customer",
    "_type": "external",
    "_id": "1",
    "_version": 10,
    "result": "updated",
    "_shards": {
        "total": 2,
        "successful": 1,
        "failed": 0
    },
    "_seq_no": 10,
    "_primary_term": 1
}

第二次执行

{
    "_index": "customer",
    "_type": "external",
    "_id": "1",
    "_version": 11,
    "result": "updated",
    "_shards": {
        "total": 2,
        "successful": 1,
        "failed": 0
    },
    "_seq_no": 11,
    "_primary_term": 1
}

两次执行结果_version和_seq_no会增加。

得出结论：只有POST携带doc请求的请求才会去检查版本！

增加字段

PUT http://10.1.100.10:9200/customer/external/1
{
    "name": "1",
    "age": 123
}

POST http://10.1.100.10:9200/customer/external/1
{
    "name": "1",
    "age": 123,
    "desc":"sssss"
}

删除

DELETE http://10.1.100.10:9200/customer/external/1

返回结果

{
    "_index": "customer",
    "_type": "external",
    "_id": "1",
    "_version": 16,
    "result": "deleted",
    "_shards": {
        "total": 2,
        "successful": 1,
        "failed": 0
    },
    "_seq_no": 16,
    "_primary_term": 1
}

再次查询

GET http://10.1.100.10:9200/customer/external/1

返回结果

{
    "_index": "customer",
    "_type": "external",
    "_id": "1",
    "found": false
}

删除索引

DELETE http://10.1.100.10:9200/customer

返回结果

{
    "acknowledged": true
}

批量增加

POST /customer/external/_bulk
{"index":{"_id":"1"}}
{"name": "Mike"}
{"index":{"_id":"2"}}
{"name": "Mike"}

结果

#! Deprecation: [types removal] Specifying types in bulk requests is deprecated.
{
  "took" : 672,
  "errors" : false,
  "items" : [
    {
      "index" : {
        "_index" : "customer",
        "_type" : "external",
        "_id" : "1",
        "_version" : 1,
        "result" : "created",
        "_shards" : {
          "total" : 2,
          "successful" : 1,
          "failed" : 0
        },
        "_seq_no" : 0,
        "_primary_term" : 1,
        "status" : 201
      }
    },
    {
      "index" : {
        "_index" : "customer",
        "_type" : "external",
        "_id" : "2",
        "_version" : 1,
        "result" : "created",
        "_shards" : {
          "total" : 2,
          "successful" : 1,
          "failed" : 0
        },
        "_seq_no" : 1,
        "_primary_term" : 1,
        "status" : 201
      }
    }
  ]
}

批量对所有索引进行操作

POST /_bulk
{"delete":{"_index":"website","_type":"blog","_id":"123"}}
{"create":{"_index":"website","_type":"blog","_id":"123"}}
{"title":"My first blog post"}
{"index":{"_index":"website","_type":"blog"}}
{"title":"My second blog post"}
{"update": {"_index":"website", "_type": "blog", "_id": "123"}}
{"doc":{"title":"My update blog post"}}

结果

#! Deprecation: [types removal] Specifying types in bulk requests is deprecated.
{
  "took" : 791,
  "errors" : false,
  "items" : [
    {
      "delete" : {
        "_index" : "website",
        "_type" : "blog",
        "_id" : "123",
        "_version" : 1,
        "result" : "not_found",
        "_shards" : {
          "total" : 2,
          "successful" : 1,
          "failed" : 0
        },
        "_seq_no" : 0,
        "_primary_term" : 1,
        "status" : 404
      }
    },
    {
      "create" : {
        "_index" : "website",
        "_type" : "blog",
        "_id" : "123",
        "_version" : 2,
        "result" : "created",
        "_shards" : {
          "total" : 2,
          "successful" : 1,
          "failed" : 0
        },
        "_seq_no" : 1,
        "_primary_term" : 1,
        "status" : 201
      }
    },
    {
      "index" : {
        "_index" : "website",
        "_type" : "blog",
        "_id" : "0xFxLXMBhCErS6QlDMua",
        "_version" : 1,
        "result" : "created",
        "_shards" : {
          "total" : 2,
          "successful" : 1,
          "failed" : 0
        },
        "_seq_no" : 2,
        "_primary_term" : 1,
        "status" : 201
      }
    },
    {
      "update" : {
        "_index" : "website",
        "_type" : "blog",
        "_id" : "123",
        "_version" : 3,
        "result" : "updated",
        "_shards" : {
          "total" : 2,
          "successful" : 1,
          "failed" : 0
        },
        "_seq_no" : 3,
        "_primary_term" : 1,
        "status" : 200
      }
    }
  ]
}

可以看出来进行了四次操作，具体分析看上面结果。

样例数据

https://github.com/elastic/elasticsearch/blob/master/docs/src/test/resources/accounts.json

通过命令将样例数据导入到es

POST /bank/_bulk

进阶检索

REST URI:
	GET /bank/_search?q=*&sort=account_number:asc
REST BOdy:
	GET bank/_search
	{
	  "query": {
	    "match_all": {}
	  },
	  "sort": [
	    {
	      "account_number": "asc"
	    }
	  ]
	}


GET bank/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {
      "account_number": "asc"
    }
  ]
}


GET bank/_search
{
  "query": {
    "match": {
      "account_number": "3"
    }
  }
}

#全文检索，会对检索条件进行分词
GET bank/_search
{
  "query": {
    "match": {
      "address": "Wilson Street"
    }
  }
}

#短语匹配
GET bank/_search
{
  "query": {
    "match_phrase": {
      "address": "Wilson Street"
    }
  }
}


#多字段匹配，会进行分词操作
GET bank/_search
{
  "query": {
    "multi_match": {
      "query": "mill Road",
      "fields": ["address", "city"]
    }
  }
}


#复杂查询
GET bank/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "gender": "m"
          }
        }
      ], "must_not": [
        {"match": {
          "age": "39"
        }}
      ],
      "should": [
        {"match": {
          "lastname": "Duke" 
        }}
      ]
    }
  }
}

GET bank/_search
{
  "query": {
    "bool": {
      "must": [
        {"range": {
          "age": {
            "gte": 10,
            "lte": 20
          }
        }}
      ]
    }
  }
}


#filter不会计算相关性得分
GET bank/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "range": {
            "age": {
              "gte": 10,
              "lte": 20
            }
          }
        }
      ]
    }
  }
}


#精确匹配term
GET bank/_search
{
  "query": {
    "term": {
      "age": {
        "value": "20"
      }
    }
  }
}


#精准匹配keyword
GET bank/_search
{
  "query": {
    "match": {
      "address.keyword": "741 McDonald"
    }
  }
}

GET bank/_search
{
  "query": {
    "match": {
      "address": "741 McDonald"
    }
  }
}

聚合


##搜索address中包含mill的所有人的年龄分布和平均年龄
GET bank/_search
{
  "query": {
    "match": {
      "address": "mill"
    }
  },
  "aggs": {
    "ageAgg": {
      "terms": {
        "field": "age",
        "size": 10
      }
    },
    "ageAvg":{
      "avg": {
        "field": "age"
      }
    },
    "balanceAge":{
      "avg": {
        "field": "age"
      }
    }
  },
  "size": 0
}


##按照年龄聚合，并且请求这些年龄段的这些人的平均薪资
GET bank/_search
{
  "query": {
    "match_all": {}
  },
  "aggs": {
    "ageAgg": {
      "terms": {
        "field": "age",
        "size": 100
      },
      "aggs": {
        "ageAvg": {
          "avg": {
            "field": "balance"
          }
        }
      }
    }
  }
}

#查询所有年龄分布，并且这些年龄段中F和M的平均薪资及这个年龄段的平均薪资
GET bank/_search
{
  "query": {
    "match_all": {}
  },
  "aggs": {
    "ageAvg": {
      "terms": {
        "field": "age",
        "size": 100
      },
      "aggs": {
        "genderaAgg": {
          "terms": {
            "field": "gender.keyword",
            "size": 100
          },
          "aggs": {
            "banlanceAvg": {
              "avg": {
                "field": "balance"
              }
            }
          }
        },
        "ageBalanceAvg" :{
          "avg": {
            "field": "balance"
          }
        }
      }
    }
  },
  "size": 0
}

Mapping

#查看映射
GET myindex/_mapping


#创建索引
PUT /myindex
{
  "mappings": {
    "properties": {
      "age" :{"type": "integer"},
      "email":{"type": "keyword"},
      "name":{"type": "text"}
    }
  }
}

#添加新字段
PUT myindex/_mapping
{
  "properties": {
      "employ_id":{"type":"keyword"}
    }
  
}

#修改映射，需要先将数据迁移后，再将数据导入过去
POST _reindex
{
  "source": {"index": "bank"},
  "dest": {"index": "new_bank"}
}

#有type导数据
POST _reindex
{
  "source": {"index": "bank","type": "account"},
  "dest": {"index": "new_bank"}
}

##分词器安装

下载 wget https://github.com/medcl/elasticsearch-analysis-ik/releases
并解压到plugins/ik目录
bin/elasticsearch-plugin list
重启即可

测试中文分词器

#中文分词器
GET /_analyze
{
  "analyzer": "ik_smart",
  "text": "我是中国人"
}

GET /_analyze
{
  "analyzer": "ik_max_word",
  "text": "我是中国人"
}

自定义分词

奔向大数据的凡小王
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
ES常用命令基础
KingWeiGG的博客
06-23 3110
ES常用命令及相关实例 ES常用命令 命令 含义 PUT 增加/跟新 UPDATE 改变 DELET 删除 GET 查询 POST 查询/修改 HEAD 改变/删除 ES数据模型 ElasticSearch 含义 Index 索引，由多个Document组成 Type 索引类型，6.x中仅支持一个，以后将逐渐被移除 Document 文档，由多个Field组成 Field 字段，包括字段名与字段值 注：一个索引只能存一个类型
ES常用操作命令
最新发布
子笙的博客
04-29 325
es版本为6.7.2，kibana版本6.7.2。
Es基本命令
weixin_45080962的博客
11-21 415
1.先暂停集群的shard自动均衡。 curl -XPUT http://10.24.2.35:8200/_cluster/settings -d’{“transient”:{“cluster.routing.allocation.enable”:“none”}}’ 2.重启启动集群的shard均衡 curl -XPUT http://10.24.2.35:8200/_cluster/settings -d’{“transient”:{“cluster.routing.allocation.enable”:
ES基础命令(参照mysql)
wwwwwww31311的博客
08-31 1863
一 基础ES命令 1、http://localhost:9200 先当于查看mysql数据库本地连接信息 2、向ES 服务器发 PUT 请求 http://127.0.0.1:9200/shopping；幂等性意味着不会重复发送,我们可以把一个索引shopping抽象成一个数据库中唯一的一张表IndexTable；这里相当于做创建数据库的操作 3、向 ES 服务器发 GET 请求 ： http://127.0.0.1:9200/_cat/indices?v 查看索引下所有请求，相当于mysql下查看一个
elasticsearch常用命令脚本
11-26
后端工程师开发时经常需要操作es，要是每次都去找相关命令就太麻烦了。这里提供了常用的es操作脚本，比如删除单个索引、删除多个索引、创建索引、查看全部索引、查看粉刺等等，以及深分页查询脚本
elasticsearch常用命令学习记录.log
12-28
基础crud，分组，排序，聚合分析,基础crud，分组，排序，聚合分析,基础crud，分组，排序，聚合分析,基础crud，分组，排序，聚合分析,基础crud，分组，排序，聚合分析,基础crud，分组，排序，聚合分析,基础crud，分组...
ES7.6常用命令.txt
04-29
包含ES7.6常用插入，删除，增加，批量增加，创建索引
ffmpeg工具的常用命令
06-16
ffmpeg 工具的常用命令 ffmpeg 是一种非常强大的音频、视频处理工具，使用方式如下：ffmpeg [options] [[infile options] -i infile]... {[outfile options] outfile}...。下面将对 ffmpeg 工具的常用命令进行详细...
es查看集群状态常用命令.md
10-29
es查看集群状态常用命令
ES常用命令-------------随笔
long的博客
06-26 909
es常用命令 shrink reindex
ElasticSearch入门
AngleWang
11-27 2910
ElasticSearch入门
ES 7.9.0 初探之常见操作-match
圆师傅的博客
11-08 1195
文章目录1.前缀查询（prefix）2. 短语匹配（match_phrase）3.短语前缀匹配查询(match_phrase_prefix)4.多重匹配查询（Multi-match query）5.是否匹配前缀（match_bool_prefix） 上一篇我们使用ES进行了简单的CURD操作，今天来进行一点简单的匹配查询的操作。 首先来看一下我编了哪些数据： GET yytest/_search 得到的数据有 { "took" : 0, "timed_out" : false, "_shard
3、ES常用命令
weixin_43046724的博客
12-11 1464
一、ES常用命令 1、查询命令 1.1、查看集群健康状态： curl -k -uuser:passwordhttps://127.0.0.1:9200/_cluster/health?v 查看集群的健康信息，主要是索引相关信息 1.2、查看节点状态： curl -k -uuser:passwordhttps://127.0.0.1:9200/_nodes/stats?v 上面的命...
01_Es
qq_45757978的博客
01-24 1842
ES基础，参考尚硅谷视频
（二）elasticsearch初步探索
bigbear776的博客
11-26 228
ES作为一个检索、存储、分析的引擎，其将所有的操作都以rest api的方式实现 1._cat查询ES的信息 http://192.168.254.128:9200/_cat/nodes 查看所有节点 http://192.168.254.128:9200/_cat/health 查看健康状况 http://192.168.254.128:9200/_cat/master 查看主节点 http://192.168.254.128:9200/_c.
elasticsearch客户端常用命令有哪些？
04-24
一些常用的elasticsearch客户端命令包括： 1. GET /_cluster/health：检查集群健康状况 2. PUT /my_index：创建一个新的索引 3. POST /my_index/_doc：向索引中添加一个新的文档 4. GET /my_index/_search：执行一...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值