skip to main content
SQL Functionality for the Impala Wire Protocol Driver : SQL Expressions : Relational Operators
  
Relational Operators
Relational operators compare one expression to another.
The following table lists the supported relational operators.
Table 45. 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