skip to main content
SQL Functionality for the Driver for Apache Hive : SQL Expressions : Numeric Operators
  

Try DataDirect Drivers Now

Numeric Operators

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