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:
