Querying an OpenTSDB Table

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

Syntax

SELECT * FROM table_name WHERE tagk=tagv LIMIT number;

Keyword

Parameter

Description

LIMIT

Used to limit the query results.

number

Only the INT type is supported.

Precautions

Example

Query data in the opentsdb_table table.

SELECT * FROM opentsdb_table LIMIT 100;
SELECT * FROM opentsdb_table WHERE city='city1';