Input Parameter Description
Name of the table on which the statistics operation will be performed, in [schema_name.]table_name format, using standard name resolution rules.
Comma separated list of the statistics to calculate, e.g. “sum,mean”.
- count: Number of objects (independent of the given column(s)).
- mean: Arithmetic mean (average), equivalent to sum/count.
- stdv: Sample standard deviation (denominator is count-1).
- variance: Unbiased sample variance (denominator is count-1).
- skew: Skewness (third standardized moment).
- kurtosis: Kurtosis (fourth standardized moment).
- sum: Sum of all values in the column(s).
- min: Minimum value of the column(s).
- max: Maximum value of the column(s).
- weighted_average: Weighted arithmetic mean (using the option weight_column_name as the weighting column).
- cardinality: Number of unique values in the column(s).
- estimated_cardinality: Estimate (via hyperloglog technique) of the number of unique values in the column(s).
- percentile: Estimate (via t-digest) of the given percentile of the column(s) (percentile(50.0) will be an approximation of the median). Add a second, comma-separated value to calculate percentile resolution, e.g., ‘percentile(75,150)’.
- percentile_rank: Estimate (via t-digest) of the percentile rank of the given value in the column(s) (if the given value is the median of the column(s), percentile_rank(<median>) will return approximately 50.0).