Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> Creating a Datasource Connection with an OpenTSDB Table> Querying an OpenTSDB Table
View PDF

Querying an OpenTSDB Table

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

  • If no metric exists in OpenTSDB, an error will be reported when the corresponding DLI table is queried.
  • 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;

Keyword

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

Precautions

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

Example

Query data in the opentsdb_table table.

1
 
SELECT * FROM opentsdb_table limit 100;