| # Aggregate Functions Support Status |
| |
| **Out of 62 aggregate functions in Spark 3.5, Gluten currently fully supports 52 functions and partially supports 1 function.** |
| |
| ## Aggregate Functions |
| |
| | Spark Functions | Spark Expressions | Status | Restrictions | |
| |-----------------------|------------------------------------|----------|----------------| |
| | any | BoolOr | S | | |
| | any_value | AnyValue | S | | |
| | approx_count_distinct | HyperLogLogPlusPlus | S | | |
| | approx_percentile | ApproximatePercentile | | | |
| | array_agg | CollectList | S | | |
| | avg | Average | S | | |
| | bit_and | BitAndAgg | S | | |
| | bit_or | BitOrAgg | S | | |
| | bit_xor | BitXorAgg | S | | |
| | bitmap_construct_agg | BitmapConstructAgg | | | |
| | bitmap_or_agg | BitmapOrAgg | | | |
| | bool_and | BoolAnd | S | | |
| | bool_or | BoolOr | S | | |
| | collect_list | CollectList | S | | |
| | collect_set | CollectSet | S | | |
| | corr | Corr | S | | |
| | count | Count | S | | |
| | count_if | CountIf | S | | |
| | count_min_sketch | CountMinSketchAggExpressionBuilder | | | |
| | covar_pop | CovPopulation | S | | |
| | covar_samp | CovSample | S | | |
| | every | BoolAnd | S | | |
| | first | First | S | | |
| | first_value | First | S | | |
| | grouping | Grouping | S | | |
| | grouping_id | GroupingID | S | | |
| | histogram_numeric | HistogramNumeric | | | |
| | hll_sketch_agg | HllSketchAgg | | | |
| | hll_union_agg | HllUnionAgg | | | |
| | kurtosis | Kurtosis | S | | |
| | last | Last | S | | |
| | last_value | Last | S | | |
| | max | Max | S | | |
| | max_by | MaxBy | S | | |
| | mean | Average | S | | |
| | median | Median | S | | |
| | min | Min | S | | |
| | min_by | MinBy | S | | |
| | mode | Mode | | | |
| | percentile | Percentile | | | |
| | percentile_approx | ApproximatePercentile | | | |
| | regr_avgx | RegrAvgX | S | | |
| | regr_avgy | RegrAvgY | S | | |
| | regr_count | RegrCount | S | | |
| | regr_intercept | RegrIntercept | S | | |
| | regr_r2 | RegrR2 | S | | |
| | regr_slope | RegrSlope | S | | |
| | regr_sxx | RegrSXX | S | | |
| | regr_sxy | RegrSXY | S | | |
| | regr_syy | RegrSYY | S | | |
| | skewness | Skewness | S | | |
| | some | BoolOr | S | | |
| | std | StddevSamp | S | | |
| | stddev | StddevSamp | S | | |
| | stddev_pop | StddevPop | S | | |
| | stddev_samp | StddevSamp | S | | |
| | sum | Sum | S | | |
| | try_avg | TryAverageExpressionBuilder | S | | |
| | try_sum | TrySumExpressionBuilder | PS | | |
| | var_pop | VariancePop | S | | |
| | var_samp | VarianceSamp | S | | |
| | variance | VarianceSamp | S | | |
| |
