es数据插入和查询

目录

• 1、es数据插入
  • 1)批量插入
  • 2)单条插入
• 2、es数据查询
  • 1）查询索引全部数据
  • 2）删除索引全部数据
  • 3）索引创建
  • 4）带条件的查询
• 3、es启动命令

1、es数据插入

es入库字段不可超过1000个字段，超过后无法存入es。建议不超过20个字段

1)批量插入

请求路径 IP:端口/_bulk，每条数据前加具体索引信息

{"index":{"_index": "jzms_monitor_info_1","_type": "_doc"}}
说明：jzms_monitor_info_1是索引名
以下是发送2条请求报文：
{"index":{"_index": "jzms_monitor_info_1","_type": "_doc"}}
{"appName" : "应用11","appId" : "1111","requestAppID" : "222","startTime" : "20210901101010","requestAppName" : "应用2","id" : "21c02e722fdb4141bdc365d01b45262c","serviceID" : "440000-zfba-xsajbl-la","requestData" : {"ajbh" : "123456","acbrsfzh1" : "44"},"apiID" : "/api/v1/zfba-xsajbl-la/lahgxjcUsingPOST","reportTime":"20211201101010"}
{"index":{"_index": "jzms_monitor_info_1","_type": "_doc"}}
{"appName" : "应用12","appId" : "1111","requestAppID" : "222","startTime" : "20210901101010","requestAppName" : "应用2","id" : "21c02e722fdb4141bdc365d01b45262c","serviceID" : "440000-zfba-xsajbl-la","requestData" : {"ajbh" : "123456","acbrsfzh1" : "22"},"apiID" : "/api/v1/zfba-xsajbl-la/lahgxjcUsingPOST","reportTime":"20211201101010"}

执行成功的返回

2)单条插入

请求路径：IP:端口/索引名/_doc
请求报文放入请求数据即可。

2、es数据查询

1）查询索引全部数据

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

2）删除索引全部数据

这种方法删除速度比较慢
POST /jzms_monitor_info/_delete_by_query?pretty
{
"query": {
"match_all": {}
}
}
kibana平台上直接删除索引再重建索引较快，如下所示：

3）索引创建

PUT /jzms_monitor_info

{
"settings": {
"number_of_shards": 1
},
"mappings": {
"_doc": {
"properties": {
"appId": { "type": "keyword" },
"appName": { "type": "text" },
"reportTime": { "type": "keyword" },
"serviceID": { "type": "keyword" },
"serviceType": { "type": "keyword" },
"apiID": { "type": "keyword" },
"startTime": { "type": "keyword" },
"requestAppId": { "type": "keyword" },
"requestAppName": { "type": "text" },
"requestData": {
"type": "object",
"dynamic": true
}
}
}
}
}

4）带条件的查询

3、es启动命令

service elasticsearch start