Upsolver
Search…
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!
STD_DEV_EACH

Dialog