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