Dialects for LindormTSDB - Lindorm - Alibaba Cloud Documentation Center

Lindorm SQL provides dialects for LindormTSDB based on the data models of LindormTSDB. The dialects include latest value query, downsampling query, time series anomaly detection, continuous query, and pre-downsampling query.

SQL dialects for LindormTSDB

The SQL dialects for LindormTSDB include query dialects and pre-processing dialects.

Query dialects

Dialects	Description
Latest value queries	You can query the latest value in each time series.
Downsampling queries	A downsampling query is an aggregate query that is performed based on a specified time interval. Downsampling queries are commonly used for time series data for lower data sampling rate and less query time.
Time series anomaly detection	You can detect abnormal data in time series to quickly identify and troubleshooting problems.
Common time series functions	You can use various functions when you query time series data, including aggregate functions, selection functions, and time processing functions.

Pre-processing dialects

Dialects	Description
CREATE CONTINUOUS QUERY	Creates continuous query tasks.
DROP CONTINUOUS QUERY	Deletes existing continuous query tasks.
SHOW CONTINUOUS QUERIES	Queries existing continuous query tasks.
CREATE PREDOWNSAMPLE	Creates pre-downsampling rules.
SHOW PREDOWNSAMPLES	Queries existing pre-downsampling rules.
DROP PREDOWNSAMPLE	Deletes existing pre-downsampling rules.