[Hadoop Wiki] Trivial Update of "Hive/LanguageManual/UDF" by ZhengShao

[Apache Wiki <wi...@apache.org>]

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