🎁Using Sail? Tell us your story and get free merch!

This is an unreleased version of Sail. Please visit here for the documentation of the latest stable version.

Built-in Spark Aggregate Functions

Function	Supported
`any`	✅
`any_value`	✅
`approx_count_distinct`	✅
`approx_percentile`	✅
`array_agg`	✅
`avg`	✅
`bit_and`	✅
`bit_or`	✅
`bit_xor`	✅
`bool_and`	✅
`bool_or`	✅
`collect_list`	✅
`collect_set`	✅
`corr`	✅
`count`	✅
`count_if`	✅
`covar_pop`	✅
`covar_samp`	✅
`every`	✅
`first`	✅
`first_value`	✅
`grouping`	✅
`kurtosis`	✅
`last`	✅
`last_value`	✅
`listagg`	✅
`max`	✅
`max_by`	✅
`mean`	✅
`median`	✅
`min`	✅
`min_by`	✅
`mode`	✅
`percentile_approx`	✅
`regr_avgx`	✅
`regr_avgy`	✅
`regr_count`	✅
`regr_intercept`	✅
`regr_r2`	✅
`regr_slope`	✅
`regr_sxx`	✅
`regr_sxy`	✅
`regr_syy`	✅
`skewness`	✅
`some`	✅
`std`	✅
`stddev`	✅
`stddev_pop`	✅
`stddev_samp`	✅
`string_agg`	✅
`sum`	✅
`var_pop`	✅
`var_samp`	✅
`variance`	✅
`bitmap_construct_agg`	🚧
`bitmap_or_agg`	🚧
`count_min_sketch`	🚧
`grouping_id`	🚧
`histogram_numeric`	🚧
`hll_sketch_agg`	🚧
`hll_union_agg`	🚧
`percentile`	🚧
`percentile_cont`	🚧
`percentile_disc`	🚧
`try_avg`	🚧
`try_sum`	🚧