ES|QL functions and operators
Stack Serverless
ES|QL provides a comprehensive set of functions and operators for working with data. The reference documentation is divided into the following categories:
Aggregate functions
ABSENT
AVG
COUNT
COUNT_DISTINCT
FIRST
LAST
MAX
MEDIAN
MEDIAN_ABSOLUTE_DEVIATION
MIN
PERCENTILE
PRESENT
SAMPLE
-
Stack
Serverless
ST_CENTROID_AGG
-
Stack
Serverless
ST_EXTENT_AGG
STD_DEV
SUM
TOP
-
Stack
Serverless
VALUES
WEIGHTED_AVG
Time-series aggregate functions
- [preview]
ABSENT_OVER_TIME
- [preview]
AVG_OVER_TIME
- [preview]
COUNT_OVER_TIME
- [preview]
COUNT_DISTINCT_OVER_TIME
- [preview]
FIRST_OVER_TIME
- [preview]
LAST_OVER_TIME
- [preview]
MAX_OVER_TIME
- [preview]
MIN_OVER_TIME
- [preview]
PRESENT_OVER_TIME
- [preview]
RATE
- [preview]
SUM_OVER_TIME
Grouping functions
Date and time functions
IP functions
Math functions
Search functions
Spatial functions
ST_DISTANCE
ST_INTERSECTS
ST_DISJOINT
ST_CONTAINS
ST_WITHIN
ST_X
ST_Y
-
Stack
Serverless
ST_ENVELOPE
-
Stack
Serverless
ST_GEOTILE
-
Stack
Serverless
ST_GEOHEX
-
Stack
Serverless
ST_GEOHASH
String functions
Type conversion functions
TO_BOOLEAN
TO_CARTESIANPOINT
TO_CARTESIANSHAPE
TO_DATEPERIOD
TO_DATETIME
TO_DATE_NANOS
TO_DEGREES
TO_DOUBLE
-
Stack
Serverless
TO_GEOHASH
-
Stack
Serverless
TO_GEOHEX
TO_GEOPOINT
TO_GEOSHAPE
-
Stack
Serverless
TO_GEOTILE
TO_INTEGER
TO_IP
TO_LONG
TO_RADIANS
TO_STRING
TO_TIMEDURATION
-
Stack
Serverless
TO_UNSIGNED_LONG
TO_VERSION