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
  • SLIMIT clause
  • SOFFSET clause
  • Metaqueries
• Function support
  • Aggregate functions
  • Selector functions
  • Transformations
  • 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 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 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 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()	{{< icon "check" >}}
DISTINCT()	{{< icon "check" >}}
INTEGRAL()	{{< icon "check" >}}
MEAN()	{{< icon "check" >}}
MEDIAN()	{{< icon "check" >}}
MODE()	{{< icon "check" >}}
SPREAD()	{{< icon "check" >}}
STDDEV()	{{< icon "check" >}}
SUM()	{{< icon "check" >}}

Selector functions

Function	Supported
BOTTOM()	{{< icon "check" >}}
FIRST()	{{< icon "check" >}}
LAST()	{{< icon "check" >}}
MAX()	{{< icon "check" >}}
MIN()	{{< icon "check" >}}
PERCENTILE()	{{< icon "check" >}}
<span style="opacity: .5;">SAMPLE()</span>
TOP()	{{< icon "check" >}}

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

Transformations

Function	Supported
ABS()	{{< icon "check" >}}
ACOS()	{{< icon "check" >}}
ASIN()	{{< icon "check" >}}
ATAN()	{{< icon "check" >}}
ATAN2()	{{< icon "check" >}}
CEIL()	{{< icon "check" >}}
COS()	{{< icon "check" >}}
CUMULATIVE_SUM()	{{< icon "check" >}}
DERIVATIVE()	{{< icon "check" >}}
DIFFERENCE()	{{< icon "check" >}}
ELAPSED()	{{< icon "check" >}}
EXP()	{{< icon "check" >}}
FLOOR()	{{< icon "check" >}}
LN()	{{< icon "check" >}}
LOG()	{{< icon "check" >}}
LOG2()	{{< icon "check" >}}
LOG10()	{{< icon "check" >}}
MOVING_AVERAGE()	{{< icon "check" >}}
NON_NEGATIVE_DERIVATIVE()	{{< icon "check" >}}
NON_NEGATIVE_DIFFERENCE()	{{< icon "check" >}}
POW()	{{< icon "check" >}}
ROUND()	{{< icon "check" >}}
SIN()	{{< icon "check" >}}
SQRT()	{{< icon "check" >}}
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()	{{< icon "check" >}}
time()	{{< icon "check" >}}
tz()	{{< icon "check" >}}

Miscellaneous functions

Function	Supported
fill()	{{< icon "check" >}}