Relational operators compare one expression to another.

The following table lists the supported relational operators.

Table 1. Relational Operators Supported
Entry SQL Level Operator Support in Spark SQL
<> Supported
< Supported
<= Supported
= Supported
<=> Supported
> 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