Functions and operators

EQL contains a number of built-in functions that process data. It also supports arithmetic operators.

Important

With some exceptions, all the functions and operators mentioned in this chapter work only on atomic data types. That is, they are not supported with sets. The exceptions are:

ARB
COUNT
COUNT_APPROX
COUNTDISTINCT
APPROXCOUNTDISTINCT
HAS_REFINEMENTS

For information on the set functions, see Sets and Multi-assign Data.

Numeric functions
EQL supports the following numeric functions.
Aggregation functions
EQL supports the following aggregation functions.
Geocode functions
The geocode data type contains the longitude and latitude values that represent a geocode property.
Date and time functions
EQL provides functions for working with time, dateTime, and duration data types.
String functions
EQL supports the following string functions.
Arithmetic operators
EQL supports arithmetic operators for addition, subtraction, multiplication, and division.
Boolean operators
EQL supports the Boolean operators AND, OR, and NOT.