Sponsor of the Day:
Jerkmate
https://www.elastic.co/docs/reference/query-languages/sql/sql-functions-aggs
Aggregate functions | Elasticsearch Reference
Functions for computing a single result from a set of input values. Elasticsearch SQL supports aggregate functions only alongside grouping (implicit or...
aggregate functionselasticsearch reference
https://www.elastic.co/docs/reference/query-languages/esql/functions-operators/grouping-functions
ES|QL grouping functions | Elasticsearch Reference
The STATS command supports these grouping functions: The INLINE STATS command supports these grouping functions: BUCKET, TBUCKET.
es qlfunctions elasticsearchgroupingreference
https://www.elastic.co/guide/en/elasticsearch/reference/6.3/_math_functions.html
Math Functions | Elasticsearch Guide [6.3] | Elastic
elasticsearch guide 6math functions3
https://www.elastic.co/docs/reference/query-languages/esql/functions-operators/spatial-functions
ES|QL spatial functions | Elasticsearch Reference
ES|QL supports several spatial functions, all of which are aligned with the underlying spatial index grid used in Lucene:
es qlfunctions elasticsearchspatialreference
https://www.elastic.co/docs/reference/query-languages/esql/functions-operators/search-functions
ES|QL Search functions | Elasticsearch Reference
Use these functions for full-text search and semantic search. Full text functions can be used to match multivalued fields. A multivalued field that contains...
es qlfunctions elasticsearchreference
https://www.elastic.co/docs/reference/query-languages/sql/sql-functions-search
Full-text search functions | Elasticsearch Reference
Search functions should be used when performing full-text search, namely when the MATCH or QUERY predicates are being used. Outside a, so-called, search...
full text searchfunctions elasticsearchreference
https://www.elastic.co/docs/reference/query-languages/esql/functions-operators/ip-functions
ES|QL IP functions | Elasticsearch Reference
ES|QL supports these IP functions:
es qlfunctions elasticsearchipreference
https://www.elastic.co/docs/reference/query-languages/sql/sql-functions-type-conversion
Type conversion functions | Elasticsearch Reference
Functions for converting an expression of one data type to another. Description: Casts the result of the given expression to the target data type. If...
type conversionfunctions elasticsearchreference
https://www.elastic.co/docs/reference/query-languages/sql/sql-functions
Functions and operators | Elasticsearch Reference
Elasticsearch SQL provides a comprehensive set of built-in operators and functions: Operators, LIKE and RLIKE Operators, Aggregate Functions, Grouping...
elasticsearch referencefunctionsoperators