experimental.count() function

experimental.count() returns the number of records in each input table.

The count is returned in the _value column and counts both null and non-null records.

Counts on empty tables

experimental.count() returns 0 for empty tables. To keep empty tables in your data, set the following parameters when using the following functions:

filter(onEmpty: "keep")
window(createEmpty: true)
aggregateWindow(createEmpty: true)

Function type signature

(<-tables: stream[{A with _value: B}]) => stream[{A with _value: int}]

Parameters

tables

Input data. Default is piped-forward data (<-).

Examples

Count the number of rows in a table

import "experimental"
import "sampledata"

sampledata.int()
    |> experimental.count()