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 HiveQL Operator
* Supported
+ Supported
- Supported
/ Supported
^ (XOR) N/A
% (Mod) N/A
& (bitwise AND) N/A