Relational operators compare one expression to another. The following table lists the supported relational operators.

Table 1. Relational Operators Supported with Spark SQL
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