ElasticSearch6.x 之聚合

java哥 阅读:589 2021-03-31 17:03:36 评论:0

自定义索引my_index,并初始化相关数据

# 创建my_index索引 
put my_index 
#  索引数据初始化 
http://192.168.1.74:9200/my_index/person/2/ 
{ 
  "name":"小周", 
  "age":28, 
  "salary":10000 
} 
http://192.168.1.74:9200/my_index/person/2/ 
{ 
  "name":"小智", 
  "age":18, 
  "salary":5000 
} 

聚合之max

POST 请求:http://192.168.1.74:9200/my_index/_search/ 
{ 
  "size": 0,  
  "aggs": { 
    "max_age": { 
      "max": {"field": "age"} 
    } 
  } 
} 

聚合之min

POST 请求:http://192.168.1.74:9200/my_index/_search/ 
{ 
  "size": 0,  
  "aggs": { 
    "min_age": { 
      "min": {"field": "age"} 
    } 
  } 
}

聚合之avg

 
POST 请求:http://192.168.1.74:9200/my_index/_search/ 
{ 
  "size": 0,  
  "aggs": { 
    "avg_age": { 
      "avg": {"field": "age"} 
    } 
  } 
}

聚合之sum

POST 请求:http://192.168.1.74:9200/my_index/_search/ 
{ 
  "size": 0,  
  "aggs": { 
    "sum_age": { 
      "sum": {"field": "age"} 
    } 
  } 
}

聚合之stats

POST 请求:http://192.168.1.74:9200/my_index/_search/ 
{ 
  "size": 0,  
  "aggs": { 
    "stats_age": { 
      "stats": {"field": "age"} 
    } 
  } 
}

聚合高级统计(stats功能拓展)

POST 请求:http://192.168.1.74:9200/my_index/_search/ 
{ 
  "size": 0,  
  "aggs": { 
    "stats_age": { 
      "extended_stats": {"field": "age"} 
    } 
  } 
}

聚合之文档数量统计

POST 请求:http://192.168.1.74:9200/my_index/_search/ 
{ 
  "size": 0,  
  "aggs": { 
    "doc_count": { 
      "value_count": {"field": "age"} 
    } 
  } 
}

聚合之百分比统计

POST 请求:http://192.168.1.74:9200/my_index/_search/ 
{ 
  "size": 0,  
  "aggs": { 
    "persion_salary": { 
      "percentiles": {"field": "salary"} 
    } 
  } 
}

 

声明

1.本站遵循行业规范,任何转载的稿件都会明确标注作者和来源;2.本站的原创文章,请转载时务必注明文章作者和来源,不尊重原创的行为我们将追究责任;3.作者投稿可能会经我们编辑修改或补充。

关注我们

一个IT知识分享的公众号