Documentation

InfluxQL feature support

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 Cloud Dedicated does not currently support the time zone clause, which applies a time zone offset to UTC timestamps in query results.

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.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.

Read more

InfluxDB v3 enhancements and InfluxDB Clustered is now generally available

New capabilities, including faster query performance and management tooling advance the InfluxDB v3 product line. InfluxDB Clustered is now generally available.

InfluxDB v3 performance and features

The InfluxDB v3 product line has seen significant enhancements in query performance and has made new management tooling available. These enhancements include an operational dashboard to monitor the health of your InfluxDB cluster, single sign-on (SSO) support in InfluxDB Cloud Dedicated, and new management APIs for tokens and databases.

Learn about the new v3 enhancements


InfluxDB Clustered general availability

InfluxDB Clustered is now generally available and gives you the power of InfluxDB v3 in your self-managed stack.

Talk to us about InfluxDB Clustered