Query Language
STS-InfluxDB service is a shared InfluxDB service; standard InfluxDB queries work on the STS-InfluxDB service.
For more infomation on the InfluxDB query language, you can visit the official InfluxDB Query Language documentation.
For more information on the query tool, please refer to “Use the web query tool” or contact us by email.
Please note that the current query language tool only supports querying data. That is, you can use the basic data query phrase like:
SELECT
statementGROUP BY
clausesINTO
clausesWHERE
clauses
You can also use the SHOW
command to show a list of
- DATABASES
- MEASUREMENTS
- FIELD KEYS
- TAG KEYS
You can also use functions and Mathematical Operators in the query:
- Aggregations
- COUNT()
- DISTINCT()
- INTEGRAL()
- MEAN()
- MEDIAN()
- MODE()
- SPREAD()
- STDDEV()
- SUM()
- Selectors
- BOTTOM()
- FIRST()
- LAST()
- MAX()
- MIN()
- PERCENTILE()
- SAMPLE()
- TOP()
- Transformations
- CEILING()
- CUMULATIVE_SUM()
- DERIVATIVE()
- DIFFERENCE()
- ELAPSED()
- FLOOR()
- HISTOGRAM()
- MOVING_AVERAGE()
- NON_NEGATIVE_DERIVATIVE()
- Predictors
- HOLT_WINTERS()
However, the following query command are not supported on STS-InfluxDB query tool:
CREATE
DROP
ALTER
- Modify DATABASES
- Modify Users
- Modify retention plans