...
Return Type | Name(Signature) | Description |
---|---|---|
T | if(boolean testCondition, T valueTrue, T valueFalseOrNull) | Returns valueTrue when testCondition is true, returns valueFalseOrNull otherwise. |
boolean | isnull( a ) | Returns true if a is NULL and false otherwise. |
boolean | isnotnull ( a ) | Returns true if a is not NULL and false otherwise. |
T | nvl(T value, T default_value) | Returns default value if value is null else returns value (as of HIve 0.11). |
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.1.0). |
T | least(T v1, T v2, ...) | Returns the least value of the list of values (as of Hive 1.1.0). |
...