hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/LanguageManual/UDF" by JohnSichi
Date Tue, 05 Apr 2011 00:03:56 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 JohnSichi.


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

View raw message