【Elasticsearch】Elasticsearch中 aggs （桶）聚合查询和进行二次聚合查询

最新推荐文章于 2024-04-03 18:00:35 发布
最新推荐文章于 2024-04-03 18:00:35 发布
阅读量3.1k 收藏 22
点赞数 20
分类专栏： Elasticsearch 文章标签： elasticsearch 大数据 搜索引擎
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/SSHH_ZHU/article/details/126441535
版权

【Elasticsearch】Elasticsearch中 aggs （桶）聚合查询和进行二次聚合查询

  • Bucket aggregationsedit
    Bucket aggregations don’t calculate metrics over fields like the metrics aggregations do, but instead, they create buckets of documents. Each bucket is associated with a criterion (depending on the aggregation type) which determines whether or not a document in the current context “falls” into it. In other words, the buckets effectively define document sets. In addition to the buckets themselves, the bucket aggregations also compute and return the number of documents that “fell into” each bucket.
    Bucket aggregations, as opposed to metrics aggregations, can hold sub-aggregations. These sub-aggregations will be aggregated for the buckets created by their “parent” bucket aggregation.（大致意思就是，把你指定的数据放入一个桶中，然后返回其文档的数量和你指定字段）

官方文档

以下是几个简单的例子

这里需要先准备数据

POST /product/_bulk
{"index":{"_id":1}}
{"name":"曼克顿全麦面包","desc":"曼克顿全麦面包，超级松软","price":9.00,"lv":"高端面包","type":"面包","createtime":"2022-11-01T08:00:00Z","tags":["松软","全麦","健康"]}
{"index":{"_id":2}}
{"name":"曼克顿高钙面包","desc":"曼克顿高钙面包，每片含0.01g钙","price":10.29,"lv":"高端面包","type":"面包","createtime":"2022-05-21T08:00:00Z","tags":["营养","高钙","儿童"]}
{"index":{"_id":3}}
{"name":"果子面包","desc":"百年义利，老字号品牌面包","price":9.99,"lv":"高端面包","type":"面包","createtime":"2022-06-20","tags":["品牌","老字号","百年义利用"]}
{"index":{"_id":4}}
{"name":"曼克顿巧克力","desc":"曼克顿巧克力，代脂巧克力","price":30,"lv":"代脂巧克力","type":"糖果，巧克力","createtime":"2022-06-23","tags":["代脂巧克力","巧克力","奶油巧克力"]}
{"index":{"_id":5}}
{"name":"百醇巧克力","desc":"百醇巧克力，纯享可香可","price":55,"type":"糖果，巧克力","lv":"可可巧克力","createtime":"2022-07-20","tags":["可可巧克力","巧克力","奶油巧克力"]}
{"index":{"_id":6}}
{"name":"小米手机10","desc":"充电贼快掉电更快，超级无敌望远镜，高刷电竞屏","price":"","lv":"旗舰机","type":"手机","createtime":"2021-07-27","tags":["120HZ刷新率","120W快充","120倍变焦"]}
{"index":{"_id":7}}
{"name":"飞翔SE2","desc":"除了飞行模式，一无是处","price":"3299","lv":"旗舰机","type":"手机","createtime":"2020-07-21","tags":["割韭菜","割韭菜","割新韭菜"]}
{"index":{"_id":8}}
{"name":"XS Max","desc":"听说要出新款12手机了，终于可以换掉手中的Xs了","price":4399,"lv":"旗舰机","type":"手机","createtime":"2020-08-19","tags":["5V1A","4G全网通","大"]}
{"index":{"_id":9}}
{"name":"小米电视","desc":"70寸性价比只选，不要一万八，要不要八千八，只要两千九百九十八","price":2998,"lv":"高端机","type":"耳机","createtime":"2020-08-16","tags":["巨馍","家庭影院","游戏"]}
{"index":{"_id":10}}
{"name":"红米电视","desc":"我比上边那个更划算，我也2998，我也70寸，但是我更好看","price":2999,"type":"电视","lv":"高端机","createtime":"2020-08-28","tags":["大片","蓝光8K","超薄"]}
{"index":{"_id":11}}
{"name":"红米电视","desc":"我比上边那个更划算，我也2998，我也70寸，但是我更好看","price":2998,"type":"电视","lv":"高端机","createtime":"2020-08-28","tags":["大片","蓝光8K","超薄"]}
  • 普通的聚合查询(按照标签进行聚合，并且按照数量升序排序）
#聚合查询agg 
GET product/_search
{
  "size": 0, 
  "aggs": {
    "aggs_tag":{
      "terms": {
        "field": "tags.keyword",
        "order": {
          "_count": "asc"
        }
      }
    }
  }
}

搜索结果：

{
  "took": 1,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 11,
      "relation": "eq"
    },
    "max_score": null,
    "hits": []
  },
  "aggregations": {
    "aggs_tag": {
      "doc_count_error_upper_bound": -1,
      "sum_other_doc_count": 22,
      "buckets": [
        {
          "key": "120HZ刷新率",
          "doc_count": 1
        },
        {
          "key": "120W快充",
          "doc_count": 1
        },
        {
          "key": "120倍变焦",
          "doc_count": 1
        },
        {
          "key": "4G全网通",
          "doc_count": 1
        },
        {
          "key": "5V1A",
          "doc_count": 1
        },
        {
          "key": "代脂巧克力",
          "doc_count": 1
        },
        {
          "key": "健康",
          "doc_count": 1
        },
        {
          "key": "儿童",
          "doc_count": 1
        },
        {
          "key": "全麦",
          "doc_count": 1
        },
        {
          "key": "割新韭菜",
          "doc_count": 1
        }
      ]
    }
  }
}
  • 聚合查询价格最高
