6-Elasticsearch基础查询

已于 2023-03-24 16:57:34 修改
阅读量254 收藏
点赞数 1
分类专栏： Elasticsearch 文章标签： elasticsearch
于 2023-03-10 10:42:50 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zx_1305769448/article/details/129438068
版权

Elasticsearch查询

批量插入

_bulk

# 批量插入数据
POST student_info_index/_bulk
{"index":{}}
{"student_name":"张三","address":"中国 北京","age":35}
{"index":{}}
{"student_name":"李四","address":"中国 上海","age":32}
{"index":{}}
{"student_name":"王五","address":"美国 华盛顿","age":25}
{"index":{}}
{"student_name":"赵六","address":"英国 伦敦","age":28}
{"index":{}}
{"student_name":"田七","address":"中国 台湾","age":40}

POST student_info_index/_search

结果：

{
  "took" : 8,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 5,
      "relation" : "eq"
    },
    "max_score" : 1.0,
    "hits" : [
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eADUw4YBnnKcIM3DJ_jF",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "张三",
          "address" : "中国 北京",
          "age" : 35
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eQDUw4YBnnKcIM3DJ_jS",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "李四",
          "address" : "中国 上海",
          "age" : 32
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "egDUw4YBnnKcIM3DJ_jS",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "王五",
          "address" : "美国 华盛顿",
          "age" : 25
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "ewDUw4YBnnKcIM3DJ_jS",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "赵六",
          "address" : "英国 伦敦",
          "age" : 28
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "fADUw4YBnnKcIM3DJ_jS",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "田七",
          "address" : "中国 台湾",
          "age" : 40
        }
      }
    ]
  }
}
查询所有数据

{
“query”: {
“match_all”: {}
}
}

语句：

GET student_info_index/_search
{
  "query": {
    "match_all": {}
  }
}

结果：

{
  "took" : 2, # 查询耗时，单位毫秒
  "timed_out" : false, # 是否超时
  "_shards" : { # 查询使用的分片信息
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 5, # 查询到匹配文档数量
      "relation" : "eq"
    },
    "max_score" : 1.0, # 查询文档的最高分，分数越高，匹配度越高
    "hits" : [
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eADUw4YBnnKcIM3DJ_jF",
        "_score" : 1.0, # 当前文档和查询内容的匹配度
        "_source" : {
          "student_name" : "张三",
          "address" : "中国 北京",
          "age" : 35
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eQDUw4YBnnKcIM3DJ_jS",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "李四",
          "address" : "中国 上海",
          "age" : 32
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "egDUw4YBnnKcIM3DJ_jS",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "王五",
          "address" : "美国 华盛顿",
          "age" : 25
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "ewDUw4YBnnKcIM3DJ_jS",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "赵六",
          "address" : "英国 伦敦",
          "age" : 28
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "fADUw4YBnnKcIM3DJ_jS",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "田七",
          "address" : "中国 台湾",
          "age" : 40
        }
      }
    ]
  }
}
排序查询

“sort”: [
{
“age”: {
“order”: “desc”
}
}
]

排序字段不可以是text等特殊类型，一般是整数或keyword类型

语句：

# 按照年级倒序
GET student_info_index/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {
      "age": {
        "order": "desc"
      }
    }
  ]
}

排序前的结果，查看以上结果

排序后的结果：

{
  "took" : 45,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 5,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "fADUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "田七",
          "address" : "中国 台湾",
          "age" : 40
        },
        "sort" : [
          40
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eADUw4YBnnKcIM3DJ_jF",
        "_score" : null,
        "_source" : {
          "student_name" : "张三",
          "address" : "中国 北京",
          "age" : 35
        },
        "sort" : [
          35
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eQDUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "李四",
          "address" : "中国 上海",
          "age" : 32
        },
        "sort" : [
          32
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "ewDUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "赵六",
          "address" : "英国 伦敦",
          "age" : 28
        },
        "sort" : [
          28
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "egDUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "王五",
          "address" : "美国 华盛顿",
          "age" : 25
        },
        "sort" : [
          25
        ]
      }
    ]
  }
}

多字段排序

