返回类型 |
函数 |
说明 |
bigint |
count(*),count(expr),count(DISTINCT expr[,expr_.,expr_.]) |
返回记录条数。 |
double |
sum(col),sum(DISTINCT col) |
求和 |
double |
avg(col),avg(DISTINCT col) |
求平均值 |
double |
min(col) |
返回指定列中最小值 |
double |
max(col) |
返回指定列中最大值 |
double |
var_pop(col) |
返回指定列的方差 |
double |
var_samp(col) |
返回指定列的样本方差 |
double |
stddev_pop(col) |
返回指定列的偏差 |
double |
stddev_samp(col) |
返回指定列的样本偏差 |
double |
covar_pop(col1,col2) |
两列数值协方差 |
double |
covar_samp(col1,col2) |
两列数值样本协方差 |
double |
corr(col1,col2) |
返回两列数值的相关系数 |
double |
percentile(col,p) |
返回数值区域的百分比数值点。0<=P<=1,否则返回NULL,不支持浮点型数值。 |
array<double> |
percentile(col,array(p~1,\ [,p,2,]…)) |
返回数值区域的一组百分比值分别对应的数值点。0<=P<=1,不支持浮点型数值。 |
double |
percentile_approx(col,p[,B]) |
Returns an approximate p^th^ percentile of anumeric column (including floating point types) in the group. The B parametercontrols approximation accuracy at the cost of memory. Higher values yieldbetter approximations,and the default is 10,000. When the number of distinctvalues in col is smaller than B,this gives an exact percentile value. |
array<double> |
percentile_approx(col,[,2_]…)[,B]) |
Same as above,but accepts and returns an arrayof percentile values instead of a single one. |
array<struct\{‘x’,'y’\}> |
histogram_numeric(col,b) |
Computes a histogram of a numeric column in thegroup using b non-uniformly spaced bins. The output is an array of size b ofdouble-valued (x,y) coordinates that represent the bin centers and heights |
array |
collect_set(col) |
返回无重复记录 |
|
