Aggregate Functions

function any_value($1) returns $1

function approx_count_distinct($1, ...) returns decimal(38, 0)

function approx_percentile(double, double) returns double

function approx_percentile_accumulate(double) returns object

function approx_percentile_combine(object) returns object

function approx_percentile_estimate(object, double) returns double

function approx_top_k($1) returns array
function approx_top_k($1, decimal(38, 0)) returns array
function approx_top_k($1, decimal(38, 0), decimal(38, 0)) returns array

function approx_top_k_accumulate($1, decimal(38, 0)) returns object

function approx_top_k_combine(object) returns object
function approx_top_k_combine(object, decimal(38, 0)) returns object

function approx_top_k_estimate(object) returns array
function approx_top_k_estimate(object, decimal(38, 0)) returns array

function approximate_jaccard_index(variant) returns double

function approximate_similarity(variant) returns double

function array_agg($1) returns array

function array_union_agg(array) returns array

function array_unique_agg($1) returns array

function avg(decimal(38, 0)) returns decimal(38, 0)
function avg(double) returns double
function avg(string) returns string

function bitand_agg(decimal(38, 0)) returns decimal(38, 0)
function bitand_agg(string) returns string

function bitmap_bit_position(decimal(38, 0)) returns decimal(38, 0)

function bitmap_bucket_number(decimal(38, 0)) returns decimal(38, 0)

function bitmap_construct_agg(decimal(38, 0)) returns binary

function bitmap_count(binary) returns decimal(38, 0)

function bitmap_or_agg(binary) returns binary

function bitor_agg(decimal(38, 0)) returns decimal(38, 0)
function bitor_agg(string) returns string

function bitxor_agg(decimal(38, 0)) returns decimal(38, 0)
function bitxor_agg(string) returns string

function booland_agg(decimal(38, 0)) returns boolean
function booland_agg(boolean) returns boolean

function boolor_agg(decimal(38, 0)) returns boolean
function boolor_agg(boolean) returns boolean

function boolxor_agg(decimal(38, 0)) returns boolean
function boolxor_agg(boolean) returns boolean

function corr(double, double) returns double

function count(...) returns decimal(38, 0)

function count_if(boolean) returns decimal(38, 0)

function covar_pop(double, double) returns double

function covar_samp(double, double) returns double

function grouping(...) returns int

function grouping_id($1, ...) returns decimal(38, 0)

function hash_agg(...) returns decimal(19, 0)
function hash_agg($1) returns decimal(38, 0)
function hash_agg($1, $2) returns decimal(38, 0)
function hash_agg($1, $2, $3) returns decimal(38, 0)
function hash_agg($1, $2, $3, $4) returns decimal(38, 0)
function hash_agg($1, $2, $3, $4, $5) returns decimal(38, 0)

function hll($1, ...) returns decimal(38, 0)

function hll_accumulate($1, ...) returns binary

function hll_combine(binary) returns binary

function hll_estimate(binary) returns decimal(38, 0)

function hll_export(binary) returns object

function hll_import(object) returns binary

function kurtosis(decimal(38, 0)) returns double
function kurtosis(double) returns double

function listagg(varchar) returns varchar
function listagg(varchar, varchar) returns varchar

function max($1) returns $1

function max_by($1, $2) returns $1
function max_by($1, $2, decimal(38, 0)) returns array

function median(decimal(p, s)) returns decimal(rp, rs)
function median(double) returns double

function min($1) returns $1

function min_by($1, $2) returns $1
function min_by($1, $2, decimal(38, 0)) returns array

function minhash(decimal(38, 0), $1, ...) returns variant

function minhash_combine(variant) returns variant

function mode($1) returns $1

function object_agg(varchar, variant) returns object

function percentile_cont(decimal(p,s), $1) returns $1

function percentile_disc(decimal(p,s), $1) returns $1

function regr_avgx(double, double) returns double

function regr_avgy(double, double) returns double

function regr_count(double, double) returns double

function regr_intercept(double, double) returns double

function regr_r2(double, double) returns double

function regr_slope(double, double) returns double

function regr_sxx(double, double) returns double

function regr_sxy(double, double) returns double

function regr_syy(double, double) returns double

function skew(decimal(38, 0)) returns double
function skew(double) returns double

function stddev(decimal(38, 0)) returns double
function stddev(double) returns double

function stddev_pop(decimal(38, 0)) returns double
function stddev_pop(double) returns double

function stddev_samp(decimal(38, 0)) returns double
function stddev_samp(double) returns double

function sum(decimal(p, s)) returns decimal(rp, s)
function sum(double) returns double

function var_pop(decimal(38, 0)) returns double
function var_pop(double) returns double

function var_samp(decimal(38, 0)) returns double
function var_samp(double) returns double

function variance(decimal(38, 0)) returns double
function variance(double) returns double

function variance_pop(decimal(38, 0)) returns double
function variance_pop(double) returns double

function variance_samp(decimal(38, 0)) returns double
function variance_samp(double) returns double