skip to main content
SQL Functionality for the Driver for Apache Spark SQL : 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 6. 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