Mathematical Operators

Mathematical operators follow the standard order of operations. That is, parentheses take precedence to division and multiplication, which takes precedence to addition and substraction. For example 5 / 2 + 3 * 2 = (5 / 2) + (3 * 2) and 5 + 2 * 3 - 2 = 5 + (2 * 3) - 2.

Supported Operators

Addition

You can add a constant.

SELECT A + 5 FROM add

You can add together other field keys.

SELECT A + B FROM add

Subtraction

You can subtract a constant.

SELECT 1 - A FROM sub

You can subtract one field key from another field key.

SELECT A - B FROM sub

Multiplication

You can multiply by a constant.

SELECT 10 * A FROM mult

You can multiply by other field keys.

SELECT A * B * C FROM mult

Multiplication distributes across other operators

SELECT 10 * (A + B + C) FROM mult

SELECT 10 * (A - B - C) FROM mult

SELECT 10 * (A + B - C) FROM mult

Division

You can divide by a constant.

SELECT 10 / A FROM div

You can divide by other field keys.

SELECT A / B FROM div

Division distributes across other operators

SELECT 10 / (A + B + C) FROM mult

Operators with Functions

The use of mathematical operators inside of function calls is currently unsupported.

For example

SELECT 10 * mean(value) FROM cpu

will work, however

SELECT mean(10 * value) FROM cpu

will yield a parse error.

Unsupported Operators

Inequalities

Using any of =,!=,<,>,<=,>=,<> in the SELECT clause yields empty results for all types. See GitHub issue 3525.

Miscellaneous

Using any of %, ^ will yield a parse error. If you would like to see support for these operators open an issue.

Logical Operators are Unsupported

Using any of &,|,!|,NAND,XOR,NOR will yield parse error.

Additionally using AND, OR in the SELECT clause of a query will not behave as mathematical operators and simply yield empty results, as they are tokens in InfluxQL.