The following operators are used in Tajo to perform desired operations.
| S.No. | Operator & Description |
|---|---|
| 1 | Arithmetic operatorsPresto supports arithmetic operators such as +, −, *, /, %. |
| 2 | Relational operators<, >, <=, >=, =, <> |
| 3 | Logical operatorsAND, OR, NOT |
| 4 | String operatorsThe ‘||’ operator performs string concatenation. |
| 5 | Range operatorsRange operator is used to test the value in a specific range. Tajo supports BETWEEN, IS NULL, IS NOT NULL operators. |
SQL Functions
As of now, you were aware of running simple basic queries on Tajo. In the next subsequent few chapters, we will discuss the following SQL functions −