top of page

ES Aggregation sort and sub aggs

  • taolius
  • Mar 19, 2018
  • 1 min read

SortOrder sortOrderEnum = SortOrder.DESC; SortBuilder<?> sortBuilder = SortBuilders.fieldSort("dcCreateTime").order(sortOrderEnum); AggregationBuilder metricAgg = AggregationBuilders.terms("metricName").field("metricName") .subAggregation(AggregationBuilders.topHits("latest").size(1).sort(sortBuilder)); AbstractAggregationBuilder<?> groupAgg = AggregationBuilders.terms("metricGroup").field("metricGroupName").subAggregation(metricAgg);

or order:

aggregationBuilders.subAggregation(AggregationBuilders.terms("bySubCategory").field("metricName") .size(ElasticSearchSizeEnum.ESMAX.getSize()) .subAggregation(AggregationBuilders.stats("byTotal") .field("metricValue")).order(Terms.Order.aggregation("bySequence", "isntanceType", true)));

 
 
 

Comments


© 2023 by BI World. Proudly created with Wix.com

  • Facebook Basic Black
  • Twitter Basic Black
  • YouTube Basic Black
bottom of page