Version: Next

count

count — count input values

count() -> uint64

The count aggregate function computes the number of values in its input.

Count of values in a simple sequence:

echo '1 2 3' | super -z -c 'count()' -

3(uint64)

Continuous count of simple sequence:

echo '1 2 3' | super -z -c 'yield count()' -

1(uint64)
2(uint64)
3(uint64)

Mixed types are handled:

echo '1 "foo" 10.0.0.1' | super -z -c 'yield count()' -

1(uint64)
2(uint64)
3(uint64)

Count of values in buckets grouped by key:

echo '{a:1,k:1} {a:2,k:1} {a:3,k:2}' | super -z -c 'count() by k |> sort' -

{k:1,count:2(uint64)}
{k:2,count:1(uint64)}

A simple count with no input values returns no output:

echo '1 "foo" 10.0.0.1' | super -z -c 'where grep("bar") |> count()' -

Count can return an explicit zero when using a where clause in the aggregation:

echo '1 "foo" 10.0.0.1' | super -z -c 'count() where grep("bar")' -

0(uint64)

Note that the number of input values are counted, unlike the len function which counts the number of elements in a given value:

echo '[1,2,3]' | super -z -c 'count()' -

1(uint64)