Numeric Operators
- Last Updated: May 13, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- Cloudera Impala 5.1
- Documentation
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.
| Entry SQL Level Operator | Impala SQL Operator |
|---|---|
| * | Supported |
| + | Supported |
| - | Supported |
| / | Supported |
| ^ (XOR) | N/A |
| % (Mod) | N/A |
| & (bitwise AND) | N/A |