elasticsearch - 获取多个平均聚合

Question

我有一个查询，我在哪里按智能手机然后按运营商分组。在这些嵌套的聚合中，我想找到该特定智能手机的每个运营商的平均价格，评级和速度。这是我当前的查询:

{
  "aggs": {
    "group_by_smartphone": {
      "terms": {
        "field": "smartphone"
      },
      "aggs": {
        "group_by_carrier": {
          "terms": {
            "field": "carrier"
          },
          "aggs": {
            "group_by_avg_price": {
              "avg": {
                "field": "price"
              }
            }
          },

            "group_by_rating":{
              "avg":{
                "field": "rating"
              }
            }

        }
      }
    }
  }
}

在当前查询中，我收到一条错误消息:

"type": "parsing_exception", "reason": "Found two aggregation type definitions in [group_by_carrier]: [terms] and [group_by_rating]",

我如何解决此问题以显示每个平均值的正确结果？

Answer 1

尝试以下方法:

{
  "aggs": {
    "group_by_smartphone": {
      "terms": {
        "field": "smartphone"
      },
      "aggs": {
        "group_by_carrier": {
          "terms": {
            "field": "carrier"
          },
          "aggs": {
            "avg_price": {
              "avg": {
                "field": "price"
              }
            },
            "avg_rating":{
              "avg":{
                "field": "rating"
              }
            },
            "avg_speed":{
              "avg":{
                "field": "speed"
              }
            }
          }    
        }
      }
    }
  }
}

所有子聚合都必须位于相同的 aggs结构内。