Elastic Stack：es JavaApi聚合搜索入门

一.基本查询

需求一：按照颜色分组，计算每个颜色卖出的个数

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

@Test public void testAggs() throws IOException {     SearchRequest request = new SearchRequest("tvs");     SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();     searchSourceBuilder.size(0);     searchSourceBuilder.query(QueryBuilders.matchAllQuery());     searchSourceBuilder.aggregation(AggregationBuilders.terms("group_by_colors").field("color"));     request.source(searchSourceBuilder);     SearchResponse response = client.search(request, RequestOptions.DEFAULT);     Aggregations aggregations = response.getAggregations();     Terms aggregation = aggregations.get("group_by_colors");     List<? extends Terms.Bucket> buckets = aggregation.getBuckets();     for (Terms.Bucket bucket : buckets) {         System.out.println(bucket.getKeyAsString());         System.out.println(bucket.getDocCount());     }   }

需求二：按照颜色分组，计算每个颜色卖出的个数，每个颜色卖出的平均价格　

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

@Test public void testAggs2() throws IOException {     SearchRequest request = new SearchRequest("tvs");     SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();     searchSourceBuilder.size(0);     searchSourceBuilder.aggregation(             AggregationBuilders.terms("colors")                     .field("color")                     .subAggregation(AggregationBuilders.avg("avg_price").field("price")));     request.source(searchSourceBuilder);     SearchResponse search = client.search(request, RequestOptions.DEFAULT);     Aggregations aggregations = search.getAggregations();     Terms aggregation = aggregations.get("colors");     List<? extends Terms.Bucket> buckets = aggregation.getBuckets();     for (Terms.Bucket bucket : buckets) {         Aggregations bucketAggregations = bucket.getAggregations();         Avg avg_price = bucketAggregations.get("avg_price");         double value = avg_price.getValue();         System.out.println(bucket.getKeyAsString()+":"+value);     } }

需求三：按照颜色分组，计算每个颜色卖出的个数，以及每个颜色卖出的平均值、最大值、最小值、总和。　

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

SearchRequest request = new SearchRequest("tvs"); SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder(); searchSourceBuilder.size(0);   TermsAggregationBuilder colorAggregation = AggregationBuilders.terms("colors").field("color"); //放入多个子聚合 colorAggregation.subAggregation(AggregationBuilders.avg("avg_price").field("price")); colorAggregation.subAggregation(AggregationBuilders.min("min_price").field("price")); colorAggregation.subAggregation(AggregationBuilders.max("max_price").field("price")); colorAggregation.subAggregation(AggregationBuilders.sum("sum_price").field("price")); searchSourceBuilder.aggregation(colorAggregation);   request.source(searchSourceBuilder); SearchResponse search = client.search(request, RequestOptions.DEFAULT); Aggregations aggregations = search.getAggregations(); Terms aggregation = aggregations.get("colors"); List<? extends Terms.Bucket> buckets = aggregation.getBuckets(); for (Terms.Bucket bucket : buckets) {     Aggregations bucketAggregations = bucket.getAggregations();     Avg avg_price = bucketAggregations.get("avg_price");     double value = avg_price.getValue();     System.out.println(bucket.getKeyAsString()+"avg:"+value);     Min min_price = bucketAggregations.get("min_price");     double min_priceValue = min_price.getValue();     System.out.println(bucket.getKeyAsString()+"min:"+min_priceValue);   }

需求四：按照售价每2000价格划分范围，算出每个区间的销售总额 histogram

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

SearchRequest request = new SearchRequest("tvs"); SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder(); searchSourceBuilder.size(0); searchSourceBuilder.aggregation(         AggregationBuilders.histogram("price").field("price").interval(2000).                 subAggregation(AggregationBuilders.sum("income").field("price"))); request.source(searchSourceBuilder); SearchResponse response = client.search(request, RequestOptions.DEFAULT); Aggregations aggregations = response.getAggregations(); Histogram price = aggregations.get("price"); List<? extends Histogram.Bucket> buckets = price.getBuckets(); for (Histogram.Bucket bucket : buckets) {     Aggregations aggregations1 = bucket.getAggregations();     System.out.println("string:"+bucket.getKeyAsString());     System.out.println("count:"+bucket.getDocCount());     Sum income = aggregations1.get("income");     double value = income.getValue();     System.out.println("value:"+value); }