elasticsearch具体操作Sql记录

最新推荐文章于 2024-08-08 07:42:58 发布

longlovefilm

最新推荐文章于 2024-08-08 07:42:58 发布

阅读量181

点赞数

CC 4.0 BY-SA版权

分类专栏：操作tips 数据库

本文链接：https://blog.youkuaiyun.com/longlovefilm/article/details/96426576

数据库同时被 2 个专栏收录

15 篇文章

订阅专栏

操作tips

8 篇文章

订阅专栏

本文介绍如何使用SQL及Elasticsearch进行学生ID数量统计的方法，包括使用distinct关键字去除重复记录，利用Elasticsearch的aggregation框架完成复杂聚合查询，并展示了不同查询方式的效果对比。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select count(distinct(stu_id)) from xxx
    
  "aggs": {
    "count": {
      "cardinality": {
        "field": "stu_id"
      }
    }
  },

select distinct stu_id from xxx
   "aggs": {
    "zcl": {
      "terms": {
        "field": "stu_id",
        "size": 10000
      }}},

{
	"fields": ["data"],
	"query": {
		"bool": {
			"must": [{"terms": {"stu_id": [1, 2, 3]}}]
}
	},
	"aggs": {
		"stu_id": {
			"terms": {
				"field": "stu_id",
				"size": 600,
				"collect_mode": "breadth_first",
				"execution_hint": "map"
			},
			"aggs": {
				"home_need": {"sum": {"field": "homework_need"}}
			}
		}
	}
}

4 missing field search

{
  "query": {
    "bool": {
      "must": [
{"constant_score":{"filter":{"missing":{"field":"difficulty_id选择要查询的字段"}}}}
      ],
      "must_not": [],
      "should": []
    }
  },
  "from": 0,
  "size": 10,
  "sort": [],
  "facets": {}
}