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.