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]]) ||
