...
Operator | Operand types | Description |
---|---|---|
A AND B | boolean | TRUE if both A and B are TRUE, otherwise FALSE. NULL if A or B is NULL. |
A OR B | boolean | TRUE if either A or B or both are TRUE, FALSE OR NULL is NULL, otherwise FALSE. |
NOT A | boolean | TRUE if A is FALSE or NULL if A is NULL. Otherwise FALSE. |
! A | boolean | Same as NOT A. |
A IN (val1, val2, ...) | boolean | TRUE if A is equal to any of the values. As of Hive 0.13 subqueries are supported in IN statements. |
A NOT IN (val1, val2, ...) | boolean | TRUE if A is not equal to any of the values. As of Hive 0.13 subqueries are supported in NOT IN statements. |
[NOT] EXISTS (subquery) |
| TRUE if the the subquery returns at least one row. Supported as of Hive 0.13. |
String Operators
Operator | Operand types | Description |
---|---|---|
A || B | strings | Concatenates the operands - shorthand for |
Complex Type Constructors
...