Module mz_expr::relation::func

source ·

Structs§

Enums§

Traits§

  • An implementation of an aggregation where we can send in the input elements one-by-one, and can also ask the current aggregate at any moment. (This just delegates to other aggregation evaluation approaches.)

Functions§

  • all 🔒
  • any 🔒
  • count 🔒
  • dense_rank 🔒
    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.
  • dict_agg 🔒
  • 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.
  • Computes a bundle of fused window aggregations. The input is similar to window_aggr, but InputValue is not just a single value, but a record where each component is the input to one of the aggregations.
  • Like fused_window_aggr, but doesn’t perform the final wrapping in a list, returning an Iterator instead.
  • jsonb_agg 🔒
  • jsonb_each 🔒
  • lag_lead 🔒
    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.
  • last_value 🔒
    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.
  • max_datum 🔒
  • max_string 🔒
  • min_datum 🔒
  • min_string 🔒
  • 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.
  • rank 🔒
    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.
  • row_number 🔒
    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.
  • string_agg 🔒
  • sum_datum 🔒
  • unnest_map 🔒
  • 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.
  • wrap 🔒