# 执行sql查询，不支持数组，嵌套
    POST /_sql?format=txt
    {
    "query": "SELECT id FROM cnwy_job_test_index_alias where corp.id = 1"
    }
    
    # 翻译成DSL
    POST /_sql/translate
    {
    "query": "SELECT * FROM cnwy_job_pre_index_alias where corp.id = 1"
    }

    # 批量新增字段并赋予初始值
    POST /prod-ig_zues_db_ig_zues-talent-v2/_update_by_query
    {
        "script":{
            "lang":"painless",
            "inline":"if(ctx._source.ownerUpdateTime==null){ctx._source.ownerUpdateTime= ctx._source.createTime}"
        }
    }
    
    # 加字段
    PUT /prod-hongzhou-ig_zues_db_ig_zues-talent-v2/_mapping/talent
    {
      "properties": {
        "ownerUpdateTimeDate": {
          "type": "date"
        }
      }
    }
    
    # 保存
    PUT /wang-indexname/wang-indextype/id2
    {
        "name" : "wang",
        "password" :  "123",
        "age" :        100,
        "text" :      "测试wang ",
        "list": [ "a", "b" ]
    }
    
    # 保存 - 版本号处理冲突，当并发更新数据时防止更新丢失。
    PUT /wang-indexname/wang-indextype/id2?version=1
    {
        "name" : "zhang",
        "password" :  "123",
        "age" :        100,
        "text" :      "测试zhang ",
        "list": [ "c", "D" ]
    }
    
    # 保存 - 批量
    POST /wang-indexname/wang-indextype/_bulk
    { "index": { "_id": 1 }}
    { "price" : 10, "productID" : "XHDK-A-1293-#fJ3" }
    { "index": { "_id": 2 }}
    { "price" : 20, "productID" : "KDKE-B-9947-#kL5" }
    { "index": { "_id": 3 }}
    { "price" : 30, "productID" : "JODL-X-1937-#pV7" }
    { "index": { "_id": 4 }}
    { "price" : 30, "productID" : "QQPX-R-3956-#aD8" }
    
    # 局部更新 存在的字段覆盖，不存在的字段添加-版本失败重试5次
    POST /wang-indexname/wang-indextype/id1/_update?retry_on_conflict=5
    {
       "doc" : {
          "array" : [ "movie","music" ],
          "age": 26
       }
    }
    
    
    
    #查询id1的数据 
    GET /wang-indexname/wang-indextype/id1
    
    #查看查询细节
    GET /wang-indexname/wang-indextype/_validate/query?explain
    
    #查询所有数据，默认返回前十条
    GET /wang-indexname/wang-indextype/_search
    {
      "query": {
        "match_all": {}
      }
    }
    
    
    
    #删除
    DELETE /wang-indexname/wang-indextype/id1
    
    
    
    #查询所有索引列表
    GET _cat/indices?v
    
    #查询集群节点是否禁用内存交换（swapping）
    GET _nodes?filter_path=**.mlockall
    
    #查询集群节点的最大文件描述符
    GET _nodes/stats/process?filter_path=**.max_file_descriptors
    
    #打开（默认关闭）动态数字映射
    PUT my_index_name
    
    #查看所有分片状态
    GET _cat/shards
    
    
    GET _cluster/settings
    
    #查询各个节点安装的插件
    GET /_cat/plugins?v&s=component&h=name,component,version,description

    #查询分词结果
    POST test-ig_zues_db_ig_zues-biz_corp/_analyze
    {
      "field": "name",
      "text": "豪-大数据工程师"
    }
    
    #查询集群数据状态
    GET /_cluster/state

w

# 官方文档
https://www.elastic.co/guide/en/elasticsearch/reference/7.2/cluster-allocation-explain.html
   
# 查看分片错误异常原因
curl localhost:9200/_cluster/allocation/explain


# 查看所有分片状态
curl localhost:9200/_cat/shards

https://blog.csdn.net/weixin_37650458/article/details/84388054

    7  groupadd elasticsearch
    8  useradd elasticsearch -g elasticsearch -p elasticsearch
    9  passwd elasticsearch
   12  yum install lrzsz
   13  yum -y install java-1.8.0-openjdk*
   29  yum install zip unzip
   10  cd /home/elasticsearch/
   16  rz
   17  tar -zxvf elasticsearch-6.7.0.tar.gz 
   19  chown -R elasticsearch:elasticsearch /home/elasticsearch/elasticsearch-6.7.0
   23  cd elasticsearch/elasticsearch-6.7.0
   25  ./bin/elasticsearch-plugin install https://github.com/medcl/elasticsearch-analysis-ik/releases/download/v6.7.0/elasticsearch-analysis-ik-6.7.0.zip
   26  cd plugins/
   27  rz
   28  unzip dynamic-synonym.zip 

   30  unzip dynamic-synonym.zip 

   32  rm -rf dynamic-synonym.zip 
   33  cd ../

   35  cd config/
   36  > analysis-ik/IKAnalyzer.cfg.xml 
   37  cd analysis-ik/

   39  vi IKAnalyzer.cfg.xml 
   40  cd ../

   42  vi elasticsearch.yml 
   43  cd ../

   45  chown -R elasticsearch:elasticsearch /home/elasticsearch
   46  cd elasticsearch-6.7.0

   48  cd bin/
   49  su elasticsearch
   50  vi /etc/sysctl.conf 
   51  sysctl -p
   52  sh elasticsearch
   53  cd ../

   54  vi /etc/sysctl.conf
    # 添加下面配置, 最大虚拟内存：vm.max_map_count=655360
   55  sysctl -p