Apache Hive : HPL/SQL - Equality and Comparison Operators
Table of Contents
Apache Hive : HPL/SQL - Equality and Comparison Operators
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 |