Apache Tajo - Range Operators
Advertisements
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
apache_tajo_operators.htm
Advertisements