Help Center/ Data Lake Insight/ SQL Syntax Reference (Ally Region)/ Spark SQL Syntax Reference/ Creating a Datasource Connection with an OpenTSDB Table/ Querying an OpenTSDB Table
Updated on 2026-01-09 GMT+08:00
View PDF
Share

Querying an OpenTSDB Table

This SELECT command is used to query data in an OpenTSDB table.

  • If no metrics exist in OpenTSDB, querying the corresponding DLI table will result in an error.
  • If the security mode is enabled, you need to set conf:dli.sql.mrs.opentsdb.ssl.enabled to true when connecting to OpenTSDB.

Syntax

1
 
SELECT * FROM table_name LIMIT number;

Keywords

LIMIT is used to limit the query results. Only INT type is supported by the number parameter.

Precautions

The table to be queried must exist. Otherwise, an error is reported.

Example

Query data in the opentsdb_table table.

1
 
SELECT * FROM opentsdb_table limit 100;
Parent Topic: Creating a Datasource Connection with an OpenTSDB Table