ElasticSearch 2.3.3 java API操作二

lcz393537415發表於2016-06-24
ElasticsearchJavaAPI

點選(此處)摺疊或開啟

  1. import org.elasticsearch.action.search.SearchResponse;
  2. import org.elasticsearch.client.transport.TransportClient;
  3. import org.elasticsearch.index.query.QueryBuilders;
  4. import org.elasticsearch.search.aggregations.AggregationBuilders;
  5. import org.elasticsearch.search.aggregations.bucket.filters.Filters;
  6. import org.elasticsearch.search.aggregations.bucket.histogram.Histogram;
  7. import org.elasticsearch.search.aggregations.metrics.stats.Stats;
  8. import org.elasticsearch.search.aggregations.metrics.sum.Sum;

  10. import com.sany.util.ESUtil;

  12. public class EsAggregationTest {
  13.     /**
  14.      * histogram
  15.      * 統計每隔interval區間的數值
  16.      * 下面的返回結果 表示的含義 [10000~20000)的記錄有3條，這三條記錄的price總和
  17.      * 10000    3    37000.0
  18.         20000    3    65000.0
  19.         30000    1    30000.0
  20.         40000    0    0.0
  21.         50000    0    0.0
  22.         60000    0    0.0
  23.         70000    0    0.0
  24.         80000    1    80000.0

  26.      */
  27.        public static void verticleBarAggs(String index,String type){
  28.          TransportClient client=ESUtil.getClient();
  29.          SearchResponse searchResponse = client.prepareSearch(index).setTypes(type).
  30.          addAggregation(AggregationBuilders.histogram("price_verticle").field("price").interval(10000)
  31.                   .subAggregation(AggregationBuilders.sum("sumprice").field("price"))).get();
  32.          Histogram hist = searchResponse.getAggregations().get("price_verticle");
  33.          for (Histogram.Bucket bucket : hist.getBuckets()) {
  34.               Sum s=bucket.getAggregations().get("sumprice");
  35.                  System.out.println(bucket.getKey()+"\t"+bucket.getDocCount()+"\t"+s.getValue());
  36.             }
  37.          client.close();
  38.        }
  39.        
  40.       /**
  41.        * filter aggregation
  42.        * 根據過濾條件生成bucket, 統計bucket中資料總數,返回值
  43.        * 0    4 顏色為紅色的有4個，blue的有2個
  44.          1    2
  45.        */
  46.        public static void filterAggregation(){
  47.          TransportClient client = ESUtil.getClient();
  48.          SearchResponse searchResponse = client.prepareSearch("cars").setTypes("transactions").addAggregation(
  49.                   AggregationBuilders.filters("colorfilter")
  50.                   .filter(QueryBuilders.termQuery("color", "red"))
  51.                   .filter(QueryBuilders.termQuery("color", "blue"))).get();
  52.          Filters ff=searchResponse.getAggregations().get("colorfilter");
  53.          for (Filters.Bucket bucket : ff.getBuckets()) {
  54.                  // System.out.println(bucket.getKey()+"\t"+bucket.getDocCount());
  55.               System.out.println(bucket.getKeyAsString()+"\t"+bucket.getDocCount());
  56.             }
  57.        }
  58.        
  59.        /**
  60.         * stat，根據單一統計的一個最大，最小，平均值，總和
  61.         */
  62.        public static void statAggregation(){
  63.          TransportClient client = ESUtil.getClient();
  64.          SearchResponse searchResponse = client.prepareSearch("cars").setTypes("transactions").addAggregation(AggregationBuilders.stats("price_stat").field("price")).get();
  65.          Stats sta= searchResponse.getAggregations().get("price_stat");
  66.          System.out.println("max value="+sta.getMax());
  67.          System.out.println("min value="+sta.getMin());
  68.          System.out.println("avg value="+sta.getAvg());
  69.          System.out.println("sum value="+sta.getSum());
  70.          client.close();
  71.        }
  72.        
  73.        public static void main(String[] args) {
  74.          EsAggregationTest.filterAggregation();
  75.      }
  76. }

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/31347383/viewspace-2120936/，如需轉載，請註明出處，否則將追究法律責任。

相關文章