es searchResponse.getAggregations().get("xxx")用法

最新推荐文章于 2025-01-09 19:41:00 发布

原创最新推荐文章于 2025-01-09 19:41:00 发布 · 1w 阅读

8 ·

CC 4.0 BY-SA版权

本文详细介绍了如何使用Elasticsearch进行数据的分组聚合分析，包括按国家和加入日期进行分组，并计算各组的平均年龄。通过具体代码示例展示了如何使用terms和dateHistogram聚合来实现数据的多维度分析。

部署运行你感兴趣的模型镜像

这里分组根据时间字符串
SearchResponse searchResponse = client.prepareSearch("company")
        .addAggregation(AggregationBuilders.terms("group_country").field("country")
             .subAggregation(AggregationBuilders
                             .terms("group_join")
                             .field("join_date")
                             .subAggregation(AggregationBuilders.avg("avg_age").field("age"))
                        )
        ).execute().actionGet();
StringTerms group_country = (StringTerms)searchResponse.getAggregations().asMap().get("group_country");
Terms  group_country1 = searchResponse.getAggregations().get("group_country");

Iterator<Terms.Bucket> iterator = group_country1.getBuckets().iterator();
while (iterator.hasNext()){
    Terms.Bucket next = iterator.next();
    System.out.println(next.getKey()+":\t"+next.getDocCount());
    Terms join_date = next.getAggregations().get("group_join");
    Iterator<Terms.Bucket> iterator1 = join_date.getBuckets().iterator();
    while (iterator1.hasNext()){
        Terms.Bucket next1 = iterator1.next();
        System.out.println(next1.getKey()+":\t"+next1.getDocCount());
        Avg avg_age = (Avg)next1.getAggregations().asMap().get("avg_age");
        System.out.println(avg_age.getValue());

    }
}

这里的分组根据date格式
SearchResponse searchResponse = client.prepareSearch("company")
          .addAggregation(AggregationBuilders.terms("group_country").field("country")
                  .subAggregation(AggregationBuilders
                          .dateHistogram("group_join")
                          .field("join_date")
                          .dateHistogramInterval(DateHistogramInterval.YEAR)//根据年分组
                          .subAggregation(AggregationBuilders.avg("avg_age").field("age")))
          )
          .execute().actionGet();

  Map<String, Aggregation> aggrMap = searchResponse.getAggregations().asMap();

  StringTerms groupByCountry = (StringTerms) aggrMap.get("group_country");
  Iterator<Bucket> groupByCountryBucketIterator = groupByCountry.getBuckets().iterator();
  while(groupByCountryBucketIterator.hasNext()) {
      Bucket groupByCountryBucket = groupByCountryBucketIterator.next();
      System.out.println(groupByCountryBucket.getKey() + ":" + groupByCountryBucket.getDocCount());

      Histogram groupByJoinDate = (Histogram) groupByCountryBucket.getAggregations().asMap().get("group_join");
      Iterator<Histogram.Bucket> groupByJoinDateBucketIterator = groupByJoinDate.getBuckets().iterator();
      while(groupByJoinDateBucketIterator.hasNext()) {
          org.elasticsearch.search.aggregations.bucket.histogram.Histogram.Bucket groupByJoinDateBucket = groupByJoinDateBucketIterator.next();
          System.out.println(groupByJoinDateBucket.getKey() + ":" +groupByJoinDateBucket.getDocCount());

          Avg avg = (Avg) groupByJoinDateBucket.getAggregations().asMap().get("avg_age");
          System.out.println(avg.getValue());
      }
  }

主要是为了学习searchResponse.getAggregations().get("xxx") 返回类型可以转换为Terms

同时也有Histogram(时间格式) Avg(求平均数) StringTerms(字符串)

通过报错信息看出当前的类型

如:ClassCastException: org.elasticsearch.search.aggregations.bucket.terms.LongTerms cannot be cast to

这时候选Terms

您可能感兴趣的与本文相关的镜像