ES|QL functions and operators
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
AVG
COUNT
COUNT_DISTINCT
MAX
MEDIAN
MEDIAN_ABSOLUTE_DEVIATION
MIN
PERCENTILE
SAMPLE
- [preview]
ST_CENTROID_AGG
- [preview]
ST_EXTENT_AGG
STD_DEV
SUM
TOP
- [preview]
VALUES
WEIGHTED_AVG
PRESENT
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
- [preview]
ST_ENVELOPE
- [preview]
ST_GEOTILE
- [preview]
ST_GEOHEX
- [preview]
ST_GEOHASH
String functions
Type conversion functions
TO_BOOLEAN
TO_CARTESIANPOINT
TO_CARTESIANSHAPE
TO_DATEPERIOD
TO_DATETIME
TO_DATE_NANOS
TO_DEGREES
TO_DOUBLE
- [preview]
TO_GEOHASH
- [preview]
TO_GEOHEX
TO_GEOPOINT
TO_GEOSHAPE
- [preview]
TO_GEOTILE
TO_INTEGER
TO_IP
TO_LONG
TO_RADIANS
TO_STRING
TO_TIMEDURATION
- [preview]
TO_UNSIGNED_LONG
TO_VERSION