The expected input is in the format of [((OriginalRow, [EncodedArgs]), OrderByExprs...)]
The output is in the format of [result_value, original_row]
.
See an example at lag_lead
, where the input-output formats are similar.
Like dense_rank
, but doesn’t perform the final wrapping in a list, returning an Iterator
instead.
The expected input is in the format of [((OriginalRow, InputValue), OrderByExprs…)]
Like first_value
, but doesn’t perform the final wrapping in a list, returning an Iterator
instead.
Executes FusedValueWindowFunc
on a reduction group.
The expected input is in the format of [((OriginalRow, (Args1, Args2, ...)), OrderByExprs...)]
where Args1
, Args2
, are the arguments of each of the fused functions. For functions that
have only a single argument (first_value/last_value), these are simple values. For functions
that have multiple arguments (lag/lead), these are also records.
Like fused_value_window_func
, but doesn’t perform the final wrapping in a list, returning an
Iterator instead.
The expected input is in the format of [((OriginalRow, EncodedArgs), OrderByExprs...)]
For example,
Each element of args
has the 3 arguments evaluated for a single input row.
Returns the results for each input row.
Like lag_lead
, but doesn’t perform the final wrapping in a list, returning an Iterator
instead.
The expected input is in the format of [((OriginalRow, InputValue), OrderByExprs…)]
Like last_value
, but doesn’t perform the final wrapping in a list, returning an Iterator
instead.
Assuming datums is a List, sort them by the 2nd through Nth elements
corresponding to order_by, then return the 1st element.
Assuming datums is a List, sort them by the 2nd through Nth elements
corresponding to order_by, then return the 1st element and computed order by expression.
The expected input is in the format of [((OriginalRow, [EncodedArgs]), OrderByExprs...)]
The output is in the format of [result_value, original_row]
.
See an example at lag_lead
, where the input-output formats are similar.
Like rank
, but doesn’t perform the final wrapping in a list, returning an Iterator
instead.
The expected input is in the format of [((OriginalRow, [EncodedArgs]), OrderByExprs...)]
The output is in the format of [result_value, original_row]
.
See an example at lag_lead
, where the input-output formats are similar.
Like row_number
, but doesn’t perform the final wrapping in a list, returning an Iterator
instead.
lag/lead’s arguments are in a record. This function unwraps this record.
input_datums
is an entire window partition.
The expected input is in the format of [((OriginalRow, InputValue), OrderByExprs...)]
See also in the comment in window_func_applied_to
.
Like window_aggr
, but doesn’t perform the final wrapping in a list, returning an Iterator
instead.