|
Entry SQL Level Operator
|
Support in HiveQL
|
|
<>
|
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
|