Apache Tajo - Relational Operators
Relational operators are used to compare two values and return a Boolean result. Following queries are an examples of relational operators.
Query 1
default> select 50 <= 25 as lessthanequal;
Result
The above query will generate the following output −
lessthanequal ------------------------------- false
The above condition is incorrect so the result is false.
Query 2
default> select 20 >= 10 as greater;
Result
The above query will generate the following output −
greater ------------------------------- true
Here 20 is greater than 10. So, the result is true.
Query 3
default> select 50 = 25 as equal;
Result
The above query will generate the following output −
equal ------------------------------- false
Here, 50 is not equal to 25. So, the result is false.
Query 4
default> select 50<>25 as notequal;
Result
The above query will generate the following output −
notequal ------------------------------- true
From the above result, both the values are not equal so the result is true.