kibana操作ElasticSearch

目录

列出所有的index

查看索引属性

列出所有的映射

查询type映射

索引属性-最大返回条数

查询type中所有数据

指定每页条数

单条件等值查询

单条件匹配查询

单条件分页查询

多条件匹配查询

清空所有数据

删除index

查询结果排序

范围查询

插入数据

增加映射

聚合统计

---

---

Elasticsearch: 权威指南 » 基础入门

列出所有的index

get /_cat/indices?v

查看索引属性

#查看索引
GET index_name/_settings?

列出所有的映射

get /_mapping?pretty=true

查询type映射

GET index_name/type_name/_mapping

索引属性-最大返回条数

PUT index_name/_settings
{
  "max_result_window" : "20000"
}

查询type中所有数据

GET index_name/type_name/_search
{
  "query": {
    "match_all": {}
  }
}

指定每页条数

GET index_name/type_name/_search
{
  "query": {
    "match_all": {}
  },
  "from": 0,
  "size": 1000
}

单条件等值查询

get index_name/type_name/_search
{
  "query": {
    "term": {
      "bank_card_no":"641690698b00e73ed74e088115fee683225b274de87275dd"
    }
  }
}

单条件匹配查询

GET index_name/type_name/_search
{
    "query":{
      "match": {
        "usr_no": "810133823347"
      }
    }
}

单条件分页查询

GET index_name/type_name/_search
{
  "query": {
    "match": {
      "payer_usr_no": "110135489151"
    }
  },"size": 100
}

多条件匹配查询

GET /index_name/type_name/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
          "base_handle_sys": "paybase"
          }
        },
        {
          "match": {
            "payer_card_type": "Balance"
          }
        }
      ]
    }
  }
}

清空所有数据

POST index_name/type_name/_delete_by_query?conflicts=proceed
{
  "query":{
    "match_all":{}
  }
}

删除index

DELETE /index_name

查询结果排序

GET index_name/type_name/_search
{
  "query": {
    "match": {
      "usr_no":"110000104500"
    }
  },"sort": [
    {
      "reg_dt_tm": {
        "order": "desc"
      }
    }
  ]
}

范围查询

GET /index_name/type_name/_search
{
   "query": {
    "range": {
      "tm_smp":{
        "gte":"20181218000000",
        "lte":"20181230235959"
      }
    }
  }
}

插入数据

POST index_name/type_name/810135262218
{
    "usr_no": "810135262218",
    "usr_prov": "四川省",
    "usr_city": "广安市"
}

增加映射

PUT /index_name/_mapping/type_name
{
  "properties": {
       "reg_dt_tm": {
           "type":"date",
           "format":"yyyyMMddHHmmss"
       },
       "last_order_dt": {
           "type":"date",
           "format":"yyyyMMdd"
       }
   }
}

聚合统计

Elasticsearch: 权威指南 » 聚合

根据通道、面额和运营商分组，统计平均回调时长

GET index_name/_search
{
  "size" : 0,
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "timeConsuming":{
              "gte":"0"
            }
          }
        },
        {
          "range": {
            "createDate":{
              "gte":"1639584000000",
              "lte":"1639670400000"
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "通道分组": {
      "terms": {
        "field": "channelName.keyword"
      },
      "aggs": {
        "面额": { 
            "terms": {
              "field": "flowAmount" 
            },
            "aggs": {
              "运营商": {
                "terms": {
                  "field": "phoneOperator" 
                },
                "aggs":{
                  "平均回调时间": {
                    "avg": {
                      "field": "timeConsuming"
                    }
                  }
                }
              }
            }
        }
      }
    }
  }
}