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