- Apache Tajo Tutorial
- Apache Tajo - Home
- Apache Tajo - Introduction
- Apache Tajo - Architecture
- Apache Tajo - Installation
- Apache Tajo - Configuration Settings
- Apache Tajo - Shell Commands
- Apache Tajo - Data Types
- Apache Tajo - Operators
- Apache Tajo - SQL Functions
- Apache Tajo - Math Functions
- Apache Tajo - String Functions
- Apache Tajo - DateTime Functions
- Apache Tajo - JSON Functions
- Apache Tajo - Database Creation
- Apache Tajo - Table Management
- Apache Tajo - SQL Statements
- Aggregate & Window Functions
- Apache Tajo - SQL Queries
- Apache Tajo - Storage Plugins
- Integration with HBase
- Apache Tajo - Integration with Hive
- OpenStack Swift Integration
- Apache Tajo - JDBC Interface
- Apache Tajo - Custom Functions
- Apache Tajo Useful Resources
- Apache Tajo - Quick Guide
- Apache Tajo - Useful Resources
- Apache Tajo - Discussion
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
apache_tajo_operators.htm
Advertisements