# 多字段排序
GET student_info_index/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {
      "age": {
        "order": "desc"
      },
      "student_name.keyword": {
        "order": "desc"
      }
    }
  ]
}

结果：

{
  "took" : 168,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 5,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "fADUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "田七",
          "address" : "中国 台湾",
          "age" : 40
        },
        "sort" : [
          40,
          "田七"
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eADUw4YBnnKcIM3DJ_jF",
        "_score" : null,
        "_source" : {
          "student_name" : "张三",
          "address" : "中国 北京",
          "age" : 35
        },
        "sort" : [
          35,
          "张三"
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eQDUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "李四",
          "address" : "中国 上海",
          "age" : 32
        },
        "sort" : [
          32,
          "李四"
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "ewDUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "赵六",
          "address" : "英国 伦敦",
          "age" : 28
        },
        "sort" : [
          28,
          "赵六"
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "egDUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "王五",
          "address" : "美国 华盛顿",
          "age" : 25
        },
        "sort" : [
          25,
          "王五"
        ]
      }
    ]
  }
}
查询指定字段信息

“_source”: [“student_name”,“age”]

语句：

# 查询指定字段
GET student_info_index/_search
{
  "query": {
    "match_all": {}
  },
  "_source": ["student_name","age"],
  "sort": [
    {
      "age": {
        "order": "desc"
      }
    }
  ]
}

结果：

{
  "took" : 12,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 5,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "fADUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "田七",
          "age" : 40
        },
        "sort" : [
          40
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eADUw4YBnnKcIM3DJ_jF",
        "_score" : null,
        "_source" : {
          "student_name" : "张三",
          "age" : 35
        },
        "sort" : [
          35
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eQDUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "李四",
          "age" : 32
        },
        "sort" : [
          32
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "ewDUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "赵六",
          "age" : 28
        },
        "sort" : [
          28
        ]
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "egDUw4YBnnKcIM3DJ_jS",
        "_score" : null,
        "_source" : {
          "student_name" : "王五",
          "age" : 25
        },
        "sort" : [
          25
        ]
      }
    ]
  }
}
分页查询

“from”:0

“size”:3

语句：

GET student_info_index/_search
{
  "query": {
    "match_all": {}
  },
  "_source": [
    "student_name",
    "address"
  ],
  "from": 0,
  "size": 3
}

结果：

{
  "took" : 9,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 5,
      "relation" : "eq"
    },
    "max_score" : 1.0,
    "hits" : [
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eADUw4YBnnKcIM3DJ_jF",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "张三",
          "address" : "中国 北京"
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eQDUw4YBnnKcIM3DJ_jS",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "李四",
          "address" : "中国 上海"
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "egDUw4YBnnKcIM3DJ_jS",
        "_score" : 1.0,
        "_source" : {
          "student_name" : "王五",
          "address" : "美国 华盛顿"
        }
      }
    ]
  }
}
查询指定字段的特定内容

语句：

GET student_info_index/_search
{
  "query": {
    "match": {
      "address": "中"
    }
  }
}

结果：

{
  "took" : 124,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 3,
      "relation" : "eq"
    },
    "max_score" : 0.549705,
    "hits" : [
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eADUw4YBnnKcIM3DJ_jF",
        "_score" : 0.549705,
        "_source" : {
          "student_name" : "张三",
          "address" : "中国 北京",
          "age" : 35
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eQDUw4YBnnKcIM3DJ_jS",
        "_score" : 0.549705,
        "_source" : {
          "student_name" : "李四",
          "address" : "中国 上海",
          "age" : 32
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "fADUw4YBnnKcIM3DJ_jS",
        "_score" : 0.549705,
        "_source" : {
          "student_name" : "田七",
          "address" : "中国 台湾",
          "age" : 40
        }
      }
    ]
  }
}
段落查询

语句：

GET student_info_index/_search
{
  "query": {
    "match_phrase": {
      "address": "中国 上海"
    }
  }
}

结果：

{
  "took" : 344,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 1,
      "relation" : "eq"
    },
    "max_score" : 3.4661183,
    "hits" : [
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eQDUw4YBnnKcIM3DJ_jS",
        "_score" : 3.4661183,
        "_source" : {
          "student_name" : "李四",
          "address" : "中国 上海",
          "age" : 32
        }
      }
    ]
  }
}
段落前缀查询

