欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

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

程序员文章站 2022-07-06 10:17:41
...

基于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}
      }
    }
  }
}

--- 或  or

GET my - test / _search {
"query": {
"bool": {
"should": [{
"term": {
"name": "you"
}
}, {
"match": {
"age": 20
}
}]
}
}
}

---AND

GET 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 }
        }
      }
    }
  }
}

--- 必须不 not

GET 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"
        }
  }
}