ElasticSearch 分组统计（逗号分割字符串 /nested 集合对象）

2023-04-13
河南
本文字数：1756 字
阅读完需：约 6 分钟

逗号分割的字符串，如何进行分组统计

在使用 Elasticsearch 的时候，经常会遇到类似标签的需求，比如给学生信息打标签，并且使用逗号分割的字符串进行存储，后期如果遇到需要根据标签统计学生数量的需求，则可以使用如下的命令进行处理。前两个代码段落分别是 mapping、setting 的配置，第三个代码段是请求命令，第四个代码段是分组结果。

 "studentTags": {   "type": "text",   "analyzer": "comma",   "search_analyzer": "comma" }

复制代码

{  "analysis": {    "filter": {    },    "analyzer": {      "comma": {        "type": "pattern",        "pattern":","      }    },    "char_filter": {    },    "tokenizer": {    }  }}

复制代码

{    "size": 0,    "aggs": {        "group_by_field": {            "terms": {                "script": {                    "source": "if (params['_source']['studentTags'] != null) { params['_source']['studentTags'].splitOnToken(',') }",                    "lang": "painless"                },                "size": 10            }        }    }}

复制代码

{    "took": 9,    "timed_out": false,    "_shards": {        "total": 1,        "successful": 1,        "skipped": 0,        "failed": 0    },    "hits": {        "total": {            "value": 27,            "relation": "eq"        },        "max_score": null,        "hits": []    },    "aggregations": {        "group_by_field": {            "doc_count_error_upper_bound": 0,            "sum_other_doc_count": 0,            "buckets": [                {                    "key": "A",                    "doc_count": 19                },                {                    "key": "B",                    "doc_count": 18                },                {                    "key": "C",                    "doc_count": 13                },                {                    "key": "D",                    "doc_count": 12                }            ]        }    }}

复制代码

Nested 对象，如何进行分组统计

在使用 Elasticsearch 的时候，如果遇到 nested 对象，并且想对 nested 对象进行分组统计的话，可以按照如下方式进行处理。第一个代码段落分别是 mapping，第二个代码段是请求命令，第三个代码段是分组结果。

"mathScoreNestedList": {    "type": "nested",    "properties": {            "score": {            "type": "integer"        },            "halfYear": {            "type": "keyword"        }    }},

复制代码

{    "size": 0,    "aggs": {        "labels_nested": {            "nested": {                "path": "mathScoreNestedList"            },            "aggs": {                "nested_score": {                    "terms": {                        "field": "mathScoreNestedList.halfYear"                    }                }            }        }    }}

复制代码

{    "took": 32,    "timed_out": false,    "_shards": {        "total": 1,        "successful": 1,        "skipped": 0,        "failed": 0    },    "hits": {        "total": {            "value": 27,            "relation": "eq"        },        "max_score": null,        "hits": []    },    "aggregations": {        "labels_nested": {            "doc_count": 7,            "nested_score": {                "doc_count_error_upper_bound": 0,                "sum_other_doc_count": 0,                "buckets": [                    {                        "key": "202201",                        "doc_count": 5                    },                    {                        "key": "202207",                        "doc_count": 2                    }                ]            }        }    }}

复制代码

发布于: 刚刚阅读数: 6

原文链接:【http://xie.infoq.cn/article/3295e1606cb325210d73317ca】。

alexgaoyh

关注

DevOps 2013-12-08 加入

https://gitee.com/alexgaoyh

发布

暂无评论

创作场景

ElasticSearch 分组统计（逗号分割字符串 /nested 集合对象）

逗号分割的字符串，如何进行分组统计

Nested 对象，如何进行分组统计

alexgaoyh

评论