Elasticsearch 基础语法

# 1.1 创建索引，自动增加索引，并添加数据。
PUT /test1/type1/1
{
  "name": "王二小",
  "age": 3
}
# 1.2 创建规则
PUT /test2
{
  "mappings": {
    "properties": {
      "name": {
        "type": "text"
      },
      "age": {
        "type": "long"
      },
      "birthday": {
        "type": "date"
      }
    }
  }
}
# 2.1 查看具体信息
GET test2
# 3.1查看默认信息
PUT /test3/_doc/1
{
"name": "王二小",
"age":3,
"birthday": "2000-08-08"
}
# 2.1 查看
GET test3
# 如果自己的文档字段没有指定，那么ES会给我们默认配置字段类型

# 4.1 通过_cat命令可以获得es很多信息

GET _cat/health
GET _cat/indices

# 5.1 修改还是用put覆盖值就可以了
# 执行3.1会更新_version
# 5.2 POST修改
POST /test3/_doc/1/_update
{
  "doc":{
    "name": "王三小吗"
  }
}

GET /test3/_doc/1
# 结论：值不一样才会修改，多次执行version也不会更新

# 6.1 删除
DELETE /test1
DELETE /test2
DELETE /test3/_doc/1
DELETE /test3

PUT /scorpio/user/1
{
  "name": "王二小",
  "age": 3,
  "desc": "一个小孩子",
  "tags": ["篮球","排球","足球"]
}

PUT /scorpio/user/2
{
  "name": "曹操",
  "age": 33,
  "desc": "一个大人",
  "tags": ["篮球","乒乓球"]
}

PUT /scorpio/user/3
{
  "name": "小乔",
  "age": 23,
  "desc": "一个女孩子",
  "tags": ["跳舞"]
}

PUT /scorpio/user/4
{
  "name": "大乔",
  "age": 24,
  "desc": "一个女孩子",
  "tags": ["跳舞", "唱歌"]
}

PUT /scorpio/user/5
{
  "name": "江大乔",
  "age": 21,
  "desc": "一个女孩子",
  "tags": ["跳舞", "唱歌"]
}

# 查询
GET /scorpio/user/1
# 根据默认的规则基础查询
GET /scorpio/user/_search?q=name:王二小
# （排序、分页、高亮、模糊、）
# 多条数据_score是分值，匹配度

GET /scorpio/user/_search
{
  "query": {
    "match": {
      "name": "大乔"
    }
  }
}

# 只查出具体字段 sql 指定字段
GET /scorpio/user/_search
{
  "query": {
    "match": {
      "name": "大乔"
    }
  },
  "_source": ["name","age"]
}


# 排序
GET /scorpio/user/_search
{
  "query": {
    "match": {
      "name": "大乔"
    }
  },
  "sort":{
    "age":{
      "order": "desc"
    }
  }
}

# 分页 from:从第几条数据 size:分页大小
GET /scorpio/user/_search
{
  "query": {
    "match": {
      "name": "大乔"
    }
  },
  "sort":{
    "age":{
      "order": "desc"
    }
  },
  "from": 0,
  "size": 2
}

# must(and) 所有的条件都要符合
GET /scorpio/user/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "name": "大乔"
          }
        },
        {
          "match": {
            "age": "24"
          }
        }
      ]
    }
  }
}

# should(or) 条件满足其一
GET /scorpio/user/_search
{
  "query": {
    "bool": {
      "should": [
        {
          "match": {
            "name": "大乔"
          }
        },
        {
          "match": {
            "age": 24
          }
        }
      ]
    }
  }
}

# must_not(not 不等于) 条件满足其一
GET /scorpio/user/_search
{
  "query": {
    "bool": {
      "must_not": [
        {
          "match": {
            "age": 24
          }
        }
      ]
    }
  }
}

# filter 进行范围数据过滤 gte >= 、lte <=
GET /scorpio/user/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "name": "大乔"
          }
        }
      ],
      "filter": [
        {
          "range": {
            "age": {
              "gte": 10,
              "lte": 23
            }
          }
        }
      ]
    }
  }
}

# 匹配多个条件 多个条件空格隔开，只要满足其一就可以查出

GET /scorpio/user/_search
{
  "query": {
    "match": {
      "tags": "唱歌 跳舞"
    }
  }
}
# 精确查询
# term查询是通过倒排索引指定的词条进行精确查找的

# 关于分词：
# term  直接查询精确的
# match 会使用分词器解析（需要先分析文档）
# 两个类型 text keyword
# 
PUT testdb
{
  "mappings": {
    "properties": {
      "name": {
        "type": "text"
      },
      "desc": {
        "type": "keyword"
      }
    }
  }
}

PUT testdb/_doc/1
{
  "name": "幸福了吗",
  "desc": "也还行888"
}

PUT testdb/_doc/2
{
  "name": "幸福了吗",
  "desc": "也还行999"
}

PUT testdb/_doc/3
{
  "name": "幸福了吗",
  "desc": "也还行99977"
}

GET testdb/_search
{
  "query": {
    "term": {
        "name": "幸"
    }
  }
}
GET testdb/_search
{
  "query": {
    "term": {
        "desc": "也还行999"
    }
  }
}
# 结论:keyword类型的字段不会被分词器解析
#      text   类型才会被分词器解析

GET _analyze
{
  "analyzer": "keyword",
  "text": "幸福了吗"
}

GET _analyze
{
  "analyzer": "standard",
  "text": "幸福了吗"
}



PUT testdb/_doc/5
{
  "t1": "22",
  "t2": "2020-09-15"
}

PUT testdb/_doc/6
{
  "t1": "23",
  "t2": "2020-09-15"
}

GET testdb/_doc/5

# 多个值匹配精确查询
GET testdb/_search
{
  "query": {
    "bool": {
      "should": [
        {
          "term": {
              "t1": "22"
          }
        },
        {
          "term": {
            "t1": "23"
          }
        }
      ]
    }
  }
}

# 高亮查询，搜索的结果会增加em标签
GET scorpio/user/_search
{
  "query":{
    "match": {
      "name": "大乔"
    }
  },
  "highlight":{
    "fields": {
      "name": {}
    }
  }
}


# 高亮查询，自定义高亮标签
GET scorpio/user/_search
{
  "query":{
    "match": {
      "name": "大乔"
    }
  },
  "highlight":{
    "pre_tags": "<p class='red'>",
    "post_tags": "</p>", 
    "fields": {
      "name": {}
    }
  }
}