es查询练习




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

# 创建索引
PUT person
PUT zqk
# 查询索引
GET person
GET zqk 
# 删除索引
DELETE person
DELETE zqk

# 查询映射
GET person/_mapping
GET zqk/_mapping


# 添加映射
PUT person/_mapping
{
  "properties":{
    "name":{
      "type":"keyword"
    },
    "age":{
      "type":"integer"
    }
  }
}
PUT zqk/_mapping
{
  "properties":{
    "name" :{
      "type" : "keyword"
    },
    "age": {
      "type" : "integer"
    }
  }
}


# 创建索引并添加映射
PUT person
{
  "mappings": {
    "properties": {
      "name":{
        "type": "keyword"
      },
      "age":{
        "type":"integer"
      }
    }
    
  }
}
PUT zqk
{
  "mappings": {
    "properties" :{
      "name" : {
        "type" : "keyword"
      },
      "age" : {
        "type" : "integer"
      }
    }
  }
}


# 索引库中添加字段
PUT person/_mapping
{
  "properties":{
    "address":{
      "type":"text"
    }
  }
}
PUT zqk/_mapping
{
  "properties" :{
    "address" : {
      "type" : "text"
    }
  }
}

# 查询索引
GET person
GET zqk



# 添加文档,指定id
POST person/_doc/3
{
  "name":"張三",
  "age":30,
  "address":"华为5G手机"
}
POST zqk/_doc/3
{
  "name":"张三",
  "age" : 30,
  "address" : "华为5G手机"
}
# 查询文档
GET person/_doc/1
GET zqk/_doc/3

# 添加文档,不指定id
POST person/_doc/
{
  "name":"李四",
  "age":20,
  "address":"深圳南山區"
}
POST zqk/_doc/
{
  "name":"天津李四",
  "age" : 38,
  "address": "天津滨海"
}
# 查询文档
GET person/_doc/PC6eIpvAQ_yQua9UW9tlZQ
GET zqk/_doc/iXQYo30BxeVvR4r0hPeu

# 添加文档,不指定id
POST person/_doc/
{
  "name":"李四",
  "age":20,
  "address":"深圳南山区"
}
POST zqk/_doc
{
  "name" : "沈阳仙洋",
  "age" : 30,
  "address": "沈阳市皇姑区"
}
# 查询文档
GET person/_doc/7fWDhnsB3zC415WCdfEQ
GET zqk/_doc/inQao30BxeVvR4r0rvcX

# 查询所有文档
GET person/_search
GET zqk/_search

# 删除文档
DELETE person/_doc/1
DELETE zqk/_doc/iXQYo30BxeVvR4r0hPeu



# 修改文档 根据id,id存在就是修改,id不存在就是添加
PUT person/_doc/1
{
  "name":"乾坤傢",
  "age":20,
  "address":"深圳福田保税区"
}
GET zqk/_search
PUT zqk/_doc/1
{
  "name" : "zqk:嗷嗷强",
  "age" : 23,
  "address" : "沈阳市于洪区"
}


# match 先会对查询的字符串进行分词,在查询,求交集
GET person/_search
{
  "query": {
    "match": {
      "address": "华为手机"
    }
  }
}
GET zqk/_search
{
  "query" : {
    "match": {
      "address": "华为手机"
    }
  }
}

#词条查询不会分析查询条件,只有当词条和查询字符串完全匹配时才匹配搜索
#查询文档-term查询
# 查询所有数据
GET person/_search
GET zqk/_search

# 查询 深开头的数据
GET person/_search
{
  "query": {
    "term": {
      "address": {
        "value": "深"
      }
    }
  }
}
GET zqk/_search
{
  "query" : {
    "term": {
      "address": {
        "value": "沈"
      }
    }
  }
}
POST zqk/_doc/2
{
  "name" :"zqk2",
  "age" : 24,
  "address" : "五里河"
}

#查询名字等于张三的用户
GET person/_search?q=name:張三
GET zqk/_search?q=name:张三


#4.2.13 DSL 查询
#url地址请求体,多添加几条数据,方便做查询


PUT qiankunjia/_doc/1001
{
  "id":"1001",
  "name":"张三",
  "age":20,
  "sex":"男"
}



PUT qiankunjia/_doc/1002
{
  "id":"1002",
  "name":"李四",
  "age":25,
  "sex
  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值