索引:
关键词:
索引_index:(相当于数据库名称)
类型 _type:(相当于库中的表)
创建索引
PUT 192.168.100.88:9200/log_demo?pretty
{
"settings":{
"number_of_shards":3,
"number_of_replicas":2
},
"mappings":{
"log_doc":{
"properties":{
"id": {
"type": "string"
},
"staffName": {
"type": "string"
},
"userId": {
"type": "string"
},
"opTitle": {
"type": "string"
},
"opType": {
"type": "string"
},
"createDate": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss"
},
"loginIp": {
"type": "string"
},
"userAgent": {
"type": "string"
},
"requestUrl": {
"type": "string"
},
"method": {
"type": "string"
},
"exception": {
"type": "string"
},
"rev": {
"type": "string"
},
"username":{
"type": "string"
}
}
}
}
}
查看索引:
查看索引设置
GET 192.168.100.88:9200/log_demo/_settings
查看索引映射:
查看索引状态
GET 192.168.100.88:9200/_cat/indices?v
在索引中添加文档数据
POST 192.168.100.88:9200/log_demo/log_doc
{
"id": "200",
"staffName": "this is a random test ",
"userId": "0002",
"opTitle": "POST方式向文档添加数据",
"opType": "添加",
"createDate": "2018-01-12 12:10:10",
"loginIp": "192.168.100.88",
"userAgent": "谷歌浏览器",
"requestUrl": "192.168.100.88:9200/log_index/log_type",
"method": "方法",
"exception": "无",
"rev": "1",
"username": "admin"
}
删除索引:
DELETE 192.168.100.88:9200/log_demo/
文档:
查看文档所有信息
GET 192.168.100.88:9200/log_demo/log_doc/_search
按条件查询文档中信息
单条件
查询方式一:查询id为100的文档信息(注意格式)
GET 192.168.100.88:9200/log_demo/log_doc/_search?q=id:100
查询方式二:注请求体必须是json格式(可以使用json转化工具)
请求头:
GET 192.168.100.88:9200/log_demo/log_doc/_search
请求体:
{
"query": {
"match": {
"username": "admin100"
}
}
}
多个条件查询
请求头:
GET 192.168.100.88:9200/log_demo/log_doc/_search
请求体:
{
"query": {
"bool": {
"must": {
"match": {
"username": "admin100"
}
},
"should": [
{
"match": {
"id": 100
}
}
],
"minimum_should_match": 1
}
}
}
请求头
GET 192.168.100.88:9200/log_demo/log_doc/_search
请求体:
{
"query": {
"bool": {
"must": {
"match": {
"username": "admin100"
}
},
"should": [
{
"match": {
"id": 100
}
},
{
"bool": {
"must": {
"match": {
"userId": "200"
}
},
"must_not": {
"match": {
"userAgent": "谷歌浏览器"
}
}
}
}
],
"minimum_should_match": 1
}
}
}
删除文档数据
请求头:
DELETE 192.168.100.88:9200/log_demo/log_doc/_search
请求体:
{
"query": {
"bool": {
"must": {
"match": {
"username": "admin100"
}
}
}
}
}
注意:删除和查询的语法一样只是请求头是DELETE
----------------------------------更新一波---------------------------------
添加字段
请求头:
put 192.168.100.88:9200/log_index/_mapping/log_type
请求体:
{
"properties": {
"timeformat": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss"
}
}
}
测试一下字段是否添加成功
字段赋值
请求头:
POST 192.168.100.88:9200/log_index/log_type/_update?pretty
请求体:
{
"doc" :{"timeformat": "2021-06-04 19:40:00" }
}
请求头:
PUT 192.168.100.88:9200/log_index/_mapping/log_type
请求体:
{
"log_type": {
"properties": {
"english_title": {
"type": "string",
"analyzer": "english"
}
}
}
}
参考文档