New

The executive guide to generative AI

Read more
About usPartnersSupport|Login
IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« Logical Operators Aggregate Functions »
Elastic Docs ›Elasticsearch Guide [6.6] ›SQL Access ›Functions and Operators

Math Operators

edit
IMPORTANT: This documentation is no longer updated. Refer to Elastic's version policy and the latest documentation.

Math Operators

edit

This functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.

Perform mathematical operations affecting one or two values. The result is a value of numeric type.

  • 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;
SELECT 5 % 2 AS x;
« Logical Operators Aggregate Functions »
Was this helpful?
Feedback