GET product/_search
{
  "size": 0, 
  "aggs": {
    "max_price":{
      "max": {
        "field": "price"
      }
    }
  }
}

搜索结果如下

{
  "took": 6,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 11,
      "relation": "eq"
    },
    "max_score": null,
    "hits": []
  },
  "aggregations": {
    "max_price": {
      "value": 4399
    }
  }
}

接下就本文重点了，是使用agg 进行二次聚合

  • 平均价格最低的商品分类
  • 使用 pipline 进行聚合查询
GET product/_search
{
  "size": 0,
  "aggs": {
    "product_type": {
      "terms": {
        "field": "type.keyword"
      },
      "aggs": {
        "price_type_avg": {
          "avg": {
            "field": "price"
          }
        }
      }
    },
    "min_avg_type":{
      "min_bucket": {
        "buckets_path": "product_type>price_type_avg"
      }
    }
  }
}

搜索结果：

{
  "took": 5,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 11,
      "relation": "eq"
    },
    "max_score": null,
    "hits": []
  },
  "aggregations": {
    "product_type": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 0,
      "buckets": [
        {
          "key": "手机",
          "doc_count": 3,
          "price_type_avg": {
            "value": 3849
          }
        },
        {
          "key": "面包",
          "doc_count": 3,
          "price_type_avg": {
            "value": 9.759999910990397
          }
        },
        {
          "key": "电视",
          "doc_count": 2,
          "price_type_avg": {
            "value": 2998.5
          }
        },
        {
          "key": "糖果，巧克力",
          "doc_count": 2,
          "price_type_avg": {
            "value": 42.5
          }
        },
        {
          "key": "耳机",
          "doc_count": 1,
          "price_type_avg": {
            "value": 2998
          }
        }
      ]
    },
    "min_avg_type": {
      "value": 9.759999910990397,
      "keys": [
        "面包"
      ]
    }
  }
}
  • 按照类型聚合后，再次按照等级聚合，再次向价格聚合，后获取每个类型下每个标签 桶 中价格最大的
GET product/_search
{
  "size": 0,
  "aggs": {
    "product_type": {
      "terms": {
        "field": "type.keyword"
      },
      "aggs": {
        "lv_aggs": {
          "terms": {
            "field": "lv.keyword"
          },
          "aggs": {
            "lv_price": {
              "stats": {
                "field": "price"
              }
            },
            "tages_buckets": {
              "terms": {
                "field": "tags.keyword"
              }
            }
          }
        },
        "max_type": {
          "max_bucket": {
            "buckets_path": "lv_aggs>lv_price.max"
          }
        }
      }
    }
  }
}

搜索结果如下：

