{{esql}} functions and operators [esql-functions-operators]

{{esql}} provides a comprehensive set of functions and operators for working with data. The reference documentation is divided into the following categories:

Functions overview [esql-functions]

Aggregate functions

::::{dropdown} Aggregate function list :open: :::{include} _snippets/lists/aggregation-functions.md ::: ::::

Time-series aggregate functions

::::{dropdown} Time-series aggregate function list :open: :::{include} _snippets/lists/time-series-aggregation-functions.md ::: ::::

Grouping functions

::::{dropdown} Grouping function list :open: :::{include} _snippets/lists/grouping-functions.md ::: ::::

Conditional functions and expressions

::::{dropdown} Conditional function and expression list :open: :::{include} _snippets/lists/conditional-functions-and-expressions.md ::: ::::

Date and time functions

::::{dropdown} Date and time function list :open: :::{include} _snippets/lists/date-time-functions.md ::: ::::

IP functions

::::{dropdown} IP function list :open: :::{include} _snippets/lists/ip-functions.md ::: ::::

Math functions

::::{dropdown} Math function list :open: :::{include} _snippets/lists/math-functions.md ::: ::::

Search functions

::::{dropdown} Search function list :open: :::{include} _snippets/lists/search-functions.md ::: ::::

Spatial functions

::::{dropdown} Spatial function list :open: :::{include} _snippets/lists/spatial-functions.md ::: ::::

String functions

::::{dropdown} String function list :open: :::{include} _snippets/lists/string-functions.md ::: ::::

Type conversion functions

::::{dropdown} Type conversion function list :open: :::{include} _snippets/lists/type-conversion-functions.md ::: ::::

Dense vector functions

::::{dropdown} Dense vector function list :open: :::{include} _snippets/lists/dense-vector-functions.md ::: ::::

Multi value functions

::::{dropdown} Multi value function list :open: :::{include} _snippets/lists/mv-functions.md ::: ::::

Operators overview [esql-operators-overview]

::::{dropdown} Operator list :open: :::{include} _snippets/lists/operators.md ::: ::::