Heartsuit's Simple Blog

A place to hold mainly reading notes, and some technical stuff occasionally. 这里主要是一些读书笔记、感悟；还有部分技术相关的内容。

Project maintained by heartsuit Hosted on GitHub Pages — Theme by mattgraham

ElasticSearch入门（二）批量导入数据（Postman与Kibana）

发布：2020-02-23 Sunday 标签：ElasticSearch

目录[-]

背景

前面安装运行了ElasticSearch，在实际操作之前，先准备好数据，实际中一般是通过Logstash等插件实现其他数据库到ElasticSearch的同步，这里的演示采用直接导入的方式。

ElasticSearch官方有个数据集，文件内容的格式以行分隔：

每两行为一组，第一行指定索引id（也可为空），第二行为实际的数据体。

{"index":{"_id":"1"}}
{"account_number":1,"balance":39225,"firstname":"Amber","lastname":"Duke","age":32,"gender":"M","address":"880 Holmes Lane","employer":"Pyrami","email":"amberduke@pyrami.com","city":"Brogan","state":"IL"}
...省略

以下提供两种方法批量导入数据到ES的bank索引：Postman与Kibana。通过ES提供的_bulk API完成批量导入。

方法一：通过Postman完成数据批量导入

首先在Postman中新建 POST 请求：localhost:9200/bank/_bulk, 请求体Body下选择binary二进制, 然后Select File选择对应的json文件, 最后点击Send发送请求即可，见下图。

方法二：通过Kibana完成数据批量导入

依次启动ElasticSearch、Kibana，Kibana默认启动在5601端口，打开（Dev Tools）开发工具。

左侧为请求编辑区，右侧为对应的响应。在左侧输入：

POST bank/_bulk
{"index":{"_id":"1"}}
{"account_number":1,"balance":39225,"firstname":"Amber","lastname":"Duke","age":32,"gender":"M","address":"880 Holmes Lane","employer":"Pyrami","email":"amberduke@pyrami.com","city":"Brogan","state":"IL"}
{"index":{"_id":"6"}}
{"account_number":6,"balance":5686,"firstname":"Hattie","lastname":"Bond","age":36,"gender":"M","address":"671 Bristol Street","employer":"Netagy","email":"hattiebond@netagy.com","city":"Dante","state":"TN"}
...省略

点击运行，Kibana中的执行结果为：

验证：查询索引中所有数据

在Postman中发送Post请求：localhost:9200/bank/_search，请求体：

{
	"query":{
		"match_all": {}
	}
}

得到bank索引中所有1000条数据，表明批量导入操作成功：

批量删除

有时候会有批量删除的需求，尤其是在测试或演示时。

清空索引

仅删除数据，保留索引以及映射。在Postman中发送Post请求：localhost:9200/bank/_delete_by_query，请求体：

{
	"query":{
		"match_all": {}
	}
}

删除索引

在Postman中发送Delete请求：localhost:9200/bank，无参数。

Notes: 删除索引为高危操作，谨慎使用！！😎

If you have any questions or any bugs are found, please feel free to contact me.

Your comments and suggestions are welcome!