ElasticSearch 6.x 学习笔记：21.指标聚合

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-metrics.html

为了方便聚合统计，增加两条文档

PUT my-index/persion/5
{
  "name":"程裕强",
  "age":28,
  "salary":10000
}
PUT my-index/persion/6
{
  "name":"hadron",
  "age":19,
  "salary":5000
}
 
 
1
2
3
4
5
6
7
8
9
10
11
12

21.1 max

GET my-index/_search
{
  "size": 0, 
  "aggs": {
    "max_age": {
      "max": {"field": "age"}
    }
  }
}
 
 
1
2
3
4
5
6
7
8
9

{
  "took": 4,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 6,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "max_age": {
      "value": 28 }
  }
}
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

21.2 min

GET my-index/_search
{
  "size": 0, 
  "aggs": {
    "min_age": {
      "min": {"field": "age"}
    }
  }
}
 
 
1
2
3
4
5
6
7
8
9

{
  "took": 5,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 6,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "min_age": {
      "value": 19 }
  }
}
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

21.3 avg

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-metrics-avg-aggregation.html

GET my-index/_search
{
  "size": 0, 
  "aggs": {
    "avg_salary": {
      "avg": {"field": "salary"}
    }
  }
}
 
 
1
2
3
4
5
6
7
8
9

{
  "took": 7,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 6,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "avg_salary": {
      "value": 7166.666666666667 }
  }
}
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

21.4sum

GET my-index/_search
{
  "size": 0, 
  "aggs": {
    "sum_salary": {
      "sum": {"field": "salary"}
    }
  }
}
 
 
1
2
3
4
5
6
7
8
9

{
  "took": 5,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 6,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "sum_salary": {
      "value": 43000 }
  }
}
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

21.5 stats

GET my-index/_search
{
  "size": 0, 
  "aggs": {
    "stats_salary": {
      "stats": {"field": "salary"}
    }
  }
}
 
 
1
2
3
4
5
6
7
8
9

{
  "took": 5,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 6,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "stats_salary": {
      "count": 6,
      "min": 5000,
      "max": 10000,
      "avg": 7166.666666666667,
      "sum": 43000 }
  }
}
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

21.6 高级统计

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-metrics-extendedstats-aggregation.html

GET my-index/_search
{
  "size": 0, 
  "aggs": {
    "stats_salary": {
      "extended_stats": {"field": "salary"}
    }
  }
}
 
 
1
2
3
4
5
6
7
8
9

{
  "took": 4,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 6,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "stats_salary": {
      "count": 6,
      "min": 5000,
      "max": 10000,
      "avg": 7166.666666666667,
      "sum": 43000,
      "sum_of_squares": 325000000,
      "variance": 2805555.5555555522,
      "std_deviation": 1674.9792701868141,
      "std_deviation_bounds": { "upper": 10516.625207040295, "lower": 3816.7081262930387 } }
  }
}
 
 
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
28
29
30
31

21.7 基数统计

https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-metrics-cardinality-aggregation.html
工资基数（等级）

GET my-index/_search
{
  "size": 0, 
  "aggs": {
    "class_salary": {
      "cardinality": {"field": "salary"}
    }
  }
}
 
 
1
2
3
4
5
6
7
8
9

{
  "took": 44,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 6,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "class_salary": {
      "value": 4 }
  }
}
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

21.8 文档数量统计

为了方便统计包含某一字段（比如salary）的文档数，这里添加一个不含该字段的文档

PUT my-index/persion/7
{
  "name":"test",
  "age":26
}
 
 
1
2
3
4
5

GET my-index/_search
{
  "size": 0, 
  "aggs": {
    "doc_count": {
      "value_count": {"field": "salary"}
    }
  }
}
 
 
1
2
3
4
5
6
7
8
9

{
  "took": 10,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 7,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "doc_count": {
      "value": 6 }
  }
}
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

21.9 百分位统计

GET my-index/_search
{
  "size": 0, 
  "aggs": {
    "persion_salary": {
      "percentiles": {"field": "salary"}
    }
  }
}
 
 
1
2
3
4
5
6
7
8
9

{ 

  "took": 19, 

  "timed_out": false, 

  "_shards": { 

    "total": 5, 

    "successful": 5, 

    "skipped": 0, 

    "failed": 0 

  }, 

  "hits": { 

    "total": 7, 

    "max_score": 0, 

    "hits": [] 

  }, 

  "aggregations": { 

    "persion_salary": { 

      "values": { "1.0": 5050, "5.0": 5250, "25.0": 6000, "50.0": 7000, "75.0": 8000, "95.0": 9500, "99.0": 9900 } } 

  } 

}
 
 
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
28