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.
Subqueries
InfluxQL in InfluxDB Cloud Dedicated does not currently support subqueries, which let you query data from the results of another InfluxQL query.
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:
| 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
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!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.