最近接触到elasticsearch,需要使用命令进行多种操作,由于对es不是很熟悉,记录一下常用的curl和kinaba命令。
1.查询es信息
curl
curl -XGET "http://192.168.10.101:9200/" -H "kbn-xsrf: reporting"
kibana
GET /
2.查询所有索引信息
curl
curl -XGET "http://192.168.10.101:9200/_cat/indices?v" -H "kbn-xsrf: reporting"
kibana
GET /_cat/indices?v
3.查询节点状态
curl
curl -XGET "http://192.168.10.101:9200/_cat/nodes?v" -H "kbn-xsrf: reporting"
kibana
GET /_cat/nodes?v
4.查询索引结构信息
curl
curl -XGET "http://192.168.10.101:9200/proof_data?pretty=true" -H "kbn-xsrf: reporting"
kibana
GET /proof_data?pretty=true
5.创建索引
curl
curl -XPUT "http://192.168.10.101:9200/new_index_data/" -H "kbn-xsrf: reporting" -H "Content-Type: application/json" -d'
{
"aliases" : { },
"mappings" : {
"properties" : {
"BIZ_ID" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"BIZ_TYPE_ID" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"CHANNEL" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"CREATE_TIME" : {
"type" : "date"
},
"ORGANIZE_CODE" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"TRANSACTION_ID" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"USER_ID" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"USE_ENCRYPT" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"id" : {
"type" : "long"
},
"virtual_channel_id" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
}
}
}
}'
kibana
PUT /new_index_data/
{
"aliases" : { },
"mappings" : {
"properties" : {
"BIZ_ID" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"BIZ_TYPE_ID" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"CHANNEL" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"CREATE_TIME" : {
"type" : "date"
},
"ORGANIZE_CODE" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"TRANSACTION_ID" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"USER_ID" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"USE_ENCRYPT" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"id" : {
"type" : "long"
},
"virtual_channel_id" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
}
}
}
}
6.查询索引的Settings配置
curl
curl -XGET "http://192.168.10.101:9200/new_index_data/_settings" -H "kbn-xsrf: reporting"
kibana
GET /new_index_data/_settings
7.查询索引下所有数据
curl
在search后面加上?pretty,能让返回的json格式化。
# 带条件查询
curl -XGET "http://192.168.10.101:9200/proof_data/_search" -H "kbn-xsrf: reporting" -H "Content-Type: application/json" -d'
{
"query": {
"match_all": {}
}
}'
# 不带条件查询
curl -XGET "http://192.168.10.101:9200/proof_data/_search" -H "kbn-xsrf: reporting"
kibana
GET /proof_data/_search
{
"query": {
"match_all": {}
}
}
8.查询索引下数据总量
curl
curl -XGET "http://192.168.10.101:9200/proof_data/_count" -H "kbn-xsrf: reporting"
kibana
GET /proof_data/_count
9.删除索引
curl
curl -XDELETE "http://192.168.10.101:9200/new_index_data/" -H "kbn-xsrf: reporting"
kibana
DELETE /new_index_data/
10.删除索引下的数据
curl
curl -XPOST "http://192.168.10.101:9200/index_name/_delete_by_query" -H "kbn-xsrf: reporting" -H "Content-Type: application/json" -d'
{
"query":{
"match_all":{}
}
}'
此语句可以根据query条件,进行选择性删除数据。
kibana
POST /index_name/_delete_by_query
{
"query":{
"match_all":{}
}
}
11.查询es健康状况
curl
curl -XGET "http://192.168.10.101:9200/_cat/health?v" -H "kbn-xsrf: reporting"
kibana
GET /_cat/health?v