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