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] Trivial Update of "Hive/LanguageManual/UDF" by ZhengShao
Date Wed, 04 Mar 2009 19:16:33 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 ZhengShao:
http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF

------------------------------------------------------------------------------
  === String Functions ===
  The following are built-in String functions are supported in hive:
  ||string ||concat(string A, string B)||returns the string resulting from concatenating B
after A e.g. concat('foo', 'bar') results in 'foobar'||
- ||string ||substr(string A, int start) ||returns the substring of A starting from start
position till the end of string A e.g. concat('foobar', 3) results in 'bar'||
+ ||string ||substr(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
| MySQL substr]])||
+ ||string ||substr(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
| MySQL substr]]) ||
  ||string ||upper(string A)||returns the string resulting from converting all characters
of A to upper case e.g. upper('fOoBaR') results in 'FOOBAR'||
  ||string ||ucase(string A) ||Same as upper||
  ||string ||lower(string A) ||returns the string resulting from converting all characters
of B to lower case e.g. lower('fOoBaR') results in 'foobar'||

Mime
View raw message