Documentation

InfluxQL feature support

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

Tracking issue: influxdb_iox#6933

Subqueries

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

Tracking issue: influxdb_iox#6897

SLIMIT clause

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

Tracking issue: influxdb_iox#6940

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.

Tracking issue: influxdb_iox#6940

Project additional fields with selector functions

InfluxQL in InfluxDB Cloud Dedicated does not currently let you project additional fields when using selector functions. Selector functions return specific rows with values that meets the criteria of the function. Projecting other fields returns additional field values associated with the selected row and timestamp. For example:

SELECT MAX(co), temp, hum FROM home

This query selects the row with the maximum co value and should return the temp and hum value currently associated with that row. This query currently returns an error.

Tracking issue: influxdb_iox#7533

Function support

Aggregate functions

FunctionSupportedTracking Issue
COUNT()
DISTINCT()
INTEGRAL()influxdb_iox#6937
MEAN()
MEDIAN()
MODE()influxdb_iox#7334
SPREAD()influxdb_iox#6937
STDDEV()
SUM()

Selector functions

FunctionSupportedTracking Issue
BOTTOM()influxdb_iox#6935
FIRST()
LAST()
MAX()
MIN()
PERCENTILE()influxdb_iox#7664
SAMPLE()influxdb_iox#6935
TOP()influxdb_iox#7650

Transformations

FunctionSupportedTracking Issue
ABS()
ACOS()
ASIN()
ATAN()
ATAN2()
CEIL()
COS()
CUMULATIVE_SUM()influxdb_iox#7467
DERIVATIVE()influxdb_iox#7647
DIFFERENCE()influxdb_iox#7468
ELAPSED()influxdb_iox#6934
EXP()
FLOOR()
LN()
LOG()
LOG2()
LOG10()
MOVING_AVERAGE()influxdb_iox#7600
NON_NEGATIVE_DERIVATIVE()influxdb_iox#7649
NON_NEGATIVE_DIFFERENCE()influxdb_iox#7628
POW()
ROUND()
SIN()
SQRT()
TAN()

Technical and predictive analysis

FunctionSupportedTracking Issue
CHANDE_MOMENTUM_OSCILLATOR()influxdb_iox#6939
DOUBLE_EXPONENTIAL_MOVING_AVERAGE()influxdb_iox#6939
EXPONENTIAL_MOVING_AVERAGE()influxdb_iox#6939
HOLT_WINTERS()influxdb_iox#6939
HOLT_WINTERS_WITH_FIT()influxdb_iox#6939
KAUFMANS_EFFICIENCY_RATIO()influxdb_iox#6939
KAUFMANS_ADAPTIVE_MOVING_AVERAGE()influxdb_iox#6939
RELATIVE_STRENGTH_INDEX()influxdb_iox#6939
TRIPLE_EXPONENTIAL_MOVING_AVERAGE()influxdb_iox#6939
TRIPLE_EXPONENTIAL_DERIVATIVE()influxdb_iox#6939

Date and time functions

FunctionSupportedTracking Issue
now()
time()
tz()influxdb_iox#6933

Miscellaneous functions

FunctionSupportedTracking Issue
fill()

Was this page helpful?

Thank you for your feedback!


Introducing InfluxDB 3.0

The new core of InfluxDB built with Rust and Apache Arrow. Available today in InfluxDB Cloud Dedicated.

Learn more

State of the InfluxDB Cloud Serverless documentation

The new documentation for InfluxDB Cloud Serverless is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.