{
  "took": 1,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 11,
      "relation": "eq"
    },
    "max_score": null,
    "hits": []
  },
  "aggregations": {
    "product_type": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 0,
      "buckets": [
        {
          "key": "手机",
          "doc_count": 3,
          "lv_aggs": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": "旗舰机",
                "doc_count": 3,
                "tages_buckets": {
                  "doc_count_error_upper_bound": 0,
                  "sum_other_doc_count": 0,
                  "buckets": [
                    {
                      "key": "120HZ刷新率",
                      "doc_count": 1
                    },
                    {
                      "key": "120W快充",
                      "doc_count": 1
                    },
                    {
                      "key": "120倍变焦",
                      "doc_count": 1
                    },
                    {
                      "key": "4G全网通",
                      "doc_count": 1
                    },
                    {
                      "key": "5V1A",
                      "doc_count": 1
                    },
                    {
                      "key": "割新韭菜",
                      "doc_count": 1
                    },
                    {
                      "key": "割韭菜",
                      "doc_count": 1
                    },
                    {
                      "key": "大",
                      "doc_count": 1
                    }
                  ]
                },
                "lv_price": {
                  "count": 2,
                  "min": 3299,
                  "max": 4399,
                  "avg": 3849,
                  "sum": 7698
                }
              }
            ]
          },
          "max_type": {
            "value": 4399,
            "keys": [
              "旗舰机"
            ]
          }
        },
        {
          "key": "面包",
          "doc_count": 3,
          "lv_aggs": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": "高端面包",
                "doc_count": 3,
                "tages_buckets": {
                  "doc_count_error_upper_bound": 0,
                  "sum_other_doc_count": 0,
                  "buckets": [
                    {
                      "key": "健康",
                      "doc_count": 1
                    },
                    {
                      "key": "儿童",
                      "doc_count": 1
                    },
                    {
                      "key": "全麦",
                      "doc_count": 1
                    },
                    {
                      "key": "品牌",
                      "doc_count": 1
                    },
                    {
                      "key": "松软",
                      "doc_count": 1
                    },
                    {
                      "key": "百年义利用",
                      "doc_count": 1
                    },
                    {
                      "key": "老字号",
                      "doc_count": 1
                    },
                    {
                      "key": "营养",
                      "doc_count": 1
                    },
                    {
                      "key": "高钙",
                      "doc_count": 1
                    }
                  ]
                },
                "lv_price": {
                  "count": 3,
                  "min": 9,
                  "max": 10.289999961853027,
                  "avg": 9.759999910990397,
                  "sum": 29.27999973297119
                }
              }
            ]
          },
          "max_type": {
            "value": 10.289999961853027,
            "keys": [
              "高端面包"
            ]
          }
        },
        {
          "key": "电视",
          "doc_count": 2,
          "lv_aggs": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": "高端机",
                "doc_count": 2,
                "tages_buckets": {
                  "doc_count_error_upper_bound": 0,
                  "sum_other_doc_count": 0,
                  "buckets": [
                    {
                      "key": "大片",
                      "doc_count": 2
                    },
                    {
                      "key": "蓝光8K",
                      "doc_count": 2
                    },
                    {
                      "key": "超薄",
                      "doc_count": 2
                    }
                  ]
                },
                "lv_price": {
                  "count": 2,
                  "min": 2998,
                  "max": 2999,
                  "avg": 2998.5,
                  "sum": 5997
                }
              }
            ]
          },
          "max_type": {
            "value": 2999,
            "keys": [
              "高端机"
            ]
          }
        },
        {
          "key": "糖果，巧克力",
          "doc_count": 2,
          "lv_aggs": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": "代脂巧克力",
                "doc_count": 1,
                "tages_buckets": {
                  "doc_count_error_upper_bound": 0,
                  "sum_other_doc_count": 0,
                  "buckets": [
                    {
                      "key": "代脂巧克力",
                      "doc_count": 1
                    },
                    {
                      "key": "奶油巧克力",
                      "doc_count": 1
                    },
                    {
                      "key": "巧克力",
                      "doc_count": 1
                    }
                  ]
                },
                "lv_price": {
                  "count": 1,
                  "min": 30,
                  "max": 30,
                  "avg": 30,
                  "sum": 30
                }
              },
              {
                "key": "可可巧克力",
                "doc_count": 1,
                "tages_buckets": {
                  "doc_count_error_upper_bound": 0,
                  "sum_other_doc_count": 0,
                  "buckets": [
                    {
                      "key": "可可巧克力",
                      "doc_count": 1
                    },
                    {
                      "key": "奶油巧克力",
                      "doc_count": 1
                    },
                    {
                      "key": "巧克力",
                      "doc_count": 1
                    }
                  ]
                },
                "lv_price": {
                  "count": 1,
                  "min": 55,
                  "max": 55,
                  "avg": 55,
                  "sum": 55
                }
              }
            ]
          },
          "max_type": {
            "value": 55,
            "keys": [
              "可可巧克力"
            ]
          }
        },
        {
          "key": "耳机",
          "doc_count": 1,
          "lv_aggs": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
              {
                "key": "高端机",
                "doc_count": 1,
                "tages_buckets": {
                  "doc_count_error_upper_bound": 0,
                  "sum_other_doc_count": 0,
                  "buckets": [
                    {
                      "key": "家庭影院",
                      "doc_count": 1
                    },
                    {
                      "key": "巨馍",
                      "doc_count": 1
                    },
                    {
                      "key": "游戏",
                      "doc_count": 1
                    }
                  ]
                },
                "lv_price": {
                  "count": 1,
                  "min": 2998,
                  "max": 2998,
                  "avg": 2998,
                  "sum": 2998
                }
              }
            ]
          },
          "max_type": {
            "value": 2998,
            "keys": [
              "高端机"
            ]
          }
        }
      ]
    }
  }
}

