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 Tue, 16 Jun 2009 01:32:09 GMT
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 ZhengShao:
http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF

------------------------------------------------------------------------------
  
  === Conditional Functions ===
  ||T ||if(boolean testCondition, T valueTrue, T valueFalseOrNull) ||Return valueTrue when
testCondition is true, returns valueFalseOrNull otherwise ||
+ ||T ||COALESCE(T v1, T v2, ...) ||Return the first v that is not NULL, or NULL if all v's
are NULL ||
+ ||T ||CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] END || When a = b, returns c; when
a = d, return e; else return f||
+ ||T ||CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END || When a = true, returns b; when
c = true, return d; else return e||
  
  === String Functions ===
  The following are built-in String functions are supported in hive:

Mime
View raw message