---
title: InfluxQL feature support
description: InfluxQL is being rearchitected to work with the InfluxDB 3 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.
url: https://docs.influxdata.com/influxdb3/core/reference/influxql/feature-support/
estimated_tokens: 4319
product: InfluxDB 3 Core
version: core
---

# InfluxQL feature support

InfluxQL is being rearchitected to work with the InfluxDB 3 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 InfluxDB 3 Core does not currently support the `SLIMIT` clause, which limits the number of [series](/influxdb3/core/reference/glossary/#series) returned in query results.

### SOFFSET clause

InfluxQL in InfluxDB 3 Core does not currently support the `SOFFSET` clause, which specifies the number of [series](/influxdb3/core/reference/glossary/#series) to skip before returning results.

### 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 InfluxDB 3 Core:

| Metaquery | Supported |
| --- | --- |
| SHOW DATABASES |  |
| SHOW RETENTION POLICIES |  |
| SHOW MEASUREMENTS |  |
| SHOW SERIES |  |
| SHOW SERIES CARDINALITY |  |
| SHOW TAG KEYS |  |
| SHOW TAG KEY CARDINALITY |  |
| SHOW TAG VALUES |  |
| SHOW TAG VALUES CARDINALITY |  |
| SHOW FIELD KEYS |  |
| SHOW FIELD KEYS CARDINALITY |  |

#### Cardinality metaqueries

With the InfluxDB 3 storage engine, series cardinality is no longer a limiting factor for database performance. Cardinality-related metaqueries will likely not be supported with the InfluxDB 3 storage engine.

## Function support

### Aggregate functions

| Function | Supported |
| --- | --- |
| COUNT() |  |
| DISTINCT() |  |
| INTEGRAL() |  |
| MEAN() |  |
| MEDIAN() |  |
| MODE() |  |
| SPREAD() |  |
| STDDEV() |  |
| SUM() |  |

### Selector functions

| Function | Supported |
| --- | --- |
| BOTTOM() |  |
| FIRST() |  |
| LAST() |  |
| MAX() |  |
| MIN() |  |
| PERCENTILE() |  |
| SAMPLE() |  |
| TOP() |  |

### Transformations

| Function | Supported |
| --- | --- |
| ABS() |  |
| ACOS() |  |
| ASIN() |  |
| ATAN() |  |
| ATAN2() |  |
| CEIL() |  |
| COS() |  |
| CUMULATIVE_SUM() |  |
| DERIVATIVE() |  |
| DIFFERENCE() |  |
| ELAPSED() |  |
| EXP() |  |
| FLOOR() |  |
| LN() |  |
| LOG() |  |
| LOG2() |  |
| LOG10() |  |
| MOVING_AVERAGE() |  |
| NON_NEGATIVE_DERIVATIVE() |  |
| NON_NEGATIVE_DIFFERENCE() |  |
| POW() |  |
| ROUND() |  |
| SIN() |  |
| SQRT() |  |
| TAN() |  |

### Technical and predictive analysis

| Function | Supported |
| --- | --- |
| CHANDE_MOMENTUM_OSCILLATOR() |  |
| DOUBLE_EXPONENTIAL_MOVING_AVERAGE() |  |
| EXPONENTIAL_MOVING_AVERAGE() |  |
| HOLT_WINTERS() |  |
| HOLT_WINTERS_WITH_FIT() |  |
| KAUFMANS_EFFICIENCY_RATIO() |  |
| KAUFMANS_ADAPTIVE_MOVING_AVERAGE() |  |
| RELATIVE_STRENGTH_INDEX() |  |
| TRIPLE_EXPONENTIAL_MOVING_AVERAGE() |  |
| TRIPLE_EXPONENTIAL_DERIVATIVE() |  |

### Date and time functions

| Function | Supported |
| --- | --- |
| now() |  |
| time() |  |
| tz() |  |

### Miscellaneous functions

| Function | Supported |
| --- | --- |
| fill() |  |