语句：

GET student_info_index/_search
{
  "query": {
    "match_phrase_prefix": {
      "address": "中国"
    }
  }
}

结果：

{
  "took" : 8,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 3,
      "relation" : "eq"
    },
    "max_score" : 0.63844514,
    "hits" : [
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eADUw4YBnnKcIM3DJ_jF",
        "_score" : 0.63844514,
        "_source" : {
          "student_name" : "张三",
          "address" : "中国 北京",
          "age" : 35
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "eQDUw4YBnnKcIM3DJ_jS",
        "_score" : 0.63844514,
        "_source" : {
          "student_name" : "李四",
          "address" : "中国 上海",
          "age" : 32
        }
      },
      {
        "_index" : "student_info_index",
        "_type" : "_doc",
        "_id" : "fADUw4YBnnKcIM3DJ_jS",
        "_score" : 0.63844514,
        "_source" : {
          "student_name" : "田七",
          "address" : "中国 台湾",
          "age" : 40
        }
      }
    ]
  }
}
精确查询

数据准备


# 三国人物信息索引映射
PUT person_info_index
{
  "mappings": {
    "properties": {
      "name": {
        "type": "keyword"
      },
      "nationality": {
        "type": "text",
        "analyzer": "ik_max_word",
        "search_analyzer": "standard"
      },
      "age":{
        "type": "integer"
      }
    }
  }
}

# 批量插入
POST person_info_index/_bulk
{"index":{}}
{"name":"曹操","nationality":"魏国","age":45}
{"index":{}}
{"name":"夏侯淳","nationality":"魏国","age":36}
{"index":{}}
{"name":"曹昂","nationality":"魏国","age":32}
{"index":{}}
{"name":"刘备","nationality":"蜀国","age":42}
{"index":{}}
{"name":"关羽","nationality":"蜀国","age":41}
{"index":{}}
{"name":"张飞","nationality":"蜀国","age":39}
{"index":{}}
{"name":"孙权","nationality":"吴国","age":26}
{"index":{}}
{"name":"周瑜","nationality":"吴国","age":30}
match查询

GET person_info_index/_search
{
  "query": {
    "match": {
      "nationality": "吴国"
    }
  }
}

结果：返回结果没有匹配到文档数据。

{
  "took" : 218,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 0,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [ ]
  }
}

分析：nationality进过ik_max_word分词后，依旧是原来的词汇，而查询时使用standard分词，会把单个汉字作为term，所以查不到。

term查询

精准查询不对查询内容分词

语句：

GET person_info_index/_search
{
  "query": {
    "term": {
      "nationality": "吴国"
    }
  }
}

结果：

{
  "took" : 6,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 2,
      "relation" : "eq"
    },
    "max_score" : 1.2809337,
    "hits" : [
      {
        "_index" : "person_info_index",
        "_type" : "_doc",
        "_id" : "gwAHxIYBnnKcIM3D3_jm",
        "_score" : 1.2809337,
        "_source" : {
          "name" : "孙权",
          "nationality" : "吴国",
          "age" : 26
        }
      },
      {
        "_index" : "person_info_index",
        "_type" : "_doc",
        "_id" : "hAAHxIYBnnKcIM3D3_jm",
        "_score" : 1.2809337,
        "_source" : {
          "name" : "周瑜",
          "nationality" : "吴国",
          "age" : 30
        }
      }
    ]
  }
}
bool多条件查询

语句：


GET person_info_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "age": 30
          }
        }
      ],
      "must_not": [
        {
          "term": {
            "nationality": "吴国"
          }
        }
      ]
    }
  }
}

结果：

{
  "took" : 5,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 0,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [ ]
  }
}
bool和filter组合查询

语句


GET person_info_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "nationality": "蜀国"
          }
        }
      ],
      "filter": [
        {
          "range": {
            "age": {
              "gte": 40,
              "lte": 50
            }
          }
        }
      ]
    }
  }
}

结果：

{
  "took" : 12,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 2,
      "relation" : "eq"
    },
    "max_score" : 0.9444616,
    "hits" : [
      {
        "_index" : "person_info_index",
        "_type" : "_doc",
        "_id" : "gAAHxIYBnnKcIM3D3_jm",
        "_score" : 0.9444616,
        "_source" : {
          "name" : "刘备",
          "nationality" : "蜀国",
          "age" : 42
        }
      },
      {
        "_index" : "person_info_index",
        "_type" : "_doc",
        "_id" : "gQAHxIYBnnKcIM3D3_jm",
        "_score" : 0.9444616,
        "_source" : {
          "name" : "关羽",
          "nationality" : "蜀国",
          "age" : 41
        }
      }
    ]
  }
}
简单聚合

数据准备：

# 学员成绩
POST stu_score_index/_bulk
{"index":{}}
{"stu_name":"张三","class_name":"高三一班","age":10,"score":58}
{"index":{}}
{"stu_name":"李四","class_name":"高三一班","age":10,"score":68}
{"index":{}}
{"stu_name":"王五","class_name":"高三二班","age":10,"score":78}
{"index":{}}
{"stu_name":"赵六","class_name":"高三二班","age":10,"score":88}
{"index":{}}
{"stu_name":"田七","class_name":"高三三班","age":10,"score":98}
{"index":{}}
{"stu_name":"钱八","class_name":"高三三班","age":10,"score":48}
分组统计各组总条数-count

语句：


GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "group_by_class_name": {
      "terms": {
        "field": "class_name.keyword"
      }
    }
  }
}

结果：

{
  "took" : 6,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 6,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [ ]
  },
  "aggregations" : {
    "group_by_class_name" : {
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 0,
      "buckets" : [
        {
          "key" : "高三一班",
          "doc_count" : 2
        },
        {
          "key" : "高三三班",
          "doc_count" : 2
        },
        {
          "key" : "高三二班",
          "doc_count" : 2
        }
      ]
    }
  }
}
分组统计每组平均值-avg

语句：

# avg
GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "group_by_class_name": {
      "terms": {
        "field": "class_name.keyword"
      },
      "aggs": {
        "avg_score": {
          "avg": {
            "field": "score"
          }
        }
      }
    }
  }
}

结果：

{
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 6,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [ ]
  },
  "aggregations" : {
    "group_by_class_name" : {
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 0,
      "buckets" : [
        {
          "key" : "高三一班",
          "doc_count" : 2,
          "avg_score" : {
            "value" : 63.0
          }
        },
        {
          "key" : "高三三班",
          "doc_count" : 2,
          "avg_score" : {
            "value" : 73.0
          }
        },
        {
          "key" : "高三二班",
          "doc_count" : 2,
          "avg_score" : {
            "value" : 83.0
          }
        }
      ]
    }
  }
}
分组统计每组最大值-max
# max
GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "group_by_class_name": {
      "terms": {
        "field": "class_name.keyword",
        "size": 10
      }, 
      "aggs": {
        "max_score": {
          "max": {
            "field": "score"
          }
        }
      }
    }
  }
}
分组统计每组最小值-min
# min
GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "group_by_class_name": {
      "terms": {
        "field": "class_name.keyword",
        "size": 10
      }, 
      "aggs": {
        "min_score": {
          "min": {
            "field": "score"
          }
        }
      }
    }
  }
}

结果

{
  "took" : 6,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 6,
      "relation" : "eq"
    },
    "max_score" : null,
    "hits" : [ ]
  },
  "aggregations" : {
    "group_by_class_name" : {
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 0,
      "buckets" : [
        {
          "key" : "高三一班",
          "doc_count" : 2,
          "min_score" : {
            "value" : 58.0
          }
        },
        {
          "key" : "高三三班",
          "doc_count" : 2,
          "min_score" : {
            "value" : 88.0
          }
        },
        {
          "key" : "高三二班",
          "doc_count" : 2,
          "min_score" : {
            "value" : 78.0
          }
        }
      ]
    }
  }
}

脚本总结：

# 批量插入数据
POST student_info_index/_bulk
{"index":{}}
{"student_name":"张三","address":"中国 北京","age":35}
{"index":{}}
{"student_name":"李四","address":"中国 上海","age":32}
{"index":{}}
{"student_name":"王五","address":"美国 华盛顿","age":25}
{"index":{}}
{"student_name":"赵六","address":"英国 伦敦","age":28}
{"index":{}}
{"student_name":"田七","address":"中国 台湾","age":40}

POST student_info_index/_search


GET student_info_index/_search
{
  "query": {
    "match_all": {}
  }
}

GET student_info_index/_mapping

# 按照年级倒序
GET student_info_index/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {
      "age": {
        "order": "desc"
      }
    }
  ]
}

# 多字段排序
GET student_info_index/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {
      "age": {
        "order": "desc"
      },
      "student_name.keyword": {
        "order": "desc"
      }
    }
  ]
}

# 查询指定字段
GET student_info_index/_search
{
  "query": {
    "match_all": {}
  },
  "_source": ["student_name","age"],
  "sort": [
    {
      "age": {
        "order": "desc"
      }
    }
  ]
}



GET student_info_index/_search
{
  "query": {
    "match_all": {}
  },
  "_source": [
    "student_name",
    "address"
  ],
  "from": 0,
  "size": 3
}


GET student_info_index/_search
{
  "query": {
    "match": {
      "address": "北京"
    }
  }
}

 
GET student_info_index/_search
{
  "query": {
    "match_phrase": {
      "address": "中国 上海"
    }
  }
}


GET student_info_index/_search
{
  "query": {
    "match_phrase": {
      "address.": "中国"
    }
  }
}

# 三国人物信息索引映射
PUT person_info_index
{
  "mappings": {
    "properties": {
      "name": {
        "type": "keyword"
      },
      "nationality": {
        "type": "text",
        "analyzer": "ik_max_word",
        "search_analyzer": "standard"
      },
      "age":{
        "type": "integer"
      }
    }
  }
}

# 批量插入
POST person_info_index/_bulk
{"index":{}}
{"name":"曹操","nationality":"魏国","age":45}
{"index":{}}
{"name":"夏侯淳","nationality":"魏国","age":36}
{"index":{}}
{"name":"曹昂","nationality":"魏国","age":32}
{"index":{}}
{"name":"刘备","nationality":"蜀国","age":42}
{"index":{}}
{"name":"关羽","nationality":"蜀国","age":41}
{"index":{}}
{"name":"张飞","nationality":"蜀国","age":39}
{"index":{}}
{"name":"孙权","nationality":"吴国","age":26}
{"index":{}}
{"name":"周瑜","nationality":"吴国","age":30}


GET person_info_index/_search
{
  "query": {
    "term": {
      "nationality": "吴国"
    }
  }
}


GET person_info_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "age": 30
          }
        }
      ],
      "must_not": [
        {
          "term": {
            "nationality": "吴国"
          }
        }
      ]
    }
  }
}


GET person_info_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "nationality": "蜀国"
          }
        }
      ],
      "filter": [
        {
          "range": {
            "age": {
              "gte": 40,
              "lte": 50
            }
          }
        }
      ]
    }
  }
}


# 学员成绩
DELETE stu_score_index
POST stu_score_index/_bulk
{"index":{}}
{"stu_name":"张三","class_name":"高三一班","age":16,"score":58}
{"index":{}}
{"stu_name":"李四","class_name":"高三一班","age":16,"score":68}
{"index":{}}
{"stu_name":"王五","class_name":"高三二班","age":17,"score":78}
{"index":{}}
{"stu_name":"赵六","class_name":"高三二班","age":18,"score":88}
{"index":{}}
{"stu_name":"田七","class_name":"高三三班","age":15,"score":98}
{"index":{}}
{"stu_name":"钱八","class_name":"高三三班","age":14,"score":88}



# count
GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "group_by_class_name": {
      "terms": {
        "field": "class_name.keyword",
        "size": 10
      }
    }
  }
}

GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "total_count": {
      "value_count": {
        "field": "stu_name.keyword"
      }
    }
  }
}




# avg
GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "group_by_class_name": {
      "terms": {
        "field": "class_name.keyword",
        "size": 10
      }, 
      "aggs": {
        "avg_score": {
          "avg": {
            "field": "score"
          }
        }
      }
    }
  }
}

GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "avg_score": {
      "avg": {
        "field": "score"
      }
    }
  }
}


