Help Center> MapReduce Service> Component Operation Guide> Using Spark> Interconnecting Spark with OpenTSDB> Querying an OpenTSDB Table
View PDF

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

  • The to-be-queried table must exist. Otherwise, an error is reported.
  • The value of tagv must exist. Otherwise, an error occurs.

Example

Query data in the opentsdb_table table.

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