Site index · List index
Message view
Top
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/LanguageManual/UDF" by PierreHuyn
Date Mon, 30 Aug 2010 21:49:53 GMT
```Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The "Hive/LanguageManual/UDF" page has been changed by PierreHuyn.

--------------------------------------------------

||double ||var_samp(col) || Returns the unbiased sample variance of a numeric column in
the group ||
||double ||stddev_pop(col) || Returns the standard deviation of a numeric column in the
group ||
||double ||stddev_samp(col) || Returns the unbiased sample standard deviation of a numeric
column in the group ||
+ ||double ||covar_pop(col1, col2) || Returns the population covariance of a pair of numeric
columns in the group ||
+ ||double ||covar_samp(col1, col2) || Returns the sample covariance of a pair of a numeric
columns in the group ||
+ ||double ||corr(col1, col2) || Returns the Pearson coefficient of correlation of a pair
of a numeric columns in the group ||
||double ||percentile(col, p) || Returns the exact p^th^ percentile of an integer column
in the group (does not work with floating point types). p must be between 0 and 1. ||
||array<double> || percentile(col, array(p,,1,, [, p,,2,,]...)) || Returns the exact
percentiles p,,1,,, p,,2,,, ... of an integer column in the group (does not work with floating
point types). p,,i,, must be between 0 and 1.  ||
||double ||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. ||

```
Mime
View raw message