# max
GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "group_by_class_name": {
      "terms": {
        "field": "class_name.keyword",
        "size": 10
      }, 
      "aggs": {
        "max_score": {
          "max": {
            "field": "score"
          }
        }
      }
    }
  }
}

GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "max_score": {
      "max": {
        "field": "score"
      }
    }
  }
}



# min
GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "group_by_class_name": {
      "terms": {
        "field": "class_name.keyword",
        "size": 10
      }, 
      "aggs": {
        "min_score": {
          "min": {
            "field": "score"
          }
        }
      }
    }
  }
}

GET stu_score_index/_search
{
  "size": 0,
  "aggs": {
    "min_score": {
      "min": {
        "field": "score"
      }
    }
  }
}
zx_1305769448
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
ElasticSearch(6) --查询
erainm
09-03 131
常用六个查询： 基本查询 _source过滤 结果过滤 高级查询 排序 高亮 导入数据，这里是采用批处理的API，大家直接复制到kibana运行即可，注意千万别使用kibana的格式化 POST /heima/goods/_bulk {"index":{}} {"title":"大米手机","images":"http://image.leyou.com/12479122.jpg","price":3288} {"index":{}} {"title":"小米手机","images":"http://i
Elasticsearch 基础查询
王大宝的博客
04-16 194
Linux环境docker安装Elasticsearch+kibana 准备一台服务器 第一步：安装docker 参考链接 ：https://www.cnblogs.com/yufeng218/p/8370670.html 下载ES和kibana的docker镜像，官网上有，注意下载的版本号要一致 ES版本最好不要超过7.0，各种各样的问题，很无语。kibana 6.7之后的版本才支持中文， 首...
elasticsearch基础查询
weixin_30715523的博客
06-04 120
Es基础数据类型 string 字符串类型，es中最常用的类型，官方文档 比较重要的参数： index分析 analyzed(默认) not_analyzed no store存储 true 独立存储 false（默认）不存储，从_source中解析 Numeric 数值类型，注意numeric并不是一个类型，它包括多种类型，比如：long,integer,...
elasticsearch基本查询
qq_35957398的博客
02-09 1185
准备数据 PUT /lib3 {   "settings": {     "number_of_shards": 5,     "number_of_replicas": 0   },   "mappings": {     "user":{       "properties": {         "name":{"type":"te
ElasticSearch（6）-- 查询
红烧咸鱼的博客
04-23 174
前几节我们了解了ES的新增，删除，修改，获取等，以及他们的批量处理，这一节我们来学习下ES查询。 先进行准备工作 PUT /lib3 { "settings": { "number_of_shards" : 3, "number_of_replicas" : 0 }, "mappings": { "user": {...
SpringBoot-ElasticSearch8
热门推荐
weixin_45203607的博客
04-23 1万+
前沿 elasticsearch-rest-high-level-client在 7.15.0 中已弃用。 不推荐使用高级 REST 客户端，取而代之的是 Java API 客户端 。 spring-boot-starter-data-elasticsearch 也不推荐,虽然基础操作简化了很多,但是一旦使用了es高级特性,那么就如同进入了地狱 在es官网推荐我们现在使用 Elasticsearch Java API 客户端 Java API 客户端官网地址 elasticsearch Api 操作大全
es--基础--08--Spring Data ElasticSearch 使用
zhou920786312的博客
12-29 747
es入门学习8-java-Spring Data ElasticSearch 使用 一、Spring Data ElasticSearch 简介 基于 spring data API 简化 elasticSearch操作，将原始操作elasticSearch的客户端API 进行封装 。 为Elasticsearch项目提供集成搜索引擎。Spring Data Elasticsearch POJO的关键功能区域为中心的模型与Elastichsearch交互文档和轻松地编写一个存储库数据访问层。 二、项目
linux-elasticsearch（基础）
郑俊强的博客
04-21 786
IK Analyzer 扩展配置linux-es.dic
四、ElasticSearch-基础查询操作
tarcy的博客
04-24 1943
1、插入部分数据 post /my_index_data/_doc/1 { "first_name" : "tom1", "last_name" : "Smith", "age" : 35 } post /my_index_data/_doc/2 { "first_name" : "tom2", "last_name" : "Smith", "age" : 30 } post /my_index_data/
Spring Boot elasticsearch7.6.2基础操作：创建索引、新增数据、查询数据
04-29
Spring Boot elasticsearch7.6.2基础操作：创建索引、新增数据、查询数据
一站式掌握elastic search基础与实战视频资源-百度云链接
08-26
07-6 分页与遍历-search_after.avi 07-7 文档说明.mp4.avi 08-1 -聚合分析简介.avi 08-2 -metric聚合分析.avi 08-3 -bucket聚合分析.avi 08-4 -bucket和metric聚合分析.avi 08-5 -pipeline聚合分析.avi 08-6 -作用...
Elasticsearch 技术解析与实战.zip
07-25
前言 第1章 Elasticsearch入门 1 1.1 Elasticsearch是什么 1 1.1.1 Elasticsearch的历史 2 1.1.2 相关产品 3 1.2 全文搜索 3 1.2.1 Lucene介绍 4 1.2.2 Lucene倒排索引 4 1.3 基础知识 6 1.3.1 Elasticsearch术语及...
ELK基础及应用案例PPT
03-26
3. 通过logstash上传日志到elasticsearch; 4. 通过kibana对日志进行查询和统计及分析； 5. 通过api实现应用性能监控； 6. 通过uptime监控应用运行； 7. 通过机器学习分析日志； 8. 通过IP地址在地图上显示访问量统计...
ES基础概念
LB_bei的博客
05-22 967
本文不介绍如何使用ES（使用ES见：）
Elasticsearch的Index sorting 索引预排序会导致索引数据的移动吗？
yonggeit的博客
05-23 100
首先通过refresh在内存中生成新的Segment段时，由于段数据是此时生成的，很容易确保段数据是有序的，此外在段合并的过程中涉及到端数据的重整，这时候也可以确保合并后的新段的数据是有序的。但是我们知道，Elasticsearch的Segment段数据是不可变的，这是为了写入的时候可以进行顺序写而提高磁盘的IO效率，同时可以提高段文件的缓存命中率，不至于一条数据被修改，整个段的数据缓存都要失效的情况。可以想象一个链表结构，如果需要确保它的有序性，在插入新数据的时候需要对链表节点进行移动。
Git Submodules：深入理解与应用
最新发布
wujiayu31415的博客
05-23 944
Git Submodules 是 Git 提供的一个强大功能，允许你在一个 Git 仓库（称为父仓库）中嵌套另一个 Git 仓库（称为子模块仓库）。这样，你就可以在父仓库中维护一个或多个子模块仓库，每个子模块仓库都有自己的版本历史、分支和标签。但是，在父仓库中，你只能通过更新子模块的提交ID来引用子模块的不同版本。当你在子模块中进行了更改后，你需要先提交这些更改到子模块的仓库中，然后才能将它们推送到父仓库。在提交子模块的更新时，Git 会在父仓库中创建一个特殊的提交，记录子模块的新提交ID。
Git常用操作
Justice
05-21 572
合并分支a到分支b，–no-ff参数表示禁用Fast forward模式，合并后的历史有分支，能看出曾经做过合并，而-ff参数表示使用Fast forward模式，合并后的历史变成一条直线。rebase 不会产生新的提交，而是把当前分支的每一个提交都“复制”到目标分支上，然后再把当前分支指向目标分支，而merge会产生一个新的提交，这个提交有两个分支的所有修改。创建一个新的提交，用来撤销指定的提交，后者的所有变化将被前者抵消，并且应用到当前分支。查看所有本地分支，-r 查看远程分支，-a查看所有分支。
《Ai学习笔记》自然语言处理 (Natural Language Processing)：机器阅读理解-基础概念解析01
阿丹的博客
05-22 489
Machine Reading Comprehension(MRC)机器阅读理解任务QA问题的一个子集，含有contexts通过交互从书面文字中提取与构造文章语义的过程。
elasticsearch 运维
08-26
- *3* [运维篇 -- ElasticSearch 7.X 基础知识理论知识，开发绕路](https://blog.csdn.net/shm19990131/article/details/107322807)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值