Related to "selectors"

bottom() function

The bottom() function sorts a table by columns and keeps only the bottom n records.

distinct() function

The distinct() function returns the unique values for a given column.

first() function

The first() function selects the first non-null record from an input table.

highestAverage() function

The highestAverage() function calculates the average of each table in the input stream returns the top n records.

highestCurrent() function

The highestCurrent() function selects the last record of each table in the input stream and returns the top n records.

highestMax() function

The highestMax() function selects the maximum record from each table in the input stream and returns the top n records.

last() function

The last() function selects the last non-null record from an input table.

limit() function

The limit() function limits each output table to the first n records.

lowestAverage() function

The lowestAverage() function calculates the average of each table in the input stream returns the lowest n records.

lowestCurrent() function

The lowestCurrent() function selects the last record of each table in the input stream and returns the lowest n records.

lowestMin() function

The lowestMin() function selects the minimum record from each table in the input stream and returns the lowest n records.

max() function

The max() function selects record with the highest _value from the input table.

median() function

The median() function returns the median _value of an input table or all non-null records in the input table with values that fall within the 0.5 quantile or 50th percentile.

min() function

The min() function selects record with the lowest _value from the input table.

quantile() function

The quantile() function outputs non-null records with values that fall within the specified quantile or the non-null record with the value that represents the specified quantile.

sample() function

The sample() function selects a subset of the records from the input table.

top() function

The top() function sorts a table by columns and keeps only the top n records.

unique() function

The unique() function returns all records containing unique values in a specified column.

experimental.distinct() function

The experimental.distinct() function returns unique values from the _value column.

experimental.first() function

The experimental.first() function returns the first record with a non-null value in the _value column.

experimental.last() function

The experimental.last() function returns the last record with a non-null value in the _value column.

experimental.max() function

The experimental.max() function returns the record with the highest value in the _value column for each input table.

experimental.min() function

The experimental.min() function returns the record with the lowest value in the _value column for each input table.

experimental.quantile() function

The experimental.quantile() function outputs non-null records with values in the _value column that fall within the specified quantile or the non-null record with the value in the _value column that represents the specified quantile.

experimental.unique() function

The experimental.unique() function returns all records containing unique values in the _value column.