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 17. Relational Operators Supported with Impala
Entry SQL Level Operator
Support in Impala 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