Documentation

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

SLIMIT clause

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

SOFFSET clause

InfluxQL in InfluxDB Cloud Dedicated 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 Cloud Dedicated:

MetaquerySupported
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

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.

Read more

New in InfluxDB 3.2

Key enhancements in InfluxDB 3.2 and the InfluxDB 3 Explorer UI is now generally available.

See the Blog Post

InfluxDB 3.2 is now available for both Core and Enterprise, bringing the general availability of InfluxDB 3 Explorer, a new UI that simplifies how you query, explore, and visualize data. On top of that, InfluxDB 3.2 includes a wide range of performance improvements, feature updates, and bug fixes including automated data retention and more.

For more information, check out: