ElasticSearch (Nest) 条款的条款子聚合

ElasticSearch (Nest) 条款的条款子聚合 - 未按预期工作

转载作者：行者123 更新时间：2023-12-03 02:02:19

考虑到以下映射:

{
    "person": {
        "properties": {
            "id": {
                "type": "string"
            },
            "name": {
                "type": "string"
            },
            ...
            "trainings": {
                "properties": {
                    "attendanceDate": {
                        "type": "date",
                        "format": "dateOptionalTime"
                    },
                    "providerId": {
                        "type": "string",
                        "index": "not_analyzed"
                    },
                    "trainingId": {
                        "type": "string",
                        "index": "not_analyzed"
                    }
                    ...
                }
            }
        }
    }
}

这是目前我的 Elasticsearch 查询

{
    "aggs": {
        "trainning_agg": {
            "terms": {
                "field": "trainings.trainingId"
            },
            "aggs": {
                "provider_agg": {
                    "terms": {
                        "field": "trainings.providerId"
                    }
                }
            }
        }
    }
}

不幸的是， Elasticsearch 将通过包含所有聚合提供者的存储桶列表的培训返回给我一个存储桶列表(忽略培训 ID)。

而不是按训练的存储桶列表，其中包含由父培训过滤的所有提供者的存储桶列表。

任何帮助将不胜感激，并让我知道我可以提供哪些详细信息来帮助您理解我的问题!

谢谢!

编辑:

让我准确地说，目前每个培训目前只有一个且唯一的提供者，因此每个“人”当前将有一个“培训”，其中包含一个元素。 (情况并非总是如此，但为了示例的简单性，我们假设是这样)

目前有 12 个不同的培训，每个培训作为一个提供者。

请注意，当前提供者 ID 与培训 ID 相同(并非总是如此，但为了示例的简单性，我们假设是这样)
这是目前我的回应:

{
        ...
        "aggregations": {
            "training_agg": {
                ...
                "buckets": [
                    {
                        "key": "17effec3-1284-4609-af41-2252b4dde8b5",
                        "doc_count": 8808,
                        "provider_agg": {
                            ...
                            "buckets": [
                                {
                                    "key": "17effec3-1284-4609-af41-2252b4dde8b5",
                                    "doc_count": 8808
                                },
                                {
                                    "key": "560be929-134b-4b67-befd-f38fdbb2f7ad",
                                    "doc_count": 8808
                                },
                                {
                                    "key": "96b16133-51ef-413c-afa5-24f74263126b",
                                    "doc_count": 8808
                                },
                                {
                                    "key": "96c36f93-90ce-4378-a9f2-8a8aaa780fd2",
                                    "doc_count": 8808
                                },
                                {
                                    "key": "e9467886-42e0-467c-a338-a7fcbc66125f",
                                    "doc_count": 8808
                                },
                                {
                                    "key": "f05554c2-778b-44b6-972e-c2fea01d924f",
                                    "doc_count": 8808
                                },
                                {
                                    "key": "ab40dcda-e253-4ff3-95e9-314e4ce5ba39",
                                    "doc_count": 8807
                                },
                                {
                                    "key": "5aaa2f31-6aa6-4d5a-86ea-8a25cb11247e",
                                    "doc_count": 8081
                                },
                                {
                                    "key": "d1c45ad7-046b-43de-b65e-012185c17f6a",
                                    "doc_count": 4686
                                },
                                {
                                    "key": "c06e0cee-1050-41b6-ac83-ea3a00f0abb7",
                                    "doc_count": 3135
                                }
                            ]
                        }
                    }
                ]
            }
        }
    }

这就是我想要得到的:

{
    ...
    "aggregations": {
        "training_agg": {
            ...
            "buckets": [
                {
                    "key": "17effec3-1284-4609-af41-2252b4dde8b5",
                    "doc_count": 8808,
                    "provider_agg": {
                        ...
                        "buckets": [
                            {
                                "key": "17effec3-1284-4609-af41-2252b4dde8b5",
                                "doc_count": 8808
                            }
                        ]
                    }
                }
            ]
        }
    }
}

文件示例(必须删除一些信息，保密协议(protocol):O)
注意:providerId 和 trainingId 相同的事实是我插入数据时的纯粹懒惰，它可能是两个完全不同的 UUID。

    {
    "hits": [
        {
            ...
            "_source": {
                "id": "d9753b0fd674f9d55b8cd125258b2713b191499828dc5301162dffc17f3ddf4b",
                "name": "Do Van Tien",
                ...
                "trainings": [
                    {
                        "trainingName": "Certification - 4C",
                        "providerName": "Hidden Provider",
                        "trainingId": "c06e0cee-1050-41b6-ac83-ea3a00f0abb7",
                        "providerId": "c06e0cee-1050-41b6-ac83-ea3a00f0abb7",
                        "attendanceDate": "2012-07-07T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Safety & Hygiene",
                        "providerName": "Hidden Provider",
                        "trainingId": "96c36f93-90ce-4378-a9f2-8a8aaa780fd2",
                        "providerId": "96c36f93-90ce-4378-a9f2-8a8aaa780fd2",
                        "attendanceDate": "2014-04-16T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Crop protection",
                        "providerName": "Hidden Provider",
                        "trainingId": "ab40dcda-e253-4ff3-95e9-314e4ce5ba39",
                        "providerId": "ab40dcda-e253-4ff3-95e9-314e4ce5ba39",
                        "attendanceDate": "2014-04-16T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Post Harvest",
                        "providerName": "Hidden Provider",
                        "trainingId": "d1c45ad7-046b-43de-b65e-012185c17f6a",
                        "providerId": "d1c45ad7-046b-43de-b65e-012185c17f6a",
                        "attendanceDate": "2012-07-07T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Soil Management & Fertilizer Application",
                        "providerName": "Hidden Provider",
                        "trainingId": "17effec3-1284-4609-af41-2252b4dde8b5",
                        "providerId": "17effec3-1284-4609-af41-2252b4dde8b5",
                        "attendanceDate": "2012-08-16T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Irrigation & Water Management",
                        "providerName": "Hidden Provider",
                        "trainingId": "560be929-134b-4b67-befd-f38fdbb2f7ad",
                        "providerId": "560be929-134b-4b67-befd-f38fdbb2f7ad",
                        "attendanceDate": "2012-07-07T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Composting",
                        "providerName": "Hidden Provider",
                        "trainingId": "96b16133-51ef-413c-afa5-24f74263126b",
                        "providerId": "96b16133-51ef-413c-afa5-24f74263126b",
                        "attendanceDate": "2013-08-22T00:00:00"
                    },
                    {
                        "trainingName": "Certification - UTZ - Code of Conduct",
                        "providerName": "Hidden Provider",
                        "trainingId": "5aaa2f31-6aa6-4d5a-86ea-8a25cb11247e",
                        "providerId": "5aaa2f31-6aa6-4d5a-86ea-8a25cb11247e",
                        "attendanceDate": "2013-08-22T00:00:00"
                    },
                    {
                        "trainingName": "Economic - Business skills",
                        "providerName": "Hidden Provider",
                        "trainingId": "e9467886-42e0-467c-a338-a7fcbc66125f",
                        "providerId": "e9467886-42e0-467c-a338-a7fcbc66125f",
                        "attendanceDate": "2013-08-22T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Pruning",
                        "providerName": "Hidden Provider",
                        "trainingId": "f05554c2-778b-44b6-972e-c2fea01d924f",
                        "providerId": "f05554c2-778b-44b6-972e-c2fea01d924f",
                        "attendanceDate": "2013-05-09T00:00:00"
                    }
                ]
            }
        },
        {
            ...
            "_source": {
                "id": "dca2d4b86bf1bea73492bde614e0bb3d7cadf2f4f44e9fe3c5b4cf930d2cca00",
                "name": "Le Thi Than",
                ...
                "trainings": [
                    {
                        "trainingName": "Certification - UTZ - Code of Conduct",
                        "providerName": "Hidden Provider",
                        "trainingId": "5aaa2f31-6aa6-4d5a-86ea-8a25cb11247e",
                        "providerId": "5aaa2f31-6aa6-4d5a-86ea-8a25cb11247e",
                        "attendanceDate": "2012-06-25T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Crop protection",
                        "providerName": "Hidden Provider",
                        "trainingId": "ab40dcda-e253-4ff3-95e9-314e4ce5ba39",
                        "providerId": "ab40dcda-e253-4ff3-95e9-314e4ce5ba39",
                        "attendanceDate": "2014-04-23T00:00:00"
                    },
                    {
                        "trainingName": "Economic - Business skills",
                        "providerName": "Hidden Provider",
                        "trainingId": "e9467886-42e0-467c-a338-a7fcbc66125f",
                        "providerId": "e9467886-42e0-467c-a338-a7fcbc66125f",
                        "attendanceDate": "2012-06-25T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Soil Management & Fertilizer Application",
                        "providerName": "Hidden Provider",
                        "trainingId": "17effec3-1284-4609-af41-2252b4dde8b5",
                        "providerId": "17effec3-1284-4609-af41-2252b4dde8b5",
                        "attendanceDate": "2012-07-25T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Composting",
                        "providerName": "Hidden Provider",
                        "trainingId": "96b16133-51ef-413c-afa5-24f74263126b",
                        "providerId": "96b16133-51ef-413c-afa5-24f74263126b",
                        "attendanceDate": "2012-06-25T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Pruning",
                        "providerName": "Hidden Provider",
                        "trainingId": "f05554c2-778b-44b6-972e-c2fea01d924f",
                        "providerId": "f05554c2-778b-44b6-972e-c2fea01d924f",
                        "attendanceDate": "2013-05-21T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Irrigation & Water Management",
                        "providerName": "Hidden Provider",
                        "trainingId": "560be929-134b-4b67-befd-f38fdbb2f7ad",
                        "providerId": "560be929-134b-4b67-befd-f38fdbb2f7ad",
                        "attendanceDate": "2012-06-25T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Safety & Hygiene",
                        "providerName": "Hidden Provider",
                        "trainingId": "96c36f93-90ce-4378-a9f2-8a8aaa780fd2",
                        "providerId": "96c36f93-90ce-4378-a9f2-8a8aaa780fd2",
                        "attendanceDate": "2013-05-21T00:00:00"
                    },
                    {
                        "trainingName": "GAP - Post Harvest",
                        "providerName": "Hidden Provider",
                        "trainingId": "d1c45ad7-046b-43de-b65e-012185c17f6a",
                        "providerId": "d1c45ad7-046b-43de-b65e-012185c17f6a",
                        "attendanceDate": "2012-06-25T00:00:00"
                    }
                ]
            }
        }
    ]
}

最佳答案

好的，那么您只需声明您的trainings type: nested 的属性(property)在您的映射中，如下所示:

{
  "mappings": {
    "person": {
      "properties": {
        "id": {
          "type": "string"
        },
        "name": {
          "type": "string"
        },
        "trainings": {
          "type": "nested",       <----- add "nested" here
          "properties": {
            "attendanceDate": {
              "type": "date",
              "format": "dateOptionalTime"
            },
            "providerId": {
              "type": "string",
              "index": "not_analyzed"
            },
            "trainingId": {
              "type": "string",
              "index": "not_analyzed"
            }
          }
        }
      }
    }
  }
}

然后您需要稍微更改聚合以使用新的 nested输入，像这样:

{
  "size": 0,
  "aggs": {
    "trainning_agg": {
      "nested": {            <----- use nested aggregation
        "path": "trainings"
      },
      "aggs": {
        "trainings": {
          "terms": {
            "field": "trainings.trainingId"
          },
          "aggs": {
            "provider_agg": {
              "terms": {
                "field": "trainings.providerId"
              }
            }
          }
        }
      }
    }
  }
}

响应将如您所料:

{
  ...
  "aggregations" : {
    "trainning_agg" : {
      "doc_count" : 19,
      "trainings" : {
        "doc_count_error_upper_bound" : 0,
        "sum_other_doc_count" : 0,
        "buckets" : [ {
          "key" : "17effec3-1284-4609-af41-2252b4dde8b5",
          "doc_count" : 2,
          "provider_agg" : {
            "doc_count_error_upper_bound" : 0,
            "sum_other_doc_count" : 0,
            "buckets" : [ {
              "key" : "17effec3-1284-4609-af41-2252b4dde8b5",
              "doc_count" : 2
            } ]
          }
        }, {
          "key" : "560be929-134b-4b67-befd-f38fdbb2f7ad",
          "doc_count" : 2,
          "provider_agg" : {
            "doc_count_error_upper_bound" : 0,
            "sum_other_doc_count" : 0,
            "buckets" : [ {
              "key" : "560be929-134b-4b67-befd-f38fdbb2f7ad",
              "doc_count" : 2
            } ]
          }
        }, {
          "key" : "5aaa2f31-6aa6-4d5a-86ea-8a25cb11247e",
          "doc_count" : 2,
          "provider_agg" : {
            "doc_count_error_upper_bound" : 0,
            "sum_other_doc_count" : 0,
            "buckets" : [ {
              "key" : "5aaa2f31-6aa6-4d5a-86ea-8a25cb11247e",
              "doc_count" : 2
            } ]
          }
        }, {
          "key" : "96b16133-51ef-413c-afa5-24f74263126b",
          "doc_count" : 2,
          "provider_agg" : {
            "doc_count_error_upper_bound" : 0,
            "sum_other_doc_count" : 0,
            "buckets" : [ {
              "key" : "96b16133-51ef-413c-afa5-24f74263126b",
              "doc_count" : 2
            } ]
          }
        }, {
          "key" : "96c36f93-90ce-4378-a9f2-8a8aaa780fd2",
          "doc_count" : 2,
          "provider_agg" : {
            "doc_count_error_upper_bound" : 0,
            "sum_other_doc_count" : 0,
            "buckets" : [ {
              "key" : "96c36f93-90ce-4378-a9f2-8a8aaa780fd2",
              "doc_count" : 2
            } ]
          }
        }, {
          "key" : "ab40dcda-e253-4ff3-95e9-314e4ce5ba39",
          "doc_count" : 2,
          "provider_agg" : {
            "doc_count_error_upper_bound" : 0,
            "sum_other_doc_count" : 0,
            "buckets" : [ {
              "key" : "ab40dcda-e253-4ff3-95e9-314e4ce5ba39",
              "doc_count" : 2
            } ]
          }
        }, {
          "key" : "d1c45ad7-046b-43de-b65e-012185c17f6a",
          "doc_count" : 2,
          "provider_agg" : {
            "doc_count_error_upper_bound" : 0,
            "sum_other_doc_count" : 0,
            "buckets" : [ {
              "key" : "d1c45ad7-046b-43de-b65e-012185c17f6a",
              "doc_count" : 2
            } ]
          }
        }, {
          "key" : "e9467886-42e0-467c-a338-a7fcbc66125f",
          "doc_count" : 2,
          "provider_agg" : {
            "doc_count_error_upper_bound" : 0,
            "sum_other_doc_count" : 0,
            "buckets" : [ {
              "key" : "e9467886-42e0-467c-a338-a7fcbc66125f",
              "doc_count" : 2
            } ]
          }
        }, {
          "key" : "f05554c2-778b-44b6-972e-c2fea01d924f",
          "doc_count" : 2,
          "provider_agg" : {
            "doc_count_error_upper_bound" : 0,
            "sum_other_doc_count" : 0,
            "buckets" : [ {
              "key" : "f05554c2-778b-44b6-972e-c2fea01d924f",
              "doc_count" : 2
            } ]
          }
        }, {
          "key" : "c06e0cee-1050-41b6-ac83-ea3a00f0abb7",
          "doc_count" : 1,
          "provider_agg" : {
            "doc_count_error_upper_bound" : 0,
            "sum_other_doc_count" : 0,
            "buckets" : [ {
              "key" : "c06e0cee-1050-41b6-ac83-ea3a00f0abb7",
              "doc_count" : 1
            } ]
          }
        } ]
      }
    }
  }
}

