Hive case when multiple conditions
- case when statement in hive
- case statement in hive with multiple conditions
- nested case statement in hive
- multiple case statement in hive
Hive case when else if
Hive case statement in where clause!
Hive conditional functions are used to apply conditions on one or more columns and the conditions are executed for every row on a table.
In this article, you will learn Hive conditional functions isnull, isnotnull, nvl, nullif, case when e.t.c with examples.
1.
Hive Conditional Functions List
Select the link to know more about the function along with examples.
| Conditional Function | Description |
|---|---|
| isnull( a ) | This returns a true when the value of a (column) is NULL otherwise it returns false. Return: boolean |
| isnotnull ( a ) | This returns a true when the value of a (column) is NOT NULL otherwise it returns false. Return: boolean |
| If(boolean testCondition, T valueTrue, T valueFalseOrNull) | Similar to IF condition existing on SQL queries.
This returns valueTrue when testCondition is true, otherwise returns valueFalseOrNull |
| nvl(T value, T default_value) | This replaces all null values of column T with the default value. Return: T |
| COALESCE(T v1, T v2, …) | Returns the first v that is not NULL, or NULL if all v’s are NULL. Return: T |