Kibana可视化操作CRUD案例

一、找到Dev Tools

二、CRUD案例

1）、添加索引

###创建索引
PUT /zhq

#! Deprecation: the default number of shards will change from [5] to [1] in 7.0.0; if you wish to continue using the default of [5] shards, you must manage this on the create index request or with an index template
{
  "acknowledged": true,
  "shards_acknowledged": true,
  "index": "zhq"
}

2）、获取索引

###获取索引
GET /zhq

{
  "zhq": {
    "aliases": {},
    "mappings": {},
    "settings": {
      "index": {
        "creation_date": "1588556203297",
        "number_of_shards": "5",
        "number_of_replicas": "1",
        "uuid": "xq06H6tBThKp3U_GbOHr_Q",
        "version": {
          "created": "6040399"
        },
        "provided_name": "zhq"
      }
    }
  }
}

3）、创建文档

自定义文件属性类型
POST /zhq/_mapping/user
{
  "user":{
    "properties":{
       "age":{
         "type":"integer"
       },
        "sex":{
         "type":"integer"
       },
       "name":{
         "type":"text",
         "analyzer":"ik_smart",
         "search_analyzer":"ik_smart"
       }
    }
  }
}

###创建文档 /索引/类型/id
PUT /zhq/user/1
{
  "name":"吴芳金",
  "age":18,
  "sex":0
}

{
  "_index": "zhq",
  "_type": "user",
  "_id": "1",
  "_version": 1,
  "result": "created",
  "_shards": {
    "total": 2,
    "successful": 1,
    "failed": 0
  },
  "_seq_no": 0,
  "_primary_term": 1
}

4）、获取文档

###获取文档
GET /zhq/user/1

{
  "_index": "zhq",
  "_type": "user",
  "_id": "1",
  "_version": 1,
  "found": true,
  "_source": {
    "name": "吴芳金",
    "age": 18,
    "sex": 0
  }
}

5）、修改文档

###修改文档
PUT /zhq/user/1
{
  "name":"吴芳金",
  "age":19,
  "sex":0
}

{
  "_index": "zhq",
  "_type": "user",
  "_id": "1",
  "_version": 2,
  "result": "updated",
  "_shards": {
    "total": 2,
    "successful": 1,
    "failed": 0
  },
  "_seq_no": 1,
  "_primary_term": 1
}

6）、删除

###删除
DELETE zhq

{
  "acknowledged": true
}

7）、查询当前所有类型的文档

GET /zhq/user/_search

8）、多个id批量查询

GET /zhq/user/_mget
{
  "ids":["1","2"]
}

9）、复制条件查询

查询年龄为年龄18岁
GET /zhq/user/_search?q=age:18

查询年龄18岁-21岁之间

GET /zhq/user/_search?q=age[18 TO 21]
注意:TO 一定要大写

查询年龄18岁-30岁之间 并且年龄降序、从0条数据到第1条数据
GET /zhq/user/_search?q=age[18 TO 30]&sort=age:desc&from=0&size=1

查询年龄30岁-60岁之间 并且年龄降序、从0条数据到第1条数据,展示name和age字段

GET /zhq/user/_search?q=age[30 TO 60]&sort=age:desc&from=0&size=1
&_source=name,age

10）、DSL语言查询与过滤

term根据名称精确查询姓名(中文支持不友好)
GET /zhq/user/_search
{
  "query": {
    "term": {
      "name": "xiaojin"
    }
  }
}
match模糊名称查询姓名
GET /zhq/user/_search
{
  "from": 0,
  "size": 2, 
  "query": {
    "match": {
     "name": "小金"
    }
  }
}
filter复杂查询
GET /zhq/user/_search
{
	"query": {
		"bool": {
			"must": [{
				"match_all": {}
			}],
			"filter": {
				"range": {
					"age": {
						"gt": 18,
						"lte": 30
					}
				}
			}
		}
	},
	"from": 0,
	"size": 10,
	"_source": ["name", "age"]
}