Relational operators compare one expression to another.

The following table lists the supported relational operators.

Table 1. Relational Operators Supported with Apache Hive
Entry SQL Level Operator Support in HiveQL
<> Supported
< Supported
<= Supported
= Supported
<=> Supported (Hive versions 0.9 and higher)
> Supported
>= Supported
IS [NOT] NULL Supported
[NOT] BETWEEN x AND y Supported
[NOT] IN Supported
EXISTS Supported
[NOT] LIKE Supported, except that no collate clause is allowed
RLIKE Supported
REGEXP Supported