学习ElasticSearch 常用命令记录

环境 elasticsearch-7.4.2 + openjdk-11

自己在windows机器测试命令记录

最新文档地址：

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-analyze.html#search-analyze

1. 安装浏览器ElasticSearch插件（chrome）：chrome://extensions/?id=ffmkiejjmecolpfloofpjologoblkegm

2. 关闭ES集群：

curl -XPOST http://localhost:9200/_cluster/nodes/_shutdown

关闭单一节点（节点名称：“BlrmMvBdSKiCeYGsiHijdg”）

curl –XPOST
http://localhost:9200/_cluster/nodes/BlrmMvBdSKiCeYGsiHijdg/_shutdown

3. 检查集群状态GET：

/_cat/health?v&pretty

或

_cluster/health?pretty

4. 创建一个索引

PUT http://127.0.0.1:9200/{_index}/{_type}/{_id}

如下，建立了customer索引，类型是_doc，文档id是1

 

Demo

GET _search
{
  "query": {
    "match_all": {}
  }
}

# 查询所有索引 
# v:带表头输出
# s:按照某列排序
# health:输出指定状态的index
get /_cat/indices?v&s=docs.count&health=yellow

# 查看索引状态
get /_cat/indices
get /_cat/indices?v&index=demo

# 查看别名
get /_cat/aliases?v

# 查看健康
get /_cat/health?v

# 查看主节点
get /_cat/master?v

# 集群健康
get /_cluster/health

# 查看集群状态，包括所有集群节点、集群级别的设置、
# 所有表的mappings、集群中所有分片的位置
GET /_cluster/state
GET /_cluster/state/metadata/demo

GET /_cluster/stats?human&pretty


# 新增索引
delete demo2

put demo2
{
  "settings": {
    "index": {
      "number_of_shards": 5,
      "number_of_replicas": 1
    }
  },
  "mappings": {
    "properties": {
      "goodsId": {"type": "long"},
      "goodsName": {"type": "text"},
      "category": {"type": "keyword"}
    }
  }
}

# 添加测试数据
PUT /demo2/_doc/1
{
  "goodsId": 1,
  "goodsName": "iphoneXS Plus apple tech",
  "category": "3C,CellPhone,Apple"
}

PUT /demo2/_doc/2
{
  "goodsId": 2,
  "goodsName": "HUAWEI MetaX huawei tech",
  "category": "3C,CellPhone,huawei"
}

PUT /demo2/_doc/3
{
  "goodsId": 3,
  "goodsName": "Macbook Pro 15'6 inch",
  "category": "Apple"
}

# 创建别名alias,可以通过别名进行搜索
# 可以关联多个indcies

# 带过滤的alies
POST /_aliases
{
  "actions": [
    {
      "add": {
        "index": "demo2", 
        "alias": "demo2_alias",
        "filter": {
          "term": {
            "category": "Apple"
          }
        }
      }
    }
  ]
}

GET /demo2_alias/_search
{
  "query":{
    "match_all":{}
  }
}

# 查询alias的信息
GET /demo2_alias/_alias/*

# 添加多项依赖
POST /_aliases
{
  "actions": [
    {"add": {"indices": ["demo", "demo2"], "alias": "demo2_alias"}}
  ]
}

# remove_index将会删除索引，慎用
POST /_aliases
{
  "actions": [
    {
      "add": {
        "index": "demo2", 
        "alias": "demo2_alias",
        "filter": {
          "text": {"goodsName": "Apple"}
        }
      }
    },
    {"remove_index": {"index": "demo"}}
  ]
}

# 查看所有别名
GET /_cat/aliases

get /demo2/_search
{
  "query": {
    "match_all": {}
  }
}







### 获取索引mappings
get /demo/_mappings

### 文档相关api
# 新增,如果存在则更新，内部有_version版本号递增
put /demo/_doc/5
{
  "name": "霉霉",
  "desc": "唱歌界的仙女",
  "age":"29",
  "labels": [
    "唱歌好听",
    "beautiful"
  ]
}

# 跟put类似的
POST /demo/_doc/6?
{
  "name": "霉2霉",
  "desc": "唱歌界的仙女",
  "age":"29",
  "labels": [
    "唱歌好听",
    "beautiful"
  ]
}


get /demo/_search
{
  "query": {
    "match_all": {}
  }
}

get /demo/_search
{
  "query":{
    "match": {
      "name": "小云"
    }
  }
}

get /demo/_search
{
  "query":{
    "bool": {
      "must": [
        {"match": {
          "desc": "仙女"
        }},
        {
          "term": {
            "age": "28"
          }
        }
      ]
    }
  },
  "sort": {
    "age": "desc"
  },
  "from": 1,
  "size": 2
}

Demo2

GET _search
{
  "query": {
    "match_all": {}
  }
}


get _cat/indices

get /_xpack/sql?format=json
{
  "query": "select * from yuce_rpt_competing_goods_analysis_20190529"
}


get /yuce_rpt_goods_effect_analysis_sup/_search
{
  "query" :{
    "match_all": {}
  }
}

get /yuce_rpt_goods_effect_analysis_operation/_search
{
  "query" :{
    "bool": {
      "must": [
        {"term": {
          "app": {
            "value": "Jolly Chic"
          }
        }}
      ]
    }
  }
}


# 查询运营助手
get /yuce_rpt_goods_effect_analysis_operation/_search
{
  "query":{
    "bool": {
      "must": [
        {"match": {"provider_code": "0CF"}},
        {"match": {"category_one": ""}},
        {"match": {"category_two": ""}},
        {"match": {"category_three": ""}}
      ]
    }
  },
  "sort": {
    "sales_volume_7d": "desc",
    "sales_amount_7d": "desc",
    "sales_volume_30d": "desc",
    "sales_amount_30d": "desc"
  },
  "from": 0,
  "size": 50
}


get /yuce_rpt_goods_effect_analysis_sup/_search
{
  "query":{
    "bool": {
      "must": [
        {"match": {"provider_code": "0CF"}},
        {"match": {"app": "Dealy"}}
      ]
    }
  },
  "sort": {
    "expo_pv": "desc"
  },
  "from": 0,
  "size": 50
}


get yuce_rpt_goods_effect_analysis_sup/_mapping