Uses of Package
dev.frostlake.functions.aggregate

Package
Description
 
  • Class
    Description
    An accumulator whose result depends on whether its argument is APPROXIMATE, which the values alone cannot always say.
    The three boolean aggregates' shared argument rule.
    An accumulator whose numeric answer can be asked of a VARCHAR or VARIANT argument.
    An accumulator that reads its constant arguments from the call's TEXT rather than from the rows — the APPROX_TOP_K family's item and counter limits, which must be known even when no row arrives: an empty group still reports the capacity it was configured with.
    An accumulator that needs the aggregated expression's DECLARED type, which its values cannot give — a NUMBER(10,2) column and a literal 1.5 both arrive as a BigDecimal, and only the declaration says which width the APPROX_TOP_K_ACCUMULATE state must report.
    The percentile digest behind APPROX_PERCENTILE_ACCUMULATE, _COMBINE and _ESTIMATE: a list of centroids (mean, weight) serialised as {"state":[mean, weight, mean, weight, …], "type":"tdigest","version":1}, means ascending, every number in the fifteen-decimal exponent form a DOUBLE takes inside a VARIANT.
    Which member of the REGR_* linear-regression family a RegrAccumulator computes from its sums.
    The count, the sum and the sum of squares of a FLOAT series — the moments the account's variance family reads over FLOATs.
    One counter of a TopKSummary: a value, how many times the summary has counted it, and the tick of the summary's clock at which it was last touched — the tie-breaker every ordering rule of the APPROX_TOP_K family reads.
    Which element-wise reduction a VectorAggregateAccumulator applies across the group's rows.
    The running count, mean and sum of squared deviations of a double series — Welford's update, merged with Chan's formula — which the variance family uses over EXACT inputs.