Help Center/ MapReduce Service/ Component Operation Guide (Normal)/ Using Spark (for Versions Earlier Than MRS 3.x)/ Interconnecting Spark with OpenTSDB/ Querying an OpenTSDB Table
Updated on 2022-09-15 GMT+08:00
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='city1';