以下做一个小的测试，以证明，配合query的优先级高于聚合查询你，所以可以先再query种过滤一部分数据再去聚合，这样减少Es的内存使用提高性能

GET product/_search
{
  "size": 10,
  "query": {
    "range": {
      "price": {
        "gte": 10,
        "lte": 60
      }
    }
  },
  "aggs": {
    "tags_bucket": {
      "terms": {
        "field": "tags.keyword"
      }
    }
  }
}

搜索后的结果如下：(这里值展示了金额再10 ~60 范围内的 一些面包和糖果)

{
  "took": 1,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 3,
      "relation": "eq"
    },
    "max_score": 1,
    "hits": [
      {
        "_index": "product",
        "_id": "2",
        "_score": 1,
        "_source": {
          "name": "曼克顿高钙面包",
          "desc": "曼克顿高钙面包，每片含0.01g钙",
          "price": 10.29,
          "lv": "高端面包",
          "type": "面包",
          "createtime": "2022-05-21T08:00:00Z",
          "tags": [
            "营养",
            "高钙",
            "儿童"
          ]
        }
      },
      {
        "_index": "product",
        "_id": "4",
        "_score": 1,
        "_source": {
          "name": "曼克顿巧克力",
          "desc": "曼克顿巧克力，代脂巧克力",
          "price": 30,
          "lv": "代脂巧克力",
          "type": "糖果，巧克力",
          "createtime": "2022-06-23",
          "tags": [
            "代脂巧克力",
            "巧克力",
            "奶油巧克力"
          ]
        }
      },
      {
        "_index": "product",
        "_id": "5",
        "_score": 1,
        "_source": {
          "name": "百醇巧克力",
          "desc": "百醇巧克力，纯享可香可",
          "price": 55,
          "type": "糖果，巧克力",
          "lv": "可可巧克力",
          "createtime": "2022-07-20",
          "tags": [
            "可可巧克力",
            "巧克力",
            "奶油巧克力"
          ]
        }
      }
    ]
  },
  "aggregations": {
    "tags_bucket": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 0,
      "buckets": [
        {
          "key": "奶油巧克力",
          "doc_count": 2
        },
        {
          "key": "巧克力",
          "doc_count": 2
        },
        {
          "key": "代脂巧克力",
          "doc_count": 1
        },
        {
          "key": "儿童",
          "doc_count": 1
        },
        {
          "key": "可可巧克力",
          "doc_count": 1
        },
        {
          "key": "营养",
          "doc_count": 1
        },
        {
          "key": "高钙",
          "doc_count": 1
        }
      ]
    }
  }
}
  • 这是一个带有【global】的查询，因为使用了 global agg,所以会导致，【all_min_price】 这个是 从全局获取的数据，进行聚合的。官方文档也解释了，这样做是没有意义的
    在这里插入图片描述

global 官方文档

GET product/_search
{
  "query": {
    "constant_score": {
      "filter": {
        "range": {
          "price": {
            "gte": 3000
          }
        }
      },
      "boost": 1.2
    }
  },
  "aggs": {
    "stat_data": {
      "stats": {
        "field": "price"
      }
    },
    "all_min_price": {
      "global": {},
      "aggs": {
        "global_avg_price": {
          "min": {
            "field": "price"
          }
        }
      }
    },
    "muti_rang_price": {
      "filter": {
        "range": {
          "price": {
            "lte": 4000
          }
        }
      },
      "aggs": {
        "avg_400_pirce": {
          "avg": {
            "field": "price"
          }
        }
      }
    }
  }
}
  • 多级聚合并且排序
    在耳机聚下会把巨厚的数据金一个排序展示。此实例是按照各个商品价格总和的降序进行排序展示
GET product/_search
{
  "size": 0,
  "aggs": {
    "type_args": {
      "terms": {
        "field": "type.keyword",
        "order": {
          "stat_data.sum": "desc"
        }
      },
      "aggs": {
        "stat_data": {
          "stats": {
            "field": "price"
          }
        }
      }
    }
  }
}

结果如下

{
  "took": 5,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 11,
      "relation": "eq"
    },
    "max_score": null,
    "hits": []
  },
  "aggregations": {
    "type_args": {
      "doc_count_error_upper_bound": 0,
      "sum_other_doc_count": 0,
      "buckets": [
        {
          "key": "手机",
          "doc_count": 3,
          "stat_data": {
            "count": 2,
            "min": 3299,
            "max": 4399,
            "avg": 3849,
            "sum": 7698
          }
        },
        {
          "key": "电视",
          "doc_count": 2,
          "stat_data": {
            "count": 2,
            "min": 2998,
            "max": 2999,
            "avg": 2998.5,
            "sum": 5997
          }
        },
        {
          "key": "耳机",
          "doc_count": 1,
          "stat_data": {
            "count": 1,
            "min": 2998,
            "max": 2998,
            "avg": 2998,
            "sum": 2998
          }
        },
        {
          "key": "糖果，巧克力",
          "doc_count": 2,
          "stat_data": {
            "count": 2,
            "min": 30,
            "max": 55,
            "avg": 42.5,
            "sum": 85
          }
        },
        {
          "key": "面包",
          "doc_count": 3,
          "stat_data": {
            "count": 3,
            "min": 9,
            "max": 10.289999961853027,
            "avg": 9.759999910990397,
            "sum": 29.27999973297119
          }
        }
      ]
    }
  }
}
馍 馍
关注
  • 20
    点赞
  • 踩
  • 22
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Elasticsearch聚合 之 Terms
06-19
Elasticsearch中的Terms聚合是一种常用的聚合方式，用于对文档中的某个字段进行分组统计。Terms聚合可以对文档中的某个字段进行分组，并统计每个组中的文档数量。 在Elasticsearch中，Terms聚合可以使用以下方式...
es数据聚合
CV工程师呀
02-09 2902
1.kibana实现 1.1.聚合的种类 聚合常见的有三类： 桶（Bucket）聚合：用来对文档做分组 TermAggregation：按照文档字段值分组，例如按照品牌值分组、按照国家分组 Date Histogram：按照日期阶梯分组，例如一周为一组，或者一月为一组 度量（Metric）聚合：用以计算一些值，比如：最大值、最小值、平均值等 Avg：求平均值 Max：求最大值 Min：求最小值 Stats：同时求max、min、avg、sum等 管道（pipeline）聚合：其它聚合的结
ElasticSearch - 聚合 aggs 详解
weixin_46742102的博客
09-29 5565
聚合概念 ElasticSearch除了致力于搜索之外，也提供了聚合实时分析数据的功能 如果把搜索比喻为大海捞针(从海量的文档中找出符合条件的那一个)，那麽聚合就是去分析大海中的针们的特性，像是 在大海里有多少针？ 针的平均长度是多少？ 按照针的製造商来划分，针的长度中位值是多少？ 每月加入到海中的针有多少？ 这里面有异常的针麽？ 因此透过聚合，我们可以得到一个数据的
Elasticsearch-桶聚合查询详解
最新发布
苍煜
04-03 1804
在之前我们详细面熟了es的查询用法，但是es还拥有强大的聚合查询功能，可以得到类似分组，直方图，折线图等数据组合。类似SQL的SUM、AVG、COUNT、GROUP BY Elasticsearch-02-es的restapi使用ES聚合查询类似SQL的GROUP by，一般统计分析主要分为两个步骤：es中满足特定条件的文档的集合，叫做桶。 桶的就是一组数据的集合，对数据分组后，得到一组组的数据，就是一个个的桶。ES中桶聚合，指的就是先对数据进行分组，ES支持多种分组条件，例如：支持类似SQL的group
ES多个字段聚合分组，在结果上执行二次统计分析
gaoCSDN996的博客
04-18 512
【代码】ES多个字段聚合分组，在结果上执行二次统计分析。
Elasticsearch(二)：进阶检索
热门推荐
学习记录和总结
03-03 1万+
Elasticsearch DSL检索语句、Mapping、分词、搜索原理的介绍和说明
【Elasticsearch】 05-桶聚合查询详解及示例
程序员小屋
06-24 790
桶聚合查询是一种将文档分组到不同的桶（buckets）中的方式。每个桶代表一个特定的条件或者属性。桶聚合查询通常用于统计、分析和聚合数据。
elasticsearch聚合值过滤
03-02
在 Elasticsearch（ES）中，聚合（Aggregations）是一种强大的数据汇总工具，允许用户对索引中的数据进行分组和统计分析。而“elasticsearch聚合值过滤”是ES聚合功能的一个高级应用场景，它允许我们根据聚合计算出...
ElasticSearch增删改查以及聚合查询
12-17
ElasticSearch增删改查以及聚合查询 ElasticSearch是一款功能强大且灵活的搜索引擎，它提供了丰富...同时，ElasticSearch也提供了丰富的数据类型，包括数字、字符串、日期、对象等，可以满足各种数据存储和查询需求。
ElasticSearch高级查询.zip
01-09
在ES中，高级查询是超越基本的关键词搜索，涉及到更复杂的筛选、排序和聚合等功能，能够帮助用户获取更精确、更丰富的搜索结果。 ### 1. 查询DSL (Domain Specific Language) Elasticsearch使用JSON格式的Query ...
Elasticsearch-03
08-14
Elasticsearch-03 Elasticsearch 是一个基于 Lucene 库的开源搜索引擎，提供了分布式搜索引擎的解决方案。...Elasticsearch 的聚合功能提供了强大的数据分析和统计能力，让我们可以快速实现对数据的统计、分析、运算。
es1.7.2 按照_type先聚合，再按照时间二次聚合
zhanghe687的博客
08-14 797
【代码】es1.7.2 按照_type先聚合，再按照时间二次聚合。
es管道二次聚合查询转java
jifgnie的博客
03-19 276
es管道二次聚合查询转java。
Elasticsearch：aggregation 介绍
Elastic 中国社区官方博客
11-02 6116
聚合(aggregation)功能集是整个Elasticsearch产品中最令人兴奋和有益的功能之一，主要是因为它提供了一个非常有吸引力对之前的facets的替代。 在本教程中，我们将解释Elasticsearch中的聚合（aggregation）并逐步介绍一些示例。 我们比较了指标聚合和存储桶聚合，并展示了如何利用聚合嵌套（对于facets而言这是不可能的）。 欢迎您在本文中复制所有示例代码。......
ES桶聚合查询过滤桶——bucket_selector的用法介绍
LiuLei_2015的博客
08-01 951
如果你想把桶聚合结果也过滤一把，只返回满足你需要的桶，那么你应该使用ES的Pipeline aggregations -> bucket_selector。
ES中使用 Top Hits 查询分桶聚合结果的每个桶的详细数据
Elastic开源社区
06-02 2237
Top hits（顶部命中）是一个聚合功能，用于在查询结果中返回每个桶（bucket）中的顶部 N 个文档。这对于需要在聚合结果中查看每个桶中的最相关或最高评分文档的情况非常有用。简单来说，Top Hits 就是对聚合结果中相关文档的详细展示，它不同于 Post Filter，Post Filter 是基于源数据的查询，和 Agg 没有因果关系，其结果不对 Aggs 产生任何影响。Top Hits 则是基于 Aggs 的结果的查询，其受到 Aggs 结果的影响。
Elasticsearch实战（十四）---聚合搜索Aggs多层嵌套聚合处理
流浪的喵的博客
07-10 5690
elasticsearch 聚合操作 搜索 Aggs聚合， 实现Count求和计数，Avg求平均值操作及多层分组嵌套聚合查询
JAVA代码实现ElasticSearch搜索（入门-进阶）(二):聚合函数，group by 分组 ，分桶，桶聚合 bucketing，双重聚合
majunssz的博客
05-24 4499
JAVA代码实现ElasticSearch搜索（入门-进阶）(二):聚合函数 （group by），双重聚合
es 聚合查询排除null_elasticsearch 聚合查询篇
06-02
好的，针对您的问题，您可以使用 Elasticsearch 的聚合查询中的“missing”聚合来排除 null 值。 具体来说，您可以使用以下的聚合查询语句： ``` { "aggs": { "field_name": { "missing": { "field": "your_field_name" } } } } ``` 其中，“field_name”是您想要聚合的字段名称，“your_field_name”是您想要排除 null 值的字段名称。 这样，您就可以得到该字段的非 null 值的聚合结果了。希望这能够帮助到您！

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值