ElasticSearch DSL聚合

最新推荐文章于 2024-08-04 07:56:44 发布

chuiyilu9966

最新推荐文章于 2024-08-04 07:56:44 发布

阅读量568

点赞数

文章标签：大数据

原文链接：https://my.oschina.net/u/3359005/blog/1914887

版权

字段聚合:

DSL:

{
  "aggs": {
    "all_course": {
      "terms": { "field": "golf_course_id" }
    }
  }
}

结果:

{
    "aggregations": {
        "all_course": {
            "doc_count_error_upper_bound": 734,
            "sum_other_doc_count": 190883,
            "buckets": [
                { "key": 183, "doc_count": 1629 },
                { "key": 3, "doc_count": 1055 }
            ]
        }
    }
}

聚合后汇总计算

DSL:

{
  "aggs": {
    "all_course": {
      "terms": { "field": "golf_course_id" },
      "aggs": {
        "avg_prepay_price": { "avg": { "field": "prepay_price" } }
      }
    }
  }
}

结果:

{
  "aggregations": {
    "all_course": {
      "doc_count_error_upper_bound": 734,
      "sum_other_doc_count": 190883,
      "buckets": [
        { "key": 183,
          "doc_count": 1629,
          "avg_age": { "value": 575.7667280540209 }
        },
        {
          "key": 3,
          "doc_count": 1055,
          "avg_age": { "value": 831.0710900473933 }
        }
      ]
    }
  }
}

转载于:https://my.oschina.net/u/3359005/blog/1914887