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:

MetaquerySupported
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

FunctionSupported
COUNT()
DISTINCT()
INTEGRAL()
MEAN()
MEDIAN()
MODE()
SPREAD()
STDDEV()
SUM()

Selector functions

FunctionSupported
BOTTOM()
FIRST()
LAST()
MAX()
MIN()
PERCENTILE()
SAMPLE()
TOP()

Transformations

FunctionSupported
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

FunctionSupported
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

FunctionSupported
now()
time()
tz()

Miscellaneous functions

FunctionSupported
fill()

Was this page helpful?

Thank you for your feedback!


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: