??
返回类型
?? |
|
|
|
count(*),count(expr),count(DISTINCT expr[,??expr_.,expr_.])
|
|
|
sum(col),sum(DISTINCT col)
|
|
avg(col),avg(DISTINCT col)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
covar_samp(col1,245); overflow:hidden">
|
corr(col1,245); overflow:hidden">
|
|
返回数值区域的百分比数值点。0<=P<=1,否则返回NULL,不支持浮点型数值。
|
|
返回数值区域的一组百分比值分别对应的数值点。0<=P<=1,245); overflow:hidden">
percentile_approx(col,p[,B])
|
Returns an approximate p^th^ percentile of a??numeric column (including floating point types) in the group. The B parameter??controls approximation accuracy at the cost of memory. Higher values yield??better approximations,and the default is 10,000. When the number of distinct??values in col is smaller than B,this gives an exact percentile value.
|
Same as above,but accepts and returns an array??of percentile values instead of a single one.
|
|
|
Computes a histogram of a numeric column in the??group using b non-uniformly spaced bins. The output is an array of size b of??double-valued (x,y) coordinates that represent the bin centers and heights
|
|
|
|
|
更多精彩内容请关注:http://bbs.superwu.cn
关注超人学院微信二维码:
关注超人学院java免费学习交流群:
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|