...
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 && B | boolean | Same as A AND B. | A OR B | boolean | TRUE if either A or B or both are TRUE, FALSE OR NULL is NULL, otherwise FALSE. | A || B | boolean | Same as A OR B. |
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. |
...