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.