Apache Tajo - Range Operators

---

---

Between operator is used to test the particular value, which exists from minimum to maximum range.

Query 1

default> select 100 between 10 and 150 as range_between;

Result

The above query will generate the following output −

range_between 
------------------------------- 
true 

Here, 100 lies between the given range so the result is true.

Query 2

default> select 10 is null as range;

Result

The above query will generate the following output −

range 
------------------------------- 
false

The given value 10 is compared with the null value so the result is false.

Let us now check with a not null operator and then see what the result would be like.

Query 3

default> select 10 is not null as range;

Result

The above query will generate the following output −

range 
------------------------------- 
true