elasticsearch增删改查语法Kibana链接Elasticsearch增删改查语法-优快云博客

本文详细介绍了Elasticsearch中各种数据操作的方法，包括查看索引、节点和集群状态，查询、更新、删除索引数据，以及如何根据ID进行数据的增删改查。通过实际案例展示了如何使用REST API进行数据管理和检索。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

#查看索引、节点数、集群健康状态
GET _cat/indices
GET _cat/nodes
GET _cat/health

#查询索引数据
GET griffin/accuracy/_search
GET test/_search

#根据某个字段查询数据
GET griffin/accuracy/_search
{
"query": {
"match": {
"name":"stg_company_cap_job"
}
}
}

#根据ID删除一条数据索引文档
POST griffin/accuracy/_delete_by_query?pretty
{
"query":{
"term":{"_id":"-8b7U3IBa8xBm1BYdwjv"}
}
}

#根据ID更新对应数据
POST griffin/accuracy/6MZsUHIBa8xBm1BYUwgU/_update?pretty
{
"doc": {"name": "stg_company_regno",
"tmst" : 1580300840000,
"value" : {
"regno_emptycount" : 45885,
"enttype_nullcount" : 10,
"regno_count" : 4849,
"enttype_distcount" : 2128,
"regno_distcount" : 3086,
"regno_nullcount" : 23,
"enttype_emptycount" : 6555,
"enttype_count" : 44309
}
}
}

#根据ID更新对应数据
POST griffin/accuracy/6cZ6UHIBa8xBm1BY_gi7/_update?pretty
{
"doc": {"name": "stg_company_cap_job",
"tmst" : 1590314400000,
"value" : {
"regactlcap_count" : 484305,
"regorg_distcount" : 8455,
"regorg_count" : 484309,
"regactlcap_emptycount" : 484387,
"regactlcap_distcount" : 7,
"regorg_emptycount" : 66797
}
}
}

#新增一条数据指定ID
PUT /griffin/accuracy/6MZsUHIBa8xBm1BYUwgU
{
"doc": {"name": "stg_company_cap_job",
"tmst" : 1590314400000,
"value" : {
"regactlcap_count" : 484305,
"regorg_distcount" : 8455,
"regorg_count" : 484309,
"regactlcap_emptycount" : 484398,
"regactlcap_distcount" : 7,
"regorg_emptycount" : 66797
}
}
}

#根据ID查询某一条数据
GET griffin/accuracy/6cZ6UHIBa8xBm1BY_gi7/
GET /griffin/accuracy/6MZsUHIBa8xBm1BYUwgU

#根据ID新增一条数据
PUT /test/_doc/1?pretty
{
"name": "John Doe"
}

#根据ID更新某条数据
POST test/_doc/1/_update?pretty
{
"doc": { "name": "Janeee Doe" }
}

#根据ID更新某条数据，并且增加字段
POST test/_doc/1/_update?pretty
{
"doc": { "name": "Jane Doe", "age": 20 }
}

#插入某条数据
PUT test/_doc/2
{
"doc": {"name": "bigdata",
"age": 12
}
}

#根据某个字段查询数据
GET griffin/accuracy/_search
{
"query": {
"match": {
"name":"dw_company_all_profiling"
}
}
}

POST griffin/accuracy/DrnBeHIBDFd03GZFqXU3/_update?pretty
{
"doc": {"name": "dw_company_all_profiling",
"tmst" : 1584223200000,
"value" : {
"entname_emptycount" : 2,
"regaddress_emptycount" : 197134,
"entname_count" : 2998974,
"regaddress_count" : 2998763
}
}
}