ES extended_stats 函数

57 阅读 0 评论 38 点赞

我是靠谱客的博主烂漫灯泡，这篇文章主要介绍ES extended_stats 函数，现在分享给大家，希望可以做个参考。

在进行ES聚合分析的时候，发现了一个非常有用的函数,extended_stats，可以对聚合的结果进行更近一步的分析，常见的 count sum avg min max 等都可以一目了然

GET cars/transactions/_search
{
"size": 0,
"aggs": {
"makes": {
"terms": {
"field": "make",
"size": 10
},
"aggs": {
"stats": {
"extended_stats": {
"field": "price"
}
}
}
}
}
}

结果如下

 1 {
 2 
"took": 87,
 3 
"timed_out": false,
 4 
"_shards": {
 5 
"total": 5,
 6 
"successful": 5,
 7 
"failed": 0
 8 
},
 9 
"hits": {
10 
"total": 8,
11 
"max_score": 0,
12 
"hits": []
13 
},
14 
"aggregations": {
15 
"makes": {
16 
"doc_count_error_upper_bound": 0,
17 
"sum_other_doc_count": 0,
18 
"buckets": [
19 
{
20 
"key": "honda",
21 
"doc_count": 3,
22 
"stats": {
23 
"count": 3,
24 
"min": 10000,
25 
"max": 20000,
26 
"avg": 16666.666666666668,
27 
"sum": 50000,
28 
"sum_of_squares": 900000000,
29 
"variance": 22222222.22222221,
30 
"std_deviation": 4714.045207910315,
31 
"std_deviation_bounds": {
32 
"upper": 26094.757082487296,
33 
"lower": 7238.5762508460375
34 
}
35 
}
36 
},
37 
{
38 
"key": "ford",
39 
"doc_count": 2,
40 
"stats": {
41 
"count": 2,
42 
"min": 25000,
43 
"max": 30000,
44 
"avg": 27500,
45 
"sum": 55000,
46 
"sum_of_squares": 1525000000,
47 
"variance": 6250000,
48 
"std_deviation": 2500,
49 
"std_deviation_bounds": {
50 
"upper": 32500,
51 
"lower": 22500
52 
}
53 
}
54 
},
55 
{
56 
"key": "toyota",
57 
"doc_count": 2,
58 
"stats": {
59 
"count": 2,
60 
"min": 12000,
61 
"max": 15000,
62 
"avg": 13500,
63 
"sum": 27000,
64 
"sum_of_squares": 369000000,
65 
"variance": 2250000,
66 
"std_deviation": 1500,
67 
"std_deviation_bounds": {
68 
"upper": 16500,
69 
"lower": 10500
70 
}
71 
}
72 
},
73 
{
74 
"key": "bmw",
75 
"doc_count": 1,
76 
"stats": {
77 
"count": 1,
78 
"min": 80000,
79 
"max": 80000,
80 
"avg": 80000,
81 
"sum": 80000,
82 
"sum_of_squares": 6400000000,
83 
"variance": 0,
84 
"std_deviation": 0,
85 
"std_deviation_bounds": {
86 
"upper": 80000,
87 
"lower": 80000
88 
}
89 
}
90 
}
91 
]
92 
}
93 
}
94 }