Entry SQL Level Operator | Support in HiveQL |
<> | Supported |
< | Supported |
<= | Supported |
= | Supported |
<=> | Supported (Hive versions 0.9 and higher) |
> | Supported |
>= | Supported |
IS [NOT] NULL | Supported |
[NOT] BETWEEN x AND y | Supported (Hive versions 0.9 and higher) |
[NOT] IN | Supported |
EXISTS | Supported |
[NOT] LIKE | Supported, except that no collate clause is allowed |
RLIKE | Supported |
REGEXP | Supported |