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 DaveBrondsema
Date Tue, 23 Nov 2010 17:00:26 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 DaveBrondsema.
http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF?action=diff&rev1=56&rev2=57

--------------------------------------------------

  ||string ||reverse(string A) ||Returns the reversed string ||
  ||string ||concat(string A, string B...) ||Returns the string resulting from concatenating
the strings passed in as parameters in order. e.g. concat('foo', 'bar') results in 'foobar'.
Note that this function can take any number of input strings. ||
  ||string ||concat_ws(string SEP, string A, string B...) || Like concat() above, but with
custom separator SEP. ||
- ||string ||substr(string A, int start) substring(string A, int start) ||Returns the substring
of A starting from start position till the end of string A e.g. concat('foobar', 4) results
in 'bar' (see [[[http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substr]]])
||
+ ||string ||substr(string A, int start) substring(string A, int start) ||Returns the substring
of A starting from start position till the end of string A e.g. substr('foobar', 4) results
in 'bar' (see [[[http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substr]]])
||
- ||string ||substr(string A, int start, int len) substring(string A, int start, int len)
||Returns the substring of A starting from start position with length len e.g. concat('foobar',
4, 1) results in 'b' (see [[[http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substr]]])
||
+ ||string ||substr(string A, int start, int len) substring(string A, int start, int len)
||Returns the substring of A starting from start position with length len e.g. substr('foobar',
4, 1) results in 'b' (see [[[http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substr]]])
||
  ||string ||upper(string A) ucase(string A) ||Returns the string resulting from converting
all characters of A to upper case e.g. upper('fOoBaR') results in 'FOOBAR' ||
  ||string ||lower(string A) lcase(string A) ||Returns the string resulting from converting
all characters of B to lower case e.g. lower('fOoBaR') results in 'foobar' ||
  ||string ||trim(string A) ||Returns the string resulting from trimming spaces from both
ends of A e.g. trim(' foobar ') results in 'foobar' ||

Mime
View raw message