172 lines
12 KiB
Markdown
172 lines
12 KiB
Markdown
---
|
|
title: InfluxQL feature support
|
|
description: >
|
|
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.
|
|
menu:
|
|
influxdb_clustered:
|
|
parent: influxql-reference
|
|
weight: 220
|
|
---
|
|
|
|
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](#in-progress-features)
|
|
- [SLIMIT clause](#slimit-clause)
|
|
- [SOFFSET clause](#soffset-clause)
|
|
- [Metaqueries](#metaqueries)
|
|
- [Function support](#function-support)
|
|
- [Aggregate functions](#aggregate-functions)
|
|
- [Selector functions](#selector-functions)
|
|
- [Transformations](#transformations)
|
|
- [Technical and predictive analysis](#technical-and-predictive-analysis)
|
|
|
|
## In-progress features
|
|
|
|
### SLIMIT clause
|
|
|
|
InfluxQL in {{< product-name >}} does not currently support the `SLIMIT` clause,
|
|
which limits the number of [series](/influxdb/clustered/reference/glossary/#series)
|
|
returned in query results.
|
|
|
|
<!-- **Tracking issue**: [influxdb_iox#6940](https://github.com/influxdata/influxdb_iox/issues/6940) -->
|
|
|
|
### SOFFSET clause
|
|
|
|
InfluxQL in {{< product-name >}} does not currently support the `SOFFSET` clause,
|
|
which specifies the number of [series](/influxdb/clustered/reference/glossary/#series)
|
|
to skip before returning results.
|
|
|
|
<!-- **Tracking issue**: [influxdb_iox#6940](https://github.com/influxdata/influxdb_iox/issues/6940) -->
|
|
|
|
### 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
|
|
{{< product-name >}}:
|
|
|
|
| Metaquery | Supported |
|
|
| :------------------------------------------------------------ | :----------------------: |
|
|
| <span style="opacity: .5;">SHOW DATABASES</span> | |
|
|
| **SHOW RETENTION POLICIES** | **{{< icon "check" >}}** |
|
|
| **SHOW MEASUREMENTS** | **{{< icon "check" >}}** |
|
|
| <span style="opacity: .5;">SHOW SERIES</span> | |
|
|
| <span style="opacity: .5;">SHOW SERIES CARDINALITY</span> | |
|
|
| **SHOW TAG KEYS** | **{{< icon "check" >}}** |
|
|
| <span style="opacity: .5;">SHOW TAG KEY CARDINALITY</span> | |
|
|
| **SHOW TAG VALUES** | **{{< icon "check" >}}** |
|
|
| <span style="opacity: .5;">SHOW TAG VALUES CARDINALITY</span> | |
|
|
| **SHOW FIELD KEYS** | **{{< icon "check" >}}** |
|
|
| <span style="opacity: .5;">SHOW FIELD KEYS CARDINALITY</span> | |
|
|
|
|
{{% note %}}
|
|
#### 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.
|
|
{{% /note %}}
|
|
|
|
## Function support
|
|
|
|
### Aggregate functions
|
|
|
|
| Function | Supported |
|
|
| :---------------------------------------------------------------------------------- | :----------------------: |
|
|
| [COUNT()](/influxdb/clustered/reference/influxql/functions/aggregates/#count) | **{{< icon "check" >}}** |
|
|
| [DISTINCT()](/influxdb/clustered/reference/influxql/functions/aggregates/#distinct) | **{{< icon "check" >}}** |
|
|
| <span style="opacity: .5;">INTEGRAL()</span> | |
|
|
| [MEAN()](/influxdb/clustered/reference/influxql/functions/aggregates/#mean) | **{{< icon "check" >}}** |
|
|
| [MEDIAN()](/influxdb/clustered/reference/influxql/functions/aggregates/#median) | **{{< icon "check" >}}** |
|
|
| [MODE()](/influxdb/clustered/reference/influxql/functions/aggregates/#mode) | **{{< icon "check" >}}** |
|
|
| [SPREAD()](/influxdb/clustered/reference/influxql/functions/aggregates/#spread) | **{{< icon "check" >}}** |
|
|
| [STDDEV()](/influxdb/clustered/reference/influxql/functions/aggregates/#stddev) | **{{< icon "check" >}}** |
|
|
| [SUM()](/influxdb/clustered/reference/influxql/functions/aggregates/#sum) | **{{< icon "check" >}}** |
|
|
|
|
<!--
|
|
INTEGRAL [influxdb_iox#6937](https://github.com/influxdata/influxdb_iox/issues/6937)
|
|
-->
|
|
|
|
### Selector functions
|
|
|
|
| Function | Supported |
|
|
| :------------------------------------------------------------------------------------- | :----------------------: |
|
|
| [BOTTOM()](/influxdb/clustered/reference/influxql/functions/selectors/#bottom) | **{{< icon "check" >}}** |
|
|
| [FIRST()](/influxdb/clustered/reference/influxql/functions/selectors/#first) | **{{< icon "check" >}}** |
|
|
| [LAST()](/influxdb/clustered/reference/influxql/functions/selectors/#last) | **{{< icon "check" >}}** |
|
|
| [MAX()](/influxdb/clustered/reference/influxql/functions/selectors/#max) | **{{< icon "check" >}}** |
|
|
| [MIN()](/influxdb/clustered/reference/influxql/functions/selectors/#min) | **{{< icon "check" >}}** |
|
|
| [PERCENTILE()](/influxdb/clustered/reference/influxql/functions/selectors/#percentile) | **{{< icon "check" >}}** |
|
|
| <span style="opacity: .5;">SAMPLE()</span> | |
|
|
| [TOP()](/influxdb/clustered/reference/influxql/functions/selectors/#top) | **{{< icon "check" >}}** |
|
|
|
|
<!-- SAMPLE() [influxdb_iox#6935](https://github.com/influxdata/influxdb_iox/issues/6935) -->
|
|
|
|
### Transformations
|
|
|
|
| Function | Supported |
|
|
| :--------------------------------------------------------------------------------------------------------------------- | :----------------------: |
|
|
| [ABS()](/influxdb/clustered/reference/influxql/functions/transformations/#abs) | **{{< icon "check" >}}** |
|
|
| [ACOS()](/influxdb/clustered/reference/influxql/functions/transformations/#acos) | **{{< icon "check" >}}** |
|
|
| [ASIN()](/influxdb/clustered/reference/influxql/functions/transformations/#asin) | **{{< icon "check" >}}** |
|
|
| [ATAN()](/influxdb/clustered/reference/influxql/functions/transformations/#atan) | **{{< icon "check" >}}** |
|
|
| [ATAN2()](/influxdb/clustered/reference/influxql/functions/transformations/#atan2) | **{{< icon "check" >}}** |
|
|
| [CEIL()](/influxdb/clustered/reference/influxql/functions/transformations/#ceil) | **{{< icon "check" >}}** |
|
|
| [COS()](/influxdb/clustered/reference/influxql/functions/transformations/#cos) | **{{< icon "check" >}}** |
|
|
| [CUMULATIVE_SUM()](/influxdb/clustered/reference/influxql/functions/transformations/#cumulative_sum) | **{{< icon "check" >}}** |
|
|
| [DERIVATIVE()](/influxdb/clustered/reference/influxql/functions/transformations/#derivative) | **{{< icon "check" >}}** |
|
|
| [DIFFERENCE()](/influxdb/clustered/reference/influxql/functions/transformations/#difference) | **{{< icon "check" >}}** |
|
|
| [ELAPSED()](/influxdb/clustered/reference/influxql/functions/transformations/#elapsed) | **{{< icon "check" >}}** |
|
|
| [EXP()](/influxdb/clustered/reference/influxql/functions/transformations/#exp) | **{{< icon "check" >}}** |
|
|
| [FLOOR()](/influxdb/clustered/reference/influxql/functions/transformations/#floor) | **{{< icon "check" >}}** |
|
|
| [LN()](/influxdb/clustered/reference/influxql/functions/transformations/#ln) | **{{< icon "check" >}}** |
|
|
| [LOG()](/influxdb/clustered/reference/influxql/functions/transformations/#log) | **{{< icon "check" >}}** |
|
|
| [LOG2()](/influxdb/clustered/reference/influxql/functions/transformations/#log2) | **{{< icon "check" >}}** |
|
|
| [LOG10()](/influxdb/clustered/reference/influxql/functions/transformations/#log10) | **{{< icon "check" >}}** |
|
|
| [MOVING_AVERAGE()](/influxdb/clustered/reference/influxql/functions/transformations/#moving_average) | **{{< icon "check" >}}** |
|
|
| [NON_NEGATIVE_DERIVATIVE()](/influxdb/clustered/reference/influxql/functions/transformations/#non_negative_derivative) | **{{< icon "check" >}}** |
|
|
| [NON_NEGATIVE_DIFFERENCE()](/influxdb/clustered/reference/influxql/functions/transformations/#non_negative_difference) | **{{< icon "check" >}}** |
|
|
| [POW()](/influxdb/clustered/reference/influxql/functions/transformations/#pow) | **{{< icon "check" >}}** |
|
|
| [ROUND()](/influxdb/clustered/reference/influxql/functions/transformations/#round) | **{{< icon "check" >}}** |
|
|
| [SIN()](/influxdb/clustered/reference/influxql/functions/transformations/#sin) | **{{< icon "check" >}}** |
|
|
| [SQRT()](/influxdb/clustered/reference/influxql/functions/transformations/#sqrt) | **{{< icon "check" >}}** |
|
|
| [TAN()](/influxdb/clustered/reference/influxql/functions/transformations/#tan) | **{{< icon "check" >}}** |
|
|
|
|
### Technical and predictive analysis
|
|
|
|
| Function | Supported |
|
|
| :-------------------------------------------------------------------- | :-------: |
|
|
| <span style="opacity: .5;">CHANDE_MOMENTUM_OSCILLATOR()</span> | |
|
|
| <span style="opacity: .5;">DOUBLE_EXPONENTIAL_MOVING_AVERAGE()</span> | |
|
|
| <span style="opacity: .5;">EXPONENTIAL_MOVING_AVERAGE()</span> | |
|
|
| <span style="opacity: .5;">HOLT_WINTERS()</span> | |
|
|
| <span style="opacity: .5;">HOLT_WINTERS_WITH_FIT()</span> | |
|
|
| <span style="opacity: .5;">KAUFMANS_EFFICIENCY_RATIO()</span> | |
|
|
| <span style="opacity: .5;">KAUFMANS_ADAPTIVE_MOVING_AVERAGE()</span> | |
|
|
| <span style="opacity: .5;">RELATIVE_STRENGTH_INDEX()</span> | |
|
|
| <span style="opacity: .5;">TRIPLE_EXPONENTIAL_MOVING_AVERAGE()</span> | |
|
|
| <span style="opacity: .5;">TRIPLE_EXPONENTIAL_DERIVATIVE()</span> | |
|
|
|
|
<!-- All technical analysis functions [influxdb_iox#6939](https://github.com/influxdata/influxdb_iox/issues/6939) -->
|
|
|
|
### Date and time functions
|
|
|
|
| Function | Supported |
|
|
| :------------------------------------------------------------------------- | :----------------------: |
|
|
| [now()](/influxdb/clustered/reference/influxql/functions/date-time/#now) | **{{< icon "check" >}}** |
|
|
| [time()](/influxdb/clustered/reference/influxql/functions/date-time/#time) | **{{< icon "check" >}}** |
|
|
| [tz()](/influxdb/clustered/reference/influxql/functions/date-time/#tz) | **{{< icon "check" >}}** |
|
|
|
|
### Miscellaneous functions
|
|
|
|
| Function | Supported |
|
|
| :-------------------------------------------------------------------- | :----------------------: |
|
|
| [fill()](/influxdb/clustered/reference/influxql/functions/misc/#fill) | **{{< icon "check" >}}** |
|