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 NamitJain
Date Fri, 17 Jul 2009 02:12:03 GMT
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 ====

Mime
View raw message