HPL/SQL is included to Apache Hive since version 2.0
HPL/SQL is included to Apache Hive since version 2.0
You can use equality and comparison operators =, ==, <>, !=, <, >, >=, <= to determine if one operand is equal, not equal, less or greater than another operand.
= | == | Equal |
<> | != | Not equal |
> | Greater than | |
< | Less than | |
>= | Greater than or equal | |
<= | Less than or equal |
Syntax:
expr = expr expr == expr expr <> expr expr != expr expr > expr expr < expr expr >= expr expr <= expr
Examples:
Expression | Result | Result Type |
3 = 3 | True | Boolean |
3 = 1 | False | Boolean |
'CA' = NULL | NULL | Boolean |
3 == 3 | True | Boolean |
3 <> 3 | False | Boolean |
3 != 3 | False | Boolean |
3 > 1 | True | Boolean |
3 < 1 | False | Boolean |
3 >= 1 | True | Boolean |
3 <= 1 | False | Boolean |