InfluxQL is being rearchitected to work with the InfluxDB v3 storage engine.
This process is ongoing and some InfluxQL features are still being implemented.
This page provides information about the current implementation status of
InfluxQL features.

- [In-progress features](#in-progress-features)
  - [SLIMIT clause](#slimit-clause)
  - [SOFFSET clause](#soffset-clause)
  - [Metaqueries](#metaqueries)
- [Function support](#function-support)
  - [Aggregate functions](#aggregate-functions)
  - [Selector functions](#selector-functions)
  - [Transformations](#transformations)
  - [Technical and predictive analysis](#technical-and-predictive-analysis)

## In-progress features

### SLIMIT clause

InfluxQL in {{< product-name >}} does not currently support the `SLIMIT` clause,
which limits the number of [series](/influxdb/version/reference/glossary/#series)
returned in query results.

<!-- **Tracking issue**: [influxdb_iox#6940](https://github.com/influxdata/influxdb_iox/issues/6940) -->

### SOFFSET clause

InfluxQL in {{< product-name >}} does not currently support the `SOFFSET` clause,
which specifies the number of [series](/influxdb/version/reference/glossary/#series)
to skip before returning results.

<!-- **Tracking issue**: [influxdb_iox#6940](https://github.com/influxdata/influxdb_iox/issues/6940) -->

### Metaqueries

InfluxQL metaqueries return information about the schema of time series data
stored in InfluxDB.
The following table provides information about what metaqueries are available in
{{< product-name >}}:

| Metaquery                                                     |        Supported         |
| :------------------------------------------------------------ | :----------------------: |
| <span style="opacity: .5;">SHOW DATABASES</span>              |                          |
| **SHOW RETENTION POLICIES**                                   | **{{< icon "check" >}}** |
| **SHOW MEASUREMENTS**                                         | **{{< icon "check" >}}** |
| <span style="opacity: .5;">SHOW SERIES</span>                 |                          |
| <span style="opacity: .5;">SHOW SERIES CARDINALITY</span>     |                          |
| **SHOW TAG KEYS**                                             | **{{< icon "check" >}}** |
| <span style="opacity: .5;">SHOW TAG KEY CARDINALITY</span>    |                          |
| **SHOW TAG VALUES**                                           | **{{< icon "check" >}}** |
| <span style="opacity: .5;">SHOW TAG VALUES CARDINALITY</span> |                          |
| **SHOW FIELD KEYS**                                           | **{{< icon "check" >}}** |
| <span style="opacity: .5;">SHOW FIELD KEYS CARDINALITY</span> |                          |

> [!Note]
>
> #### Cardinality metaqueries
> 
> With the InfluxDB v3 storage engine, series cardinality is no longer a limiting
> factor for database performance.
> Cardinality-related metaqueries will likely not be supported with the InfluxDB v3
> storage engine.

## Function support

### Aggregate functions

| Function                                                                                  |        Supported         |
| :---------------------------------------------------------------------------------------- | :----------------------: |
| [COUNT()](/influxdb/version/reference/influxql/functions/aggregates/#count)       | **{{< icon "check" >}}** |
| [DISTINCT()](/influxdb/version/reference/influxql/functions/aggregates/#distinct) | **{{< icon "check" >}}** |
| <span style="opacity: .5;">INTEGRAL()</span>                                              |                          |
| [MEAN()](/influxdb/version/reference/influxql/functions/aggregates/#mean)         | **{{< icon "check" >}}** |
| [MEDIAN()](/influxdb/version/reference/influxql/functions/aggregates/#median)     | **{{< icon "check" >}}** |
| [MODE()](/influxdb/version/reference/influxql/functions/aggregates/#mode)         | **{{< icon "check" >}}** |
| [SPREAD()](/influxdb/version/reference/influxql/functions/aggregates/#spread)     | **{{< icon "check" >}}** |
| [STDDEV()](/influxdb/version/reference/influxql/functions/aggregates/#stddev)     | **{{< icon "check" >}}** |
| [SUM()](/influxdb/version/reference/influxql/functions/aggregates/#sum)           | **{{< icon "check" >}}** |

<!--
INTEGRAL [influxdb_iox#6937](https://github.com/influxdata/influxdb_iox/issues/6937)
-->

### Selector functions

| Function                                                                                     |        Supported         |
| :------------------------------------------------------------------------------------------- | :----------------------: |
| [BOTTOM()](/influxdb/version/reference/influxql/functions/selectors/#bottom)         | **{{< icon "check" >}}** |
| [FIRST()](/influxdb/version/reference/influxql/functions/selectors/#first)           | **{{< icon "check" >}}** |
| [LAST()](/influxdb/version/reference/influxql/functions/selectors/#last)             | **{{< icon "check" >}}** |
| [MAX()](/influxdb/version/reference/influxql/functions/selectors/#max)               | **{{< icon "check" >}}** |
| [MIN()](/influxdb/version/reference/influxql/functions/selectors/#min)               | **{{< icon "check" >}}** |
| [PERCENTILE()](/influxdb/version/reference/influxql/functions/selectors/#percentile) | **{{< icon "check" >}}** |
| <span style="opacity: .5;">SAMPLE()</span>                                                   |                          |
| [TOP()](/influxdb/version/reference/influxql/functions/selectors/#top)               | **{{< icon "check" >}}** |

<!-- SAMPLE() [influxdb_iox#6935](https://github.com/influxdata/influxdb_iox/issues/6935) -->

### Transformations

| Function                                                                                                                     |        Supported         |
| :--------------------------------------------------------------------------------------------------------------------------- | :----------------------: |
| [ABS()](/influxdb/version/reference/influxql/functions/transformations/#abs)                                         | **{{< icon "check" >}}** |
| [ACOS()](/influxdb/version/reference/influxql/functions/transformations/#acos)                                       | **{{< icon "check" >}}** |
| [ASIN()](/influxdb/version/reference/influxql/functions/transformations/#asin)                                       | **{{< icon "check" >}}** |
| [ATAN()](/influxdb/version/reference/influxql/functions/transformations/#atan)                                       | **{{< icon "check" >}}** |
| [ATAN2()](/influxdb/version/reference/influxql/functions/transformations/#atan2)                                     | **{{< icon "check" >}}** |
| [CEIL()](/influxdb/version/reference/influxql/functions/transformations/#ceil)                                       | **{{< icon "check" >}}** |
| [COS()](/influxdb/version/reference/influxql/functions/transformations/#cos)                                         | **{{< icon "check" >}}** |
| [CUMULATIVE_SUM()](/influxdb/version/reference/influxql/functions/transformations/#cumulative_sum)                   | **{{< icon "check" >}}** |
| [DERIVATIVE()](/influxdb/version/reference/influxql/functions/transformations/#derivative)                           | **{{< icon "check" >}}** |
| [DIFFERENCE()](/influxdb/version/reference/influxql/functions/transformations/#difference)                           | **{{< icon "check" >}}** |
| [ELAPSED()](/influxdb/version/reference/influxql/functions/transformations/#elapsed)                                 | **{{< icon "check" >}}** |
| [EXP()](/influxdb/version/reference/influxql/functions/transformations/#exp)                                         | **{{< icon "check" >}}** |
| [FLOOR()](/influxdb/version/reference/influxql/functions/transformations/#floor)                                     | **{{< icon "check" >}}** |
| [LN()](/influxdb/version/reference/influxql/functions/transformations/#ln)                                           | **{{< icon "check" >}}** |
| [LOG()](/influxdb/version/reference/influxql/functions/transformations/#log)                                         | **{{< icon "check" >}}** |
| [LOG2()](/influxdb/version/reference/influxql/functions/transformations/#log2)                                       | **{{< icon "check" >}}** |
| [LOG10()](/influxdb/version/reference/influxql/functions/transformations/#log10)                                     | **{{< icon "check" >}}** |
| [MOVING_AVERAGE()](/influxdb/version/reference/influxql/functions/transformations/#moving_average)                   | **{{< icon "check" >}}** |
| [NON_NEGATIVE_DERIVATIVE()](/influxdb/version/reference/influxql/functions/transformations/#non_negative_derivative) | **{{< icon "check" >}}** |
| [NON_NEGATIVE_DIFFERENCE()](/influxdb/version/reference/influxql/functions/transformations/#non_negative_difference) | **{{< icon "check" >}}** |
| [POW()](/influxdb/version/reference/influxql/functions/transformations/#pow)                                         | **{{< icon "check" >}}** |
| [ROUND()](/influxdb/version/reference/influxql/functions/transformations/#round)                                     | **{{< icon "check" >}}** |
| [SIN()](/influxdb/version/reference/influxql/functions/transformations/#sin)                                         | **{{< icon "check" >}}** |
| [SQRT()](/influxdb/version/reference/influxql/functions/transformations/#sqrt)                                       | **{{< icon "check" >}}** |
| [TAN()](/influxdb/version/reference/influxql/functions/transformations/#tan)                                         | **{{< icon "check" >}}** |

### Technical and predictive analysis

| Function                                                              | Supported |
| :-------------------------------------------------------------------- | :-------: |
| <span style="opacity: .5;">CHANDE_MOMENTUM_OSCILLATOR()</span>        |           |
| <span style="opacity: .5;">DOUBLE_EXPONENTIAL_MOVING_AVERAGE()</span> |           |
| <span style="opacity: .5;">EXPONENTIAL_MOVING_AVERAGE()</span>        |           |
| <span style="opacity: .5;">HOLT_WINTERS()</span>                      |           |
| <span style="opacity: .5;">HOLT_WINTERS_WITH_FIT()</span>             |           |
| <span style="opacity: .5;">KAUFMANS_EFFICIENCY_RATIO()</span>         |           |
| <span style="opacity: .5;">KAUFMANS_ADAPTIVE_MOVING_AVERAGE()</span>  |           |
| <span style="opacity: .5;">RELATIVE_STRENGTH_INDEX()</span>           |           |
| <span style="opacity: .5;">TRIPLE_EXPONENTIAL_MOVING_AVERAGE()</span> |           |
| <span style="opacity: .5;">TRIPLE_EXPONENTIAL_DERIVATIVE()</span>     |           |

<!-- All technical analysis functions [influxdb_iox#6939](https://github.com/influxdata/influxdb_iox/issues/6939) -->

### Date and time functions

| Function                                                                         |        Supported         |
| :------------------------------------------------------------------------------- | :----------------------: |
| [now()](/influxdb/version/reference/influxql/functions/date-time/#now)   | **{{< icon "check" >}}** |
| [time()](/influxdb/version/reference/influxql/functions/date-time/#time) | **{{< icon "check" >}}** |
| [tz()](/influxdb/version/reference/influxql/functions/date-time/#tz)     | **{{< icon "check" >}}** |

### Miscellaneous functions

| Function                                                                    |        Supported         |
| :-------------------------------------------------------------------------- | :----------------------: |
| [fill()](/influxdb/version/reference/influxql/functions/misc/#fill) | **{{< icon "check" >}}** |