Inserting Data to the OpenTSDB Table
Function
Run the INSERT INTO statement to insert the data in the table to the associated OpenTSDB metric.
Syntax
INSERT INTO TABLE_NAME SELECT * FROM SRC_TABLE; INSERT INTO TABLE_NAME VALUES(XXX);
Keyword
Parameter |
Description |
---|---|
TABLE_NAME |
Indicates the name of the associated OpenTSDB table. |
SRC_TABLE |
Indicates the name of the table from which data is obtained. This parameter can be set to a name of a common table. |
Precautions
- The inserted data cannot be null. If the inserted data is the same as the original data or only the value is different, the inserted data overwrites the original data.
- INSERT OVERWRITE is not supported.
- You are advised not to concurrently insert data into a table. If you concurrently insert data into a table, there is a possibility that conflicts occur, leading to data insertion failures.
- The TIMESTAMP format supports only yyyy-MM-dd hh:mm:ss.
Example
Insert data into table opentsdb_table.
insert into opentsdb_table values('city1','city2','2018-05-03 00:00:00',21);
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.