You can use a numeric operator in an expression to negate, add, subtract, multiply, and divide numeric values. The result of this operation is also a numeric value. The + and - operators are also supported in date/time fields to allow date arithmetic.

The following table lists the supported arithmetic operators.

Table 1. Numeric Operators
Entry SQL Level Operator Impala SQL Operator
N/A % (Mod)
N/A & (bitwise AND)
* Supported
+ Supported
- Supported
/ Supported
N/A ^ (XOR)