0

0

ElasticSearch 6.x 学习笔记:22.桶聚合

爱谁谁

爱谁谁

发布时间:2025-07-12 09:14:27

|

328人浏览过

|

来源于php中文网

原创

为了满足桶聚合多样性需求,修改文档如下。

代码语言:javascript代码运行次数:0运行复制
DELETE my-indexPUT my-indexPUT my-index/persion/1{  "name":"张三",  "age":27,  "gender":"男",  "salary":15000,  "dep":"bigdata"}PUT my-index/persion/2{  "name":"李四",  "age":26,  "gender":"女",  "salary":15000,  "dep":"bigdata"}PUT my-index/persion/3{  "name":"王五",  "age":26,  "gender":"男",  "salary":17000,  "dep":"AI"}PUT my-index/persion/4{  "name":"刘六",  "age":27,  "gender":"女",  "salary":18000,  "dep":"AI"}PUT my-index/persion/5{  "name":"程裕强",  "age":31,  "gender":"男",  "salary":20000,  "dep":"bigdata"}PUT my-index/persion/6{  "name":"hadron",  "age":30,  "gender":"男",  "salary":20000,  "dep":"AI"}
22.0 Bucket aggregations

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket.html 在页面右下角可以看到各类具体的Bucket聚合连接

ElasticSearch 6.x 学习笔记:22.桶聚合
22.1 Terms Aggregation

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-terms-aggregation.html A multi-bucket value source based aggregation where buckets are dynamically built - one per unique value. Terms聚合用于分组聚合。 【例子】根据薪资水平进行分组,统计每个薪资水平的人数

代码语言:javascript代码运行次数:0运行复制
GET my-index/_search{  "size": 0,   "aggs": {    "group_count": {      "terms": {"field": "salary"}    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 7,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 6,    "max_score": 0,    "hits": []  },  "aggregations": {    "group_count": {      "doc_count_error_upper_bound": 0,      "sum_other_doc_count": 0,      "buckets": [        {          "key": 15000,          "doc_count": 2        },        {          "key": 20000,          "doc_count": 2        },        {          "key": 17000,          "doc_count": 1        },        {          "key": 18000,          "doc_count": 1        }      ]    }  }}

【例子】统计上面每个分组的平均年龄

代码语言:javascript代码运行次数:0运行复制
GET my-index/_search{  "size": 0,   "aggs": {    "group_count": {      "terms": {"field": "salary"},      "aggs":{        "avg_age":{          "avg":{"field": "age"}        }      }    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 4,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 6,    "max_score": 0,    "hits": []  },  "aggregations": {    "group_count": {      "doc_count_error_upper_bound": 0,      "sum_other_doc_count": 0,      "buckets": [        {          "key": 15000,          "doc_count": 2,          "avg_age": {            "value": 26.5 }        },        {          "key": 20000,          "doc_count": 2,          "avg_age": {            "value": 30.5 }        },        {          "key": 17000,          "doc_count": 1,          "avg_age": {            "value": 26 }        },        {          "key": 18000,          "doc_count": 1,          "avg_age": {            "value": 27 }        }      ]    }  }}

【例子】统计每个部门的人数

代码语言:javascript代码运行次数:0运行复制
GET my-index/_search{  "size": 0,   "aggs": {    "group_count": {      "terms": {"field": "dep"}    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "error": {    "root_cause": [      {        "type": "illegal_argument_exception",        "reason": "Fielddata is disabled on text fields by default. Set fielddata=true on [dep] in order to load fielddata in memory by uninverting the inverted index. Note that this can however use significant memory. Alternatively use a keyword field instead."      }    ],    "type": "search_phase_execution_exception",    "reason": "all shards failed",    "phase": "query",    "grouped": true,    "failed_shards": [      {        "shard": 0,        "index": "my-index",        "node": "cNWkQjt9SzKFNtyx8IIu-A",        "reason": {          "type": "illegal_argument_exception",          "reason": "Fielddata is disabled on text fields by default. Set fielddata=true on [dep] in order to load fielddata in memory by uninverting the inverted index. Note that this can however use significant memory. Alternatively use a keyword field instead."        }      }    ]  },  "status": 400}

根据错误提示”Fielddata is disabled on text fields by default. Set fielddata=true on [dep] in order to load fielddata in memory by uninverting the inverted index. Note that this can however use significant memory. Alternatively use a keyword field instead.”可知,需要开启fielddata参数。只需要设置某个字段"fielddata": true即可。 此外,根据官方文档提示se the my_field.keyword field for aggregations, sorting, or in scripts,可以尝试my_field.keyword格式用于聚合操作。

代码语言:javascript代码运行次数:0运行复制
GET my-index/_search{  "size": 0,   "aggs": {    "group_count": {      "terms": {"field": "dep.keyword"}    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 55,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 6,    "max_score": 0,    "hits": []  },  "aggregations": {    "group_count": {      "doc_count_error_upper_bound": 0,      "sum_other_doc_count": 0,      "buckets": [        {          "key": "AI",          "doc_count": 3        },        {          "key": "bigdata",          "doc_count": 3        }      ]    }  }}
22.2 Filter Aggregation

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-filter-aggregation.html Defines a multi bucket aggregation where each bucket is associated with a filter. Each bucket will collect all documents that match its associated filter. Filter聚合用于过滤器聚合,把满足过滤器条件的文档分到一组。

【例子】计算男人的平均年龄 也就是统计gender字段包含关键字“男”的文档的age平均值。

代码语言:javascript代码运行次数:0运行复制
GET my-index/_search{  "size": 0,   "aggs": {    "group_count": {      "filter": {        "term":{"gender": "男"}      },      "aggs":{        "avg_age":{          "avg":{"field": "age"}        }      }    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 2,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 6,    "max_score": 0,    "hits": []  },  "aggregations": {    "group_count": {      "doc_count": 4,      "avg_age": {        "value": 28.5      }    }  }}
22.3 Filters Aggregation

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-filters-aggregation.html Defines a single bucket of all the documents in the current document set context that match a specified filter. Often this will be used to narrow down the current aggregation context to a specific set of documents.

【例子】统计body字段包含”error”和包含”warning”的文档数

代码语言:javascript代码运行次数:0运行复制
PUT /logs/message/_bulk?refresh{ "index" : { "_id" : 1 } }{ "body" : "warning: page could not be rendered" }{ "index" : { "_id" : 2 } }{ "body" : "authentication error" }{ "index" : { "_id" : 3 } }{ "body" : "warning: connection timed out" }GET logs/_search{  "size": 0,  "aggs" : {    "messages" : {      "filters" : {        "filters" : {          "errors" :   { "match" : { "body" : "error"   }},          "warnings" : { "match" : { "body" : "warning" }}        }      }    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 54,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 3,    "max_score": 0,    "hits": []  },  "aggregations": {    "messages": {      "buckets": {        "errors": {          "doc_count": 1 },        "warnings": {          "doc_count": 2 }      }    }  }}

【例子】统计男女员工的平均年龄

代码语言:javascript代码运行次数:0运行复制
GET my-index/_search{  "size": 0,   "aggs": {    "group_count": {      "filters":{        "filters": [          {"match":{"gender": "男"}},          {"match":{"gender": "女"}}        ]      },      "aggs":{        "avg_age":{            "avg":{"field": "age"}        }      }    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 5,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 6,    "max_score": 0,    "hits": []  },  "aggregations": {    "group_count": {      "buckets": [        {          "doc_count": 4,          "avg_age": {            "value": 28.5 }        },        {          "doc_count": 2,          "avg_age": {            "value": 26.5 }        }      ]    }  }}
22.4 Range Aggregation

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-range-aggregation.html

A multi-bucket value source based aggregation that enables the user to define a set of ranges - each representing a bucket. During the aggregation process, the values extracted from each document will be checked against each bucket range and “bucket” the relevant/matching document. Note that this aggregation includes the from value and excludes the to value for each range.

from..to区间范围是[from,to),也就是说包含from点,不包含to点 【例子】查询薪资在[0,10000),[10000,20000),[2000,+无穷大)三个范围的员工数

代码语言:javascript代码运行次数:0运行复制
GET my-index/_search{  "size": 0,   "aggs": {    "group_count": {      "range": {        "field": "salary",        "ranges": [            {"to": 10000},            {"from": 10000,"to":20000},              {"from": 20000}        ]      }    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 101,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 6,    "max_score": 0,    "hits": []  },  "aggregations": {    "group_count": {      "buckets": [        {          "key": "*-10000.0",          "to": 10000,          "doc_count": 0        },        {          "key": "10000.0-20000.0",          "from": 10000,          "to": 20000,          "doc_count": 4        },        {          "key": "20000.0-*",          "from": 20000,          "doc_count": 2        }      ]    }  }}

【例子】查询发布日期在2016-12-01之前、2016-12-01至2017-01-01、2017-01-01之后三个时间区间的文档数

代码语言:javascript代码运行次数:0运行复制
GET website/_search{  "size": 0,   "aggs": {    "group_count": {      "range": {        "field": "postdate",        "format":"yyyy-MM-dd",        "ranges": [            {"to": "2016-12-01"},            {"from": "2016-12-01","to":"2017-01-01"},              {"from": "2017-01-01"}        ]      }    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 24,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 9,    "max_score": 0,    "hits": []  },  "aggregations": {    "group_count": {      "buckets": [        {          "key": "*-2016-12-01",          "to": 1480550400000,          "to_as_string": "2016-12-01",          "doc_count": 0        },        {          "key": "2016-12-01-2017-01-01",          "from": 1480550400000,          "from_as_string": "2016-12-01",          "to": 1483228800000,          "to_as_string": "2017-01-01",          "doc_count": 7        },        {          "key": "2017-01-01-*",          "from": 1483228800000,          "from_as_string": "2017-01-01",          "doc_count": 2        }      ]    }  }}
22.5 Date Range聚合

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-daterange-aggregation.html A range aggregation that is dedicated for date values. The main difference between this aggregation and the normal range aggregation is that the from and to values can be expressed in Date Math expressions, and it is also possible to specify a date format by which the from and to response fields will be returned. Note that this aggregation includes the from value and excludes the to value for each range. 专用于日期值的范围聚合。 这种聚合和正常范围聚合的主要区别在于,起始和结束值可以在日期数学表达式中表示,并且还可以指定返回起始和结束响应字段的日期格式。 请注意,此聚合包含from值并排除每个范围的值。

【例子】计算一年前之前发表的博文数和从一年前以来发表的博文总数

代码语言:javascript代码运行次数:0运行复制
GET website/_search{  "size": 0,   "aggs": {    "group_count": {      "range": {        "field": "postdate",        "format":"yyyy-MM-dd",        "ranges": [            {"to": "now-12M/M"},            {"from": "now-12M/M"}        ]      }    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 44,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 9,    "max_score": 0,    "hits": []  },  "aggregations": {    "group_count": {      "buckets": [        {          "key": "*-2017-01-01",          "to": 1483228800000,          "to_as_string": "2017-01-01",          "doc_count": 7        },        {          "key": "2017-01-01-*",          "from": 1483228800000,          "from_as_string": "2017-01-01",          "doc_count": 2        }      ]    }  }}
22.6 Missing聚合

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-missing-aggregation.html

A field data based single bucket aggregation, that creates a bucket of all documents in the current document set context that are missing a field value (effectively, missing a field or having the configured NULL value set). This aggregator will often be used in conjunction with other field data bucket aggregators (such as ranges) to return information for all the documents that could not be placed in any of the other buckets due to missing field data values. 基于字段数据的单桶集合,创建当前文档集上下文中缺少字段值(实际上缺少字段或设置了配置的NULL值)的所有文档的桶。 此聚合器通常会与其他字段数据存储桶聚合器(如范围)一起使用,以返回由于缺少字段数据值而无法放置在其他存储桶中的所有文档的信息。

沁言学术
沁言学术

你的论文写作AI助理,永久免费文献管理工具,认准沁言学术

下载
代码语言:javascript代码运行次数:0运行复制
PUT my-index/persion/7{  "name":"test",  "age":30,  "gender":"男"}PUT my-index/persion/8{  "name":"abc",  "age":28,  "gender":"女"}PUT my-index/persion/9{  "name":"xyz",  "age":32,  "gender":"男",  "salary":null,  "dep":null}

salary字段缺少的文档

代码语言:javascript代码运行次数:0运行复制
GET my-index/_search{  "size": 0,   "aggs": {    "noDep_count": {      "missing": {"field": "salary"}    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 29,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 9,    "max_score": 0,    "hits": []  },  "aggregations": {    "noDep_count": {      "doc_count": 3    }  }}
22.7 children聚合

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-children-aggregation.html

A special single bucket aggregation that selects child documents that have the specified type, as defined in a join field. 一个特殊的单桶集合,用于选择具有指定类型的子文档,如join字段中定义的。

这种聚合有一个单一的选择:type - 应该选择的子类型.

【例子】 (1)索引定义 下面通过join字段定义了一个单一关系,question 是answer的父文档。

代码语言:javascript代码运行次数:0运行复制
PUT join_index{  "mappings": {    "doc": {      "properties": {        "my_join_field": {           "type": "join",          "relations": {            "question": "answer"           }        }      }    }  }}

(2)父文档question

代码语言:javascript代码运行次数:0运行复制
PUT join_index/doc/1?refresh{  "text": "This is a question",  "my_join_field": {    "name": "question"   }}PUT join_index/doc/2?refresh{  "text": "This is a another question",  "my_join_field": {    "name": "question"  }}

(3)子文档answer

代码语言:javascript代码运行次数:0运行复制
PUT join_index/doc/3?routing=1&refresh {  "text": "This is an answer",  "my_join_field": {    "name": "answer",     "parent": "1"   }}PUT join_index/doc/4?routing=1&refresh{  "text": "This is another answer",  "my_join_field": {    "name": "answer",    "parent": "1"  }}

(4)统计子文档数量

代码语言:javascript代码运行次数:0运行复制
POST join_index/_search{  "size": 0,   "aggs": {    "to-answers": {        "children": {          "type" : "answer"         }    }  }}
代码语言:javascript代码运行次数:0运行复制
{  "took": 4,  "timed_out": false,  "_shards": {    "total": 5,    "successful": 5,    "skipped": 0,    "failed": 0  },  "hits": {    "total": 4,    "max_score": 0,    "hits": []  },  "aggregations": {    "to-answers": {      "doc_count": 2    }  }}
Global Aggregation

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-global-aggregation.html

Defines a single bucket of all the documents within the search execution context. This context is defined by the indices and the document types you’re searching on, but is not influenced by the search query itself.

NOTE:Global aggregators can only be placed as top level aggregators because it doesn’t make sense to embed a global aggregator within another bucket aggregator.

Histogram Aggregation

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-histogram-aggregation.html

IP Range Aggregation

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-iprange-aggregation.html

Just like the dedicated date range aggregation, there is also a dedicated range aggregation for IP typed fields:

Nested Aggregationedit

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-bucket-nested-aggregation.html

A special single bucket aggregation that enables aggregating nested documents.

For example, lets say we have an index of products, and each product holds the list of resellers - each having its own price for the product. The mapping could look like:

相关专题

更多
js获取数组长度的方法
js获取数组长度的方法

在js中,可以利用array对象的length属性来获取数组长度,该属性可设置或返回数组中元素的数目,只需要使用“array.length”语句即可返回表示数组对象的元素个数的数值,也就是长度值。php中文网还提供JavaScript数组的相关下载、相关课程等内容,供大家免费下载使用。

556

2023.06.20

js刷新当前页面
js刷新当前页面

js刷新当前页面的方法:1、reload方法,该方法强迫浏览器刷新当前页面,语法为“location.reload([bForceGet]) ”;2、replace方法,该方法通过指定URL替换当前缓存在历史里(客户端)的项目,因此当使用replace方法之后,不能通过“前进”和“后退”来访问已经被替换的URL,语法为“location.replace(URL) ”。php中文网为大家带来了js刷新当前页面的相关知识、以及相关文章等内容

374

2023.07.04

js四舍五入
js四舍五入

js四舍五入的方法:1、tofixed方法,可把 Number 四舍五入为指定小数位数的数字;2、round() 方法,可把一个数字舍入为最接近的整数。php中文网为大家带来了js四舍五入的相关知识、以及相关文章等内容

732

2023.07.04

js删除节点的方法
js删除节点的方法

js删除节点的方法有:1、removeChild()方法,用于从父节点中移除指定的子节点,它需要两个参数,第一个参数是要删除的子节点,第二个参数是父节点;2、parentNode.removeChild()方法,可以直接通过父节点调用来删除子节点;3、remove()方法,可以直接删除节点,而无需指定父节点;4、innerHTML属性,用于删除节点的内容。

477

2023.09.01

JavaScript转义字符
JavaScript转义字符

JavaScript中的转义字符是反斜杠和引号,可以在字符串中表示特殊字符或改变字符的含义。本专题为大家提供转义字符相关的文章、下载、课程内容,供大家免费下载体验。

414

2023.09.04

js生成随机数的方法
js生成随机数的方法

js生成随机数的方法有:1、使用random函数生成0-1之间的随机数;2、使用random函数和特定范围来生成随机整数;3、使用random函数和round函数生成0-99之间的随机整数;4、使用random函数和其他函数生成更复杂的随机数;5、使用random函数和其他函数生成范围内的随机小数;6、使用random函数和其他函数生成范围内的随机整数或小数。

991

2023.09.04

如何启用JavaScript
如何启用JavaScript

JavaScript启用方法有内联脚本、内部脚本、外部脚本和异步加载。详细介绍:1、内联脚本是将JavaScript代码直接嵌入到HTML标签中;2、内部脚本是将JavaScript代码放置在HTML文件的`<script>`标签中;3、外部脚本是将JavaScript代码放置在一个独立的文件;4、外部脚本是将JavaScript代码放置在一个独立的文件。

658

2023.09.12

Js中Symbol类详解
Js中Symbol类详解

javascript中的Symbol数据类型是一种基本数据类型,用于表示独一无二的值。Symbol的特点:1、独一无二,每个Symbol值都是唯一的,不会与其他任何值相等;2、不可变性,Symbol值一旦创建,就不能修改或者重新赋值;3、隐藏性,Symbol值不会被隐式转换为其他类型;4、无法枚举,Symbol值作为对象的属性名时,默认是不可枚举的。

553

2023.09.20

高德地图升级方法汇总
高德地图升级方法汇总

本专题整合了高德地图升级相关教程,阅读专题下面的文章了解更多详细内容。

72

2026.01.16

热门下载

更多
网站特效
/
网站源码
/
网站素材
/
前端模板

精品课程

更多
相关推荐
/
热门推荐
/
最新课程
CSS3 教程
CSS3 教程

共18课时 | 4.7万人学习

JavaScript ES5基础线上课程教学
JavaScript ES5基础线上课程教学

共6课时 | 8.1万人学习

关于我们 免责申明 举报中心 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送

Copyright 2014-2026 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号