STD_DEV

‌The STD_DEV function returns the standard deviation of a set of numbers.
Syntax
stddev(VALUE)
Arguments
VALUE: An expression that evaluates to a numeric.
Returns
Returns a value of any built-in numeric data type.
Notes
In Athena output, STD_DEV data can be BIGINT or NUMBER type. 
In Upsolver output, STD_DEV data can be NUMBER type only.
Example
Data
1
[
2
   {
3
      "serverIp":"10.0.0.1",
4
      "time":1628894700000,
5
      "cpuUsage":52.3
6
   },
7
   {
8
      "serverIp":"10.0.0.1",
9
      "time":1628894760000,
10
      "cpuUsage":2.4
11
   },
12
   {
13
      "serverIp":"10.0.0.1",
14
      "time":1628894820000,
15
      "cpuUsage":99.3
16
   },
17
   {
18
      "serverIp":"10.0.0.1",
19
      "time":1628894880000,
20
      "cpuUsage":99.6
21
   },
22
   {
23
      "serverIp":"10.0.0.1",
24
      "time":1628894940000,
25
      "cpuUsage":12.3
26
   },
27
   {
28
      "serverIp":"10.0.0.1",
29
      "time":1628895000000,
30
      "cpuUsage":55
31
   },
32
   {
33
      "serverIp":"10.0.0.2",
34
      "time":1628894700000,
35
      "cpuUsage":2.3
36
   },
37
   {
38
      "serverIp":"10.0.0.2",
39
      "time":1628894760000
40
   },
41
   {
42
      "serverIp":"10.0.0.2",
43
      "time":1628894820000,
44
      "cpuUsage":9.3
45
   },
46
   {
47
      "serverIp":"10.0.0.2",
48
      "time":1628894880000,
49
      "cpuUsage":9.6
50
   },
51
   {
52
      "serverIp":"10.0.0.2",
53
      "time":1628894940000,
54
      "cpuUsage":2.3
55
   }
56
]
Copied!
Query
Find the standard deviation of cpu usage of each server:
1
SELECT
2
   data.serverIp AS serverip:STRING,
3
   STD_DEV(data.cpuUsage) AS std_dev_data_cpuusage:NUMBER 
4
FROM
5
   "TIME_SERIES_DATA_w_NULL" 
6
GROUP BY
7
   data.serverIp
Copied!
Results:
1
{
2
   "std_dev_data_cpuusage":4,
3
   "serverip":"10.0.0.2"
4
}{
5
   "std_dev_data_cpuusage":41,
6
   "serverip":"10.0.0.1"
7
}
Copied!
Related Functions
STD_DEV_EACH
Dialog

SESSION_COUNT

STD_DEV_EACH

Last modified 8mo ago

Copy link

Contents