skip to main content
Supported SQL Functionality : SQL Expressions : Relational Operators
  

Try DataDirect Drivers Now

Relational Operators

Relational operators compare one expression to another. The following table lists the supported relational operators.
Table 22. 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