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 ZhengShao. http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF?action=diff&rev1=32&rev2=33 -------------------------------------------------- ## page was renamed from Hive/HiveQL/UDF <<TableOfContents>> + + NOTE: These commands will be able to show you the latest function documentations. + {{{ + SHOW FUNCTIONS; + DESCRIBE FUNCTION sum; + }}} == Built-in Operators == === Relational Operators === @@ -158, +164 @@ ||string ||space(int n) ||Return a string of n spaces || ||string ||repeat(string str, int n) ||Repeat str n times || ||string ||ascii(string str) ||Returns the numeric value of the first character of str || - ||string ||lpad(string str1, string str2) ||Pad str1 to the left with str2 || - ||string ||rpad(string str1, string str2) ||Pad str1 to the right with str2 || + ||string ||lpad(string str, int len, string pad) ||Returns str, left-padded with pad to a length of len || + ||string ||rpad(string str, int len, string pad) ||Returns str, right-padded with pad to a length of len || ||list ||split(string str, string pat) ||Split str around pat (pat is a regular expression) || ||int ||find_in_set(string str, string strList) ||Returns the first occurance of str in strList where strList is a comman-delimited string. Returns null if either argument is null. Returns 0 if the first argument contains any commas. e.g. find_in_set('ab', 'abc,b,ab,c,def') returns 3 ||