关于ElasticSearch (Nest) 条款的条款子聚合 - 未按预期工作，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/30906080/

文章推荐： c# - 使用 FFT 确定低频信号的幅度

文章推荐： elasticsearch - ElasticSearch-获取聚合中的额外字段

文章推荐： android - 音频捕获Android无法正常工作

java - 预期 & .class 预期 java
我对java有点陌生，所以如果我犯了一个简单的错误，请原谅我，但我不确定我哪里出错了，我收到的错误是“预期的.class，预期的标识符，而不是声明， ';'预期的。”我尝试了不同的方法，并从这些方法中
mocha - Mocha ， Chai ，未捕获的AssertionError:预期{}等于{} +预期-实际
This question already has answers here: chai test array equality doesn't work as expected （3个答案） 3年前
java - 此行有多个标记 - 标记 ")"上的语法错误，；预期 - token "("上的语法错误，{预期
我正在学习 Java(对不起，我的英语很差，这不是我的母语)，当我在 Eclipse (JavaSE-1.7) 中在我输入的每个“try”中执行“try-finally” block 时，会出现以下消
java - token 语法错误，预期 ConstructorHeaderName 和 token 语法错误 "("，< 预期
我收到两个错误，指出 token 上的语法错误，ConstructorHeaderName expected instead & token “(”上的语法错误，< expected 在线: mTM.
Java :Multiple markers at this line - Syntax error on token “)” , ;预期 - token “(” 上的语法错误，{ 预期
我找不到错误。 Eclipse 给我这个错误。每个 { } 都是匹配的。请帮忙。 Multiple markers at this line - Syntax error on token “)”,
java - JApplet 程序 : error: ')' expected, 错误 : illegal start of type, 预期，错误: ';' 预期
代码: import java.awt.*; import javax.swing.*; import java.awt.event.*; public class DoubleIt extends
python - 预期 ")"
我正在用 python(Vs 代码)编写代码，但出现此错误: Expected ")" Pylance 错误发生在:def main() 我试着运行我的 main 并将它打印到我的屏幕上。我用谷歌搜
reactjs - 异步函数意外标记，预期 (
我正在尝试按照 documentation 中的建议使用异步函数。但我收到此错误意外的 token ，预期 ( async function getMoviesFromApi() { try
java - Java非法启动类型)预期
Closed. This question does not meet Stack Overflow guidelines。它当前不接受答案。想改善这个问题吗？更新问题，以便将其作为on-topic
java - ActionListener编译错误-;预期
Closed. This question does not meet Stack Overflow guidelines。它当前不接受答案。想改善这个问题吗？更新问题，以便将其作为on-topic
java - 第21行显示;预期
第一行包含一个表示数组长度的整数p。第二行包含用空格分隔的整数，这些整数描述数组中的每个元素。第三行打印一个整数，指示负数组的数量。 package asgn3; import java.util.*
Java 表达式语言错误 ";"预期
好的，我是初学者，我必须修复此 java 表达式语言代码才能在我的系统 (Windchill) 中工作，但看起来我在语法中遗漏了一些内容: LWCNormalizedObject lwc =
java - 预期 )，表达式的非法开始
我无法编译我的程序! 我想我缺少一个花括号，但我怎么也看不出在哪里! import javax.swing.*; import java.awt.*;
预期 jQuery 选择器
我的 jQuery 代码有问题，我的 Firebug 向我发出警告:需要选择器。这是代码: $("img[id$='_tick']").each(function() { $(this).c
c++ - 预期 { 在析构函数之前
我的新类(class) Fountainofyouth 遇到了问题。尝试构建整个项目后，调试器显示 warning: extended initializer lists only available
c++ - 预期 { 在输入结束时
我已经从 Java 转向 CPP，并且正在努力围绕构造构造函数链进行思考，我认为这是我的问题的根源。我的头文件如下: public: GuidedTour(); GuidedTour(string
javascript - jsLint 预期 {
鉴于以下 for(var i=0; i< data.cats.length; i++) list += buildCategories(data.cats[i]); jsLint 告诉我 Expect
json - 类型不正确。预期 "object"
我有这个 json，但 Visual Studio Code 在标题中给了我警告。 [ { "title": "Book A", "imageUrl": "https:
c++ - 预期 move_assignment 被删除
我正在尝试编写一个有条件地禁用四个特殊成员函数(复制构造、移动构造、复制赋值和移动赋值)的包装类，下面是我用于测试目的的快速草稿: enum class special_member : uint8_
F#:预期 'in' 或其他标记错误
所以我用 F# 编写了一个非常简单的程序，它应该对 1000 以下的所有 3 和 5 的倍数求和: [1..999] |> List.filter (fun x -> x % 3 = 0 || x %

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

ElasticSearch (Nest) 条款的条款子聚合 - 未按预期工作