A logical operator combines the results of two component conditions to produce a single result or to invert the result of a single condition. The following table lists the supported logical operators.

Table 1. Logical Operators
Operator Support in HiveQL
NOT ! Supported
AND && Supported
OR || Supported