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 2011/04/05 02:03:56 UTC

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

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

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

  The following built-in mathematical functions are supported in hive; most return NULL when the argument(s) are NULL:
  ||<10%>'''Return Type''' ||<15%>'''Name(Signature)''' ||'''Description''' ||
  ||BIGINT ||round(double a) ||Returns the rounded BIGINT value of the double ||
+ ||DOUBLE ||round(double a, int d) ||Returns the double rounded to d decimal places||
  ||BIGINT ||floor(double a) ||Returns the maximum BIGINT value that is equal or less than the double ||
  ||BIGINT ||ceil(double a), ceiling(double a) ||Returns the minimum BIGINT value that is equal or greater than the double ||
  ||double ||rand(), rand(int seed) ||Returns a random number (that changes from row to row) that is distributed uniformly from 0 to 1. Specifiying the seed will make sure the generated random number sequence is deterministic. ||