企业🤖AI Agent构建引擎,智能编排和调试,一键部署,支持私有化部署方案 广告
[TOC] ## 数据管理 ES提供近乎实时的数据操纵和搜索能力。默认情况下,从索引/更新/删除数据到在搜索结果中出现数据之前,可以预期延迟一秒钟(刷新间隔)。这是与其他SQL数据库的重要区别,SQL数据库中的数据在事务完成后立即可用。 ### **添加Document: `PUT /<index>/<type>/<ID>`** 现在我们往"customer"中创建一个ID为1 的document: ``` curl -X PUT "localhost:9200/customer/_doc/1?pretty" -H 'Content-Type: application/json' -d' { "name": "John Doe" } ' ``` 运行结果如下: ```cmd { "_index" : "customer", "_type" : "_doc", "_id" : "1", "_version" : 1, "result" : "created", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 0, "_primary_term" : 1 } ``` 通过上面的命令,我们已经成功的添加了一个customer document在customer index中 >[info] 值得注意的是,Elasticsearch不需要在显式地创建一个索引之前,我们就可以创建索引文档。在前面的示例中,如果没有事先已经存在索引,Elasticsearch将自动创建索引。 其中,ID为可选项,假如我们没有指定ID,ES则会自动生成一个唯一的ID,如下: ``` curl -X POST "localhost:9200/customer/_doc?pretty" -H 'Content-Type: application/json' -d' { "name": "Cherish" } ' ``` 运行结果如下: ```cmd { "_index" : "customer", "_type" : "_doc", "_id" : "EJLLSWcBMnaFSnQdDr7_", "_version" : 1, "result" : "created", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 0, "_primary_term" : 3 } ``` 注意:我们这里使用了`POST`而不是`PUT`,添加后,生成的ID为`EJLLSWcBMnaFSnQdDr7_` &nbsp; ### **查询Document: `GET /<index>/<type>/<ID>`** 查询索引Customer中ID为1的Document命令: ``` curl -X GET "localhost:9200/customer/_doc/1?pretty" ``` 查询结果如下: ```cmd { "_index" : "customer", "_type" : "_doc", "_id" : "1", "_version" : 1, "found" : true, "_source" : { "name" : "John Doe" } } ``` 根据查询结果,ID为1的document中,name=“John Doe” ### **替换Document:`PUT /<index>/<type>/<ID>`** 添加Document时,假设ID已存在,如前面添加的ID为1,这将会覆盖原来的记录,如下: ``` curl -X PUT "localhost:9200/customer/_doc/1?pretty" -H 'Content-Type: application/json' -d' { "name": "Milton" } ' ``` 重新查询时 `curl -X GET "localhost:9200/customer/_doc/1?pretty"` 查询结果如下: ```cmd { "_index" : "customer", "_type" : "_doc", "_id" : "1", "_version" : 2, "found" : true, "_source" : { "name" : "Milton" } } ``` 通过上面结果可以得知,ID为1的Document已经被替换。注意“_version”已自增 ### **更新Document: `POST /<index>/<type>/<ID>/_update`** - 更新customer中ID为1的Document中的name为“Apple” ``` curl -X POST "localhost:9200/customer/_doc/1/_update?pretty" -H 'Content-Type: application/json' -d' { "doc": { "name": "Apple" } } ' ``` - 更新customer中ID为1的Document中的name为“Tom”,并且添加新的字段age ``` curl -X POST "localhost:9200/customer/_doc/1/_update?pretty" -H 'Content-Type: application/json' -d' { "doc": { "name": "Tom", "age": 20 } } ' ``` - 使用Scripts脚本更新Document中的age+5 ``` curl -X POST "localhost:9200/customer/_doc/1/_update?pretty" -H 'Content-Type: application/json' -d' { "script" : "ctx._source.age += 5" } ' ``` 上面例子中`ctx._source`代表被更新的对象本身。 ### **删除Document: `DELETE /<index>/<type>/<ID>`** 删除customer中ID为2的Document ``` curl -X DELETE "localhost:9200/customer/_doc/2?pretty" ``` 假设文档不存在,则返回如下 ``` { "_index" : "customer", "_type" : "_doc", "_id" : "2", "_version" : 1, "result" : "not_found", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 0, "_primary_term" : 1 } ``` ### **批量处理:`POST <index>/<type>/_bulk`** 在ES中,除了上面针对单个Document增、删、改、查之外,ES还提供了一个强大的API`_bulk`,它具备了批量操作的能力。 1. 批量添加两个Document ``` curl -X POST "localhost:9200/customer/_doc/_bulk?pretty" -H 'Content-Type: application/json' -d' {"index":{"_id":"11"}} {"name": "Milton" } {"index":{"_id":"22"}} {"name": "Cherish" } ' ``` 运行结果如下: ```cmd { "took" : 272, "errors" : false, "items" : [ { "index" : { "_index" : "customer", "_type" : "_doc", "_id" : "11", "_version" : 1, "result" : "created", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 0, "_primary_term" : 3, "status" : 201 } }, { "index" : { "_index" : "customer", "_type" : "_doc", "_id" : "22", "_version" : 1, "result" : "created", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 1, "_primary_term" : 3, "status" : 201 } } ] } ``` 通过上面可知,已经新增的两条Document 2. 批量更新和删除Document ``` curl -X POST "localhost:9200/customer/_doc/_bulk?pretty" -H 'Content-Type: application/json' -d' {"update":{"_id":"11"}} {"doc": { "name": "Milton Love Cherish" } } {"delete":{"_id":"22"}} ' ``` 运行结果如下: ```cmd { "took" : 269, "errors" : false, "items" : [ { "update" : { "_index" : "customer", "_type" : "_doc", "_id" : "11", "_version" : 2, "result" : "updated", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 1, "_primary_term" : 3, "status" : 200 } }, { "delete" : { "_index" : "customer", "_type" : "_doc", "_id" : "22", "_version" : 2, "result" : "deleted", "_shards" : { "total" : 2, "successful" : 1, "failed" : 0 }, "_seq_no" : 2, "_primary_term" : 3, "status" : 200 } } ] } ``` 通过上面的运行结果可知,更新与删除都成功了。