基于kibana的Dev Tools控制板上es常用查询语句

基于kibana的Dev Tools控制板上es常用查询语句

1、集群相关

--- 查询集群健康状态    GET _cluster/health--- 查询所有节点    GET _cat/nodes--- 查询索引及分片的分布    GET _cat/shards--- 查询所有插件    GET _cat/plugins

2、索引相关查询

--- 查询所有索引及容量    GET _cat/indices--- 查询索引映射结构    GET my_index/_mapping--- 查询所有索引映射结构        GET _all--- 查询所有的相同前缀索引    GET my-*/_search--- 查询所有索引模板       GET _template--- 查询具体索引模板    GET _template/my_template

3.索引的操作

  1、写入索引模板
PUT _template/my_template{    "template" : "my-*",    "order" : 0,    "settings" : {        "number_of_shards" : 10, "number_of_replicas" : 0    },    "mappings": {      "default": {  "_all": {        "enabled": false      },        "properties": {          "name": {            "type": "text"          },          "age": {            "type": "long"          }        }    }  }}
  2、创建索引映射结构
PUT my_index{  "mappings": {    "doc": {      "properties": {        "name": {          "type": "text"        },        "blob": {          "type": "binary"        }      }    }  }}
  3、写入索引
PUT my_index/doc/1{  "name": "Some binary blob",  "blob": "U29tZSBiaW5hcnkgYmxvYg==" }
  4、删除索引
DELETE my-index
  5、DSL query查询
a、查询所有GET _search{  "query": {    "match_all": {}  }}b、查询单个索引 的 固定属性--- 精确匹配GET _search{  "query": {    "term": { "name" : "you" }  }}--- 模糊匹配GET _search{  "query": {    "match": { "name" : "you" }  }}--- 范围查找GET _search{  "query": {    "range": {        "age":{ "gte" : 15 , "lte" : 25 }    }  }}c、功能性查询--- 过滤GET my_index/_search{  "query": {    "bool": {      "filter": {        "term":{"age":1095}      }    }  }}--- 或  orGET my - test / _search {"query": {"bool": {"should": [{"term": {"name": "you"}}, {"match": {"age": 20}}]}}}--- 与 ANDGET my-test/_search{  "query": {    "bool": {      "must" : [{        "match" : {          "name" : "you"        }      },{        "range":{        "age":{          "from" : 10 , "to" : 20        }         }      }]    }  }}---必须 =GET my_index/_search{  "query": {    "bool": {      "must" : {        "range" : {          "age" : { "from" : 10, "to" : 20 }        }      }    }  }}--- 必须不 notGET my_index/_search{  "query": {    "bool": {      "must_not" : {        "term" : {          "name" : "you"        }      }    }  }}d、复合查找GET my_index/_search {"query": {"bool": {"should": [{"match": {"age": 40}}, {"match": {"age": 20}}],"filter": {  "match":{    "name":"you"  }}}}}e、索引迁移--- 场景 从A索引 复制到B索引POST _reindex{  "source": {    "index": "my_index"  },  "dest": {    "index": "new_my_index"  }}f、基于查询的删除POST test-index/_delete_by_query{  "query":{        "term": {         "cameraId":"00000000002"        }  }}--- 查询GET test-index/_search{  "query":{        "term": {         "cameraId":"00000000002"        }  }}

  

推荐阅读