ES API，使用Kibana的开发工具用例说明

原创

刘大猫

发布于 2024-11-02 21:27:06

860

发布于 2024-11-02 21:27:06

文章被收录于专栏：ElasticSearch

@TOC

创建template，用于滚动索引

PUT _template/test-logs
{
  "index_patterns": "test-logs-*",
  "settings": {
		"number_of_shards": 5,
		"number_of_replicas": 1,
		"analysis": {
      "analyzer": {
        "my_analyzer": {
          "type": "pattern",
          "pattern":["_","-"]
        }
      }
    }
	},
	"aliases": {
    "test-logs-read": {}
  },
  "mappings": {
    "_doc":{
      "properties": {
				"file_name": {
					"type": "text"
				},
				"table": {
				  "type": "text",
					"analyzer": "my_analyzer"
				},
				"size": {
					"type": "text",
					"index": false
				}
			}
    }
  }
}

判断template是否存在

HEAD _template/test-logs

测试自定义解析器

POST my_index1/_analyze
{
  "analyzer": "my_analyzer",
  "text": "103_addserialnumber-1"
}

测试内置解析器

GET _analyze
{
  "analyzer": "ik_smart", 
  "text": "五常大米"
}

查index信息

GET /test-logs-100000

添加document

POST /test-logs-write/_doc
{
  "name":"mao",
  "sex" :"Male"
}

查index下document全部信息

GET /test-logs-read/_search
{
   "query": {
        "match_all": {}
    },
    "from":0,
    "size": 10
}

查所有template

GET  _cat/templates/

删除index

DELETE /test-logs-write

查某一template信息

GET _template/test-logs

模糊搜索+高亮显示

GET 12_assets_directory_v1/_doc/_search
{
    "query": {
        "multi_match":{
            "query": "月份",
            "fields": ["file_name","database_name","table_name"]                  
        }
    },
    "highlight": {
        "fields": {
            "file_name":{
                 "pre_tags": "<font color=red>",
                "post_tags": "</font>"
            },"database_name":{
                 "pre_tags": "<font color=red>",
                "post_tags": "</font>"
            },"table_name":{
                 "pre_tags": "<font color=red>",
                "post_tags": "</font>"
            }
        }
    },
    "sort": [
      {"_score": {"order": "desc"}},
      {"_doc": {"order": "desc"}}
    ],
    "from":0,
    "size": 2
}

设置滚动索引

OST index_alias_name/_rollover/
    {
      "conditions": {
        "max_age": "7d", //设置：最大时间7天
        "max_docs": 10000,//设置：最大文档记录数
        "max_size":  "5gb" //设置：索引最大容量
      }
    }

批量插入

POST _bulk/?refresh=true
{ "index" : { "_index" : "12_assets_directory_v1","_type" : "_doc" }}
{ "file_name": "Lucene is cool","file_type": "file","database_name": "","table_name": "","include_fields": "","source_business": 1,"store_type": "hdfs","whether_online": 0,"foreign_id": 10,"update_time": 1618560193000}
{ "index" : { "_index" : "12_assets_directory_v1","_type" : "_doc" }}
{ "file_name": "hdfs用户文件","file_type": "file","database_name": "","table_name": "","include_fields": "","source_business": 1,"store_type": "hdfs","whether_online": 0,"foreign_id": 11,"update_time": 1618560193010}
{ "index" : { "_index" : "12_assets_directory_v1","_type" : "_doc" }}
{ "file_name": "","file_type": "table","database_name": "geespace_bd_platform_dev","table_name": "12_mysql-1","include_fields": "","source_business": 1,"store_type": "mysql","whether_online": 0,"foreign_id": 10,"update_time": 1618560193020}
{ "index" : { "_index" : "12_assets_directory_v1","_type" : "_doc" }}
{ "file_name": "","file_type": "table","database_name": "geespace_bd_platform_dev","table_name": "103_addserialnumber_2","include_fields": "","source_business": 1,"store_type": "mysql","whether_online": 0,"foreign_id": 11,"update_time": 1618560193030}

==注意：每个json串不能换行，只能放到一行==

详情查看->https://blog.csdn.net/chen18677338530/article/details/93067493