Documentation

InfluxQL feature support

Limited availability

InfluxDB Clustered is currently only available to a limited group of InfluxData customers. If interested in being part of the limited access group, please contact the InfluxData Sales team.

InfluxQL is being rearchitected to work with the InfluxDB 3.0 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

Time zones

InfluxQL in InfluxDB Clustered does not currently support the time zone clause, which applies a time zone offset to UTC timestamps in query results.

Subqueries

InfluxQL in InfluxDB Clustered does not currently support subqueries, which let you query data from the results of another InfluxQL query.

SLIMIT clause

InfluxQL in InfluxDB Clustered does not currently support the SLIMIT clause, which limits the number of series returned in query results.

SOFFSET clause

InfluxQL in InfluxDB Clustered does not currently support the SOFFSET clause, which specifies the number of 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 Clustered:

Metaquery Supported
SHOW DATABASES
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.0 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.0 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()

Was this page helpful?

Thank you for your feedback!


Introducing InfluxDB Clustered

A highly available InfluxDB 3.0 cluster on your own infrastructure.

InfluxDB Clustered is a highly available InfluxDB 3.0 cluster built for high write and query workloads on your own infrastructure.

InfluxDB Clustered is currently in limited availability and is only available to a limited group of InfluxData customers. If interested in being part of the limited access group, please contact the InfluxData Sales team.

Learn more
Contact InfluxData Sales

The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Flux is going into maintenance mode and will not be supported in InfluxDB 3.0. This was a decision based on the broad demand for SQL and the continued growth and adoption of InfluxQL. We are continuing to support Flux for users in 1.x and 2.x so you can continue using it with no changes to your code. If you are interested in transitioning to InfluxDB 3.0 and want to future-proof your code, we suggest using InfluxQL.

For information about the future of Flux, see the following: