Elasticsearch系列(三):kibana使用

红小豆你要坚强

于 2020-12-11 23:53:53 发布

阅读量115

点赞数

分类专栏：搜索引擎文章标签： elasticsearch

本文链接：https://blog.csdn.net/qq_35853455/article/details/111055110

版权

搜索引擎专栏收录该内容

3 篇文章 0 订阅

订阅专栏

前言

Dev Tools中输入命令

一、简单命令 (增删改查)

1、新增

# 指定id为1
PUT /megacorp/employee/1
{
    "first_name" : "John",
    "last_name" :  "Smith",
    "age" :        25,
    "about" :      "I love to go rock climbing",
    "interests": [ "sports", "music" ]
}

#不指定id
POST /website/blog/
{
  "title": "My second blog entry",
  "text":  "Still trying this out...",
  "date":  "2014/01/01"
}

2、查询

2.1 根据id查询

GET /megacorp/employee/1

2.2查询employee类型的所有数据

GET /megacorp/employee/_search

2.3 查询某个属性

GET /megacorp/employee/_search?q=last_name:Smith

GET /megacorp/employee/_search
{
    "query" : {
        "match" : {
            "last_name" : "Smith"
        }
    }
}

2.4 搜索姓氏为 Smith 的员工，且年龄大于 30

GET /megacorp/employee/_search
{
    "query" : {
        "bool": {
            "must": {
                "match" : {
                    "last_name" : "smith" 
                }
            },
            "filter": {
                "range" : {
                    "age" : { "gt" : 30 } 
                }
            }
        }
    }
}

2.5 所有喜欢攀岩（rock climbing）的员工

#有rock 或者climbing就可以
GET /megacorp/employee/_search
{
    "query" : {
        "match" : {
            "about" : "rock climbing"
        }
    }
}

#必须有rock climbing
GET /megacorp/employee/_search
{
    "query" : {
        "match_phrase" : {
            "about" : "rock climbing"
        }
    }
}

2.6 高亮选择

GET /megacorp/employee/_search
{
    "query" : {
        "match_phrase" : {
            "about" : "rock climbing"
        }
    },
    "highlight": {
        "fields" : {
            "about" : {}
        }
    }
}

2.7 最受欢迎的兴趣爱好

GET /megacorp/employee/_search
{
  "aggs": {
    "all_interests": {
      "terms": { "field": "interests" }
    }
  }
}

2.8 Smith 的员工中最受欢迎的兴趣爱好

GET /megacorp/employee/_search
{
  "query": {
    "match": {
      "last_name": "smith"
    }
  },
  "aggs": {
    "all_interests": {
      "terms": {
        "field": "interests"
      }
    }
  }
}

2.9查询特定兴趣爱好员工的平均年龄

GET /megacorp/employee/_search
{
    "aggs" : {
        "all_interests" : {
            "terms" : { "field" : "interests" },
            "aggs" : {
                "avg_age" : {
                    "avg" : { "field" : "age" }
                }
            }
        }
    }
}