elasticsearch/docs/reference/esql/esql-limitations.asciidoc

[[esql-limitations]]
== {esql} limitations

++++
<titleabbrev>Limitations</titleabbrev>
++++

This is work in progress.

[discrete]
[[esql-supported-types]]
=== Supported types

{esql} currently supports the following <<mapping-types,field types>>:

** `alias`
** `boolean`
** `date`
** `double` (`float`, `half_float`, `scaled_float` are represented as `double`)
** `ip`
** `keyword` family including `keyword`, `constant_keyword`, and `wildcard`
** `int` (`short` and `byte` are represented as `int`)
** `long`
** `null`
** `text`
** `unsigned_long`
** `version`

[discrete]
[[esql-tsdb]]
=== {esql} and time series data

{esql} does not support time series data (TSDS).

[discrete]
[[esql-max-rows]]
=== 10,000 row maximum

A single query will not return more than 10,000 rows, regardless of the
`LIMIT` command's value.