Upsolver
Search…
COUNT(*)
Counts the number of records that were aggregated. ‌

Syntax

COUNT(*) ‌

Arguments

none ‌

Returns

A number

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 1:

Count the number of entries for each serverip:
1
SET
2
Unix_Time = UNIX_EPOCH_TO_DATE(data.time);
3
SELECT
4
data.serverip AS serverip:STRING,
5
COUNT(*) AS "count":BIGINT
6
FROM
7
"TIME_SERIES_w_NULLs"
8
GROUP BY
9
data.serverip
Copied!

Results 1:

1
{
2
"count_data_serverip":5,
3
"serverip":"10.0.0.2"
4
}{
5
"count_data_serverip":6,
6
"serverip":"10.0.0.1"
7
}
Copied!

Query 2:

Count the number of entries for each time interval:
1
SET
2
Unix_Time = UNIX_EPOCH_TO_DATE(data.time);
3
SELECT
4
COUNT(data.serverip) AS count_data_serverip:BIGINT,
5
Unix_Time AS unix_time:TIMESTAMP
6
FROM
7
""TIME_SERIES_w_NULLs""
8
GROUP BY
9
Unix_Time
Copied!

Results 2:

1
{
2
"count":2,
3
"date_time":1628894820000
4
}{
5
"count":1,
6
"date_time":1628895000000
7
}{
8
"count":2,
9
"date_time":1628894880000
10
}{
11
"count":2,
12
"date_time":1628894760000
13
}{
14
"count":2,
15
"date_time":1628894700000
16
}{
17
"count":2,
18
"date_time":1628894940000
19
}
Copied!

Dialog

Last modified 8mo ago