You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2009/07/08 23:37:32 UTC

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

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 RaghothamMurthy:
http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF

------------------------------------------------------------------------------
  
  === String Functions ===
  The following are built-in String functions are supported in hive:
+ || int || length(string A) || returns the length of the string ||
  ||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', 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]]) ||