hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/LanguageManual/UDF" by ZhengShao
Date Thu, 28 Jan 2010 01:58:42 GMT
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.


  ## page was renamed from Hive/HiveQL/UDF
+ NOTE: These commands will be able to show you the latest function documentations.
+ {{{
+ }}}
  == 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 ||

View raw message