...
Return Type | Name(Signature) | Description |
|---|---|---|
T | if(boolean testCondition, T valueTrue, T valueFalseOrNull) | Returns valueTrue when testCondition is true, returns valueFalseOrNull otherwise. |
T | COALESCE(T v1, T v2, ...) | Returns 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, returns e; else returns f. |
T | CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END | When a = true, returns b; when c = true, returns d; else returns e. |
| T | greatest(T v1, T v2, ...) | Returns the greatest value of the list of values (as of Hive 1.2.0). |
| T | least(T v1, T v2, ...) | Returns the least value of the list of values (as of Hive 1.2.0). |
String Functions
The following built-in String functions are supported in hive:
...