vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/mrs/component-operation-guide/mrs_01_0587.html
Yang, Tong 6182f91ba8 MRS component operation guide_normal 2.0.38.SP20 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>
2022-12-09 14:55:21 +00:00

2.9 KiB
Raw Permalink Blame History

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';