文档查询

是否存在

HEAD articleeditstatisticsdev/_doc/36205410-31d4-44e5-ada2-3792cffdced9

查询全部

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

关键词查询

GET quartz_system_202103/_search
{
  "query": {
    "match": {
      "doc.JobName": "商品列表"
    }
  }
}

分页查询

GET quartz_system_202103/_search
{
  "query": {
    "match_all": {}
  },
  "from": 0,
  "size": 3
}

operator

and 分词后都必须包含，or 包含其一就可以

GET quartz_system_202103/_search
{
  "query": {
    "match": {
      "doc.JobName": {
        "query": "获取商品的列表",
        "operator": "and"
      }
    }
  }
}

GET quartz_system_202103/_search
{
  "query": {
    "match": {
      "doc.JobName": {
        "query": "获取商品的列表1",
        "operator": "or"
      }
    }
  }
}

根据 ID

GET quartz_system_202103/_doc/542257d2-ef9f-4883-8e34-504257e6f651

多字段查询

POST quartz_system_202103/_search
{
  "query": {
    "multi_match": {
      "query": "true",
      "fields": ["doc.HttpOrDllRunIsSuccess","doc.HttpOrDllRunResultProcessIsSuccess"]
    }
  }
}

精确查询 term

POST quartz_system_202103/_search
{
  "query": {
    "term": {
      "doc.JobName": {
        "value": "数据"
      }
    }
  }
}

多值查询 terms

POST quartz_system_202103/_search
{
  "query": {
    "terms": {
      "doc.JobName": [
        "数据",
        "商品"
      ]
    }
  }
}

返回需要字段

GET quartz_system_202103/_search
{
  "_source": ["doc.JobName","doc.HttpOrDllRunIsSuccess"], 
  "query": {
    "match_all": {}
  }
}

剔除不需要字段

GET quartz_system_202103/_search
{
  "_source": {
    "excludes": ["doc.HttpOrDllRunResult","doc.timestamp"]
  }, 
  "query": {
    "match_all": {}
  }
}

文档删除

根据 Id

DELETE quartz_system_202103/_doc/542257d2-ef9f-4883-8e34-504257e6f651

根据查询条件

POST quartz_system_202103/_delete_by_query
{
  "query":{
    "match":{
      "doc.JobName":"持仓_NZDUSD"
    }
  }
}

全部删除

POST quartz_system_202101/_delete_by_query
{
  "query":{
    "match_all":{}
  }
}

文档添加

 
POST user_web_info/_doc/_bulk
{ "create": {"_id": "1" }}
{"uuid":1,"name":"jack chen","nickname":"apple pear","age":20,"dt":"2016-06-25"}
{ "create": {"_id": "2" }}
{"uuid":2,"name":"jack ma","nickname":"apple pear pear","age":22,"dt":"2016-08-23"}
{ "create": {"_id": "3" }}
{"uuid":3,"name":"lucy","nickname":"apple pear apple","age":23,"dt":"2016-08-25"}

索引

是否存在

HEAD twitter

删除全部

DELETE /_all

or

DELETE /*

删除多个

DELETE /index_one,/index_two

创建索引

put /index_name

查看索引

GET /index_name

修改副本数

PUT /index_name/_settings
{
    "number_of_replicas": 1
}

查看文档数量

GET quartz_system_202104/_count

Mapping

创建索引 map

PUT user_web_info
{
  "mappings": {
    "properties": {
    "uuid":{"type":"long"},
    "name":{"type":"text","fields":{"keyword":{"type": "keyword"}}},
    "nickname":{"type":"text"},
    "age":{"type":"integer"},
    "dt":{"type":"date","format": "yyyy-MM-dd"}
   }
  }
}

查看 map

GET /my_index/_mapping

添加 map 字段

PUT /my_index/_mapping
{
 "properties": {
      "sex":{"type":"integer","index":false}
    }
}
 

修改 map 字段

对于已经存在的映射字段,我们不能更新。更新必须创建新的索引进行数据迁移。