You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2010/08/30 23:49:53 UTC

[Hadoop Wiki] Update of "Hive/LanguageManual/UDF" by PierreHuyn

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.
http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF?action=diff&rev1=50&rev2=51

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

  ||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. ||