IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.

› › ›

Math Operators

edit

Math Operators

edit

Elasticsearch SQL supports the following math operators:

Add (+)

SELECT 1 + 1 AS x;

Subtract (infix -)

SELECT 1 - 1 AS x;

Negate (unary -)

SELECT - 1 AS x;

Multiply (*)

SELECT 2 * 3 AS x;

Divide (/)

SELECT 6 / 3 AS x;

Modulo or Reminder(%)

SELECT 5 % 2 AS x;

« Logical Operators Math Functions »