Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by NamitJain: http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF ------------------------------------------------------------------------------ ||<10%>'''Return Type'''||<15%>'''Name(Signature)'''||'''Description|| ||BIGINT ||round(double a) ||returns the rounded BIGINT value of the double|| ||BIGINT ||floor(double a) ||returns the maximum BIGINT value that is equal or less than the double|| - ||BIGINT ||ceil(double a) ||returns the minimum BIGINT value that is equal or greater 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). Specifiying the seed will make sure the generated random number sequence is deterministic.|| ||double ||exp(double a) ||Return e^a where e is the base of the natural logarithm|| ||double ||ln(double a) ||Return the natural logarithm of the argument|| @@ -118, +118 @@ ||string ||rtrim(string A) ||returns the string resulting from trimming spaces from the end(right hand side) of A e.g. rtrim(' foobar ') results in ' foobar'|| ||string ||regexp_replace(string A, string B, string C) ||returns the string resulting from replacing all substrings in B that match the Java regular expression syntax(See Java regular expressions syntax) with C e.g. regexp_replace('foobar', 'oo|ar', '') returns 'fb'|| ||string ||regexp_extract(string subject, string pattern, int intex) ||returns the string extracted using the pattern. e.g. regexp_extract('foothebar', 'foo(.*?)(bar)', 2) returns 'bar'|| + ||string ||parse_url(string urlString, string partToExtract) ||returns the part from the url. e.g. parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'HOST') returns 'facebook.com'|| ||string ||get_json_object(string json_string, string path) ||Extract json object from a json string based on json path specified, and return json string of the extracted json object. It will return null if the input json string is invalid|| ==== get_json_object ====
