ES dev console

# 查看es中的索引
GET /_cat/indices
# 查看es中的索引,同时查看状态
GET /_cat/indices?v
# 创建索引(默认rep=1)
PUT /products
# 创建订单索引(让rep=0)
PUT /orders
{
  "settings": {
    "number_of_shards": 1,
    "number_of_replicas": 0
  }
}
# 删除索引
DELETE /products
# 创建商品索引 products 指定 mapping{id,title,price,created_at,description}
PUT /products
{
  "settings": {
    "number_of_replicas": 0,
    "number_of_shards": 1
  },
  "mappings": {
    "properties": {
      "id":{
        "type": "integer"
      },
      "title":{
        "type": "keyword"
      },
      "price":{
        "type": "double"
      },
      "created_at":{
        "type": "date"
      },
      "description":{
        "type": "text"
      }
    }
  }
}
# 查看某个索引的映射信息 mapping
GET /products/_mapping
# 添加文档操作 手动指定 _id
POST /products/_doc/1
{
  "id" : 1,
  "title":"小浣熊",
  "price":0.5,
  "created_at":"2012-11-12",
  "description":"小老鼠真好吃"
}
# 添加文档操作 自动创建文档的 id CurihYsBq0CcYHMB1rPB
POST /products/_doc/
{
  "id" : 1,
  "title":"大香蕉",
  "price":0.5,
  "created_at":"2012-11-12",
  "description":"小老鼠真好吃"
}
# 文档查询  基于 id 查询
GET /products/_doc/CurihYsBq0CcYHMB1rPB
# 删除文档 基于 id 删除
DELETE /products/_doc/CurihYsBq0CcYHMB1rPB
# 更新文档 先删除原始文档 再重新添加 要带上原始的内容
PUT /products/_doc/1
{
  "description":"小老鼠真香"
}
PUT /products/_doc/1
{
  "id" : 1,
  "title":"小浣熊",
  "price":0.5,
  "created_at":"2012-11-12",
  "description":"小老鼠真香"
}
# 更新文档，基于指定字段进行更新
POST /products/_update/1
{
  "doc":{
    "price":1.0,
    "title":"我是cfddfc"
  }
}
GET /products/_doc/2
# 文档的批量操作 _bulk
# 不能有回车换行
POST _bulk
{"index":{"_id":2,"_index" : "products"} }
{"id" : 2,"title":"大老鼠","price":0.5,"created_at":"2012-11-12","description":"小浣熊真香！"}
{"index":{"_id":3,"_index" : "products"} }
{"id" : 3,"title":"与馒头","price":0.5,"created_at":"2012-11-12","description":"馒头真香啊"}
# 文档批量操作 添加 更新 删除
POST _bulk
{"index":{"_id":4,"_index" : "products"} }
{"id" : 4,"title":"好吃的薯片","price":100,"created_at":"2012-11-12","description":"薯片真香！"}
{"update":{"_id":3,"_index" : "products"} }
{"doc":{"description":"馒头太好吃了吧"}}
{"delete":{"_id":2,"_index" : "products"} }
# query DSL 语法 查询所有 match_all
GET /products/_search
{
  "query":{
    "match_all":{}
  }
}
# term 基于关键词查询 
GET /products/_mapping
# keyword 类型 日后搜索使用 全部内容搜索
# text 类型 默认 es 标准分词器 中文单字分词 英文单词分词
# keyword integer double date 不分词
# 1. 在 ES 中除了 text 类型分词，其余类型均不分词
# 2. 在 ES 中默认使用标准分词器 中文单字分词 英文单词分词
GET /products/_search
{
  "query": {
    "term": {
      "id": {
        "value": 1
      }
    }
  }
}
# 范围查询 ranger
GET /products/_search
{
  "query": {
    "range": {
      "price": {
        "gte": 1,
        "lte": 20
      }
    }
  }
}
# 前缀查询
GET /products/_search
{
  "query": {
    "prefix": {
      "description": {
        "value": "小"
      }
    }
  }
}
# 因为中文默认分词器是一个字一个字，所以查询不到，结果为空
GET /products/_search
{
  "query": {
    "prefix": {
      "title": {
        "value": "我是"
      }
    }
  }
}
# 通配符查询 * 多个 ? 一个
GET /products/_search
{
  "query": {
    "wildcard": {
      "description": {
        "value": "小*"
      }
    }
  }
}
# ids 多id查询 查询一组符合条件的id
GET /products/_search
{
  "query": {
    "ids": {
      "values": [3,4,2]
    }
  }
}
# fuzzy 模糊查询
GET /products/_search
{
  "query": {
    "fuzzy": {
      "description": "馒头太好吃了吧"
    }
  }
}
# bool 查询
GET /products/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "ids": {
            "values": [1]
          }
        },{
          "term": {
            "title": {
              "value": "我是cfddfc"
            }
          }
        }
      ]
    }
  }
}
# 多字段查询 multi_match
# 注意：query 输入关键词 输入一段文本
GET /products/_search
{
  "query": {
    "multi_match": {
      "query": "老鼠馒头",
      "fields": ["title","description"]
    }
  }
}
# query_string
GET /products/_search
{
  "query": {
    "query_string": {
      "default_field": "description",
      "query": "*"
    }
  },
  "highlight": {
    "pre_tags": ["<span style='color:red;'>"],
    "post_tags": ["</span>"], 
    "require_field_match": "false", 
    "fields": {
      "description":{}
    }
  },
  "sort":[
    {
      "price":"desc"
    }
  ],
  "_source": ["id","title","description"]
}
# 删除所有，重新写
DELETE /products
PUT /products
{
  "mappings" : {
    "properties" : {
      "description" : {
        "type" : "text"
      },
      "price" : {
        "type": "float"
      },
      "title": {
        "type" : "keyword"
      }
    }
  }
}
# 测试索引
POST _bulk
{"index":{"_id":1,"_index" : "products"} }
{"id" : 1,"title":"洗衣液","price":25,"description":"这个洗衣液很搞笑"}
{"index":{"_id":2,"_index" : "products"} }
{"id" : 2,"title":"手机","price":1999,"description":"很好用"}
{"index":{"_id":3,"_index" : "products"} }
{"id" : 3,"title":"小老鼠","price":0,"description":"很好吃"}
GET /products/_search
{
  "query": {
    "match_all": {}
  }
}
GET /products/_search
{
  "query":{
    "term":{
      "description":{
        "value":"很"
      }
    }
  }
}
# 分词器测试
POST /_analyze
{
  "analyzer":"ik_smart",
  "text":"常凤迪"
}
PUT /test
{
  "mappings": {
    "properties": {
      "title":{
        "type": "text",
        "analyzer": "keyword"
      }
    }
  }
}
PUT /test/_doc/1
{
  "title":"我是我是我是我是cfd a interasting person"
}
DELETE /test
GET /test/_search
{
  "query": {
    "match_all": {}
  }
}
GET /test/_search
{
  "query": {
    "term": {
      "title": {
        "value": "我是我是我是我是cfd a interasting person"
      }
    }
  }
}
# filter过滤
GET /products/_search
{
  "query":{
    "match_all":{}
  }
}
PUT /products/_doc/4
{
  "id":4,
  "title":"飞机",
  "price":10000000,
  "description":"很快"
}
GET /products/_search
{
  "query":{
    "bool": {
      "filter": [
        {"term": {"description": "很"}},
        {"term": {"description": "好"}},
        {"terms": {
          "description": [
            "很",
            "好"
          ]
        }}
      ]
    }
  }
}
GET /products/_search
{
  "query":{
    "bool": {
      "filter": [
        {"range": {
          "price": {
            "gte": 1,
            "lte": 100
          }
        }}
      ]
    }
  }
}
GET /products/_search
{
  "query":{
    "bool": {
      "filter": [
        {"exists": {
          "field": "id"
        }}
      ]
    }
  }
}
GET /products/_search
{
  "query":{
    "bool": {
      "filter": [
        {"ids": {
          "values": [
            "1"
          ]
        }}
      ]
    }
  }
}