Relational Operators Relational operators compare one expression to another. The following table lists the supported relational operators. Table 30. 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 (Hive versions 0.9 and higher) [NOT] IN Supported EXISTS Supported [NOT] LIKE Supported, except that no collate clause is allowed RLIKE Supported REGEXP Supported