v2.0
- About Uqbar
- Release Note
- Uqbar Installation
- Uqbar Management
- Data Retention Policy
- Time-Series Table Management
- Time-Series Data Write
- Data Compression
- Data Deletion
- Data Query
- Continuous Aggregation
- Time-Series Views
- Cluster Management
- Backup and Restoration
- Security
- GUC Parameters
- SQL Syntax
- Third Party Tools Support
- Glossary
Data Imported into a Time-Series Table Using Standard SQLs
Sensor or monitoring data can be inserted into a time-series table using standard SQLs. One or more data records can be inserted at one time. Before data write, you need to create a time-series table, or ensure that there are time-series tables in the system.
Precautions
- You do not have to insert the time column.
- Data can be imported out of order (Chunks that are not compressed can be inserted out of order in this version).
- The
tstimecolumn does not support NULL. - The
tstagcolumn does not support NULL.
Syntax Format
-
Insert a single data record.
INSERT INTO table_name[(targelist)] VALUES(value_list); -
Insert multiple data records.
INSERT INTO table_name[(targelist)] VALUES(value_list)[, (value_list)]...;
Examples
MogDB=# INSERT INTO weather(time, city, location, temperature) VALUES('2022-07-06 00:00:00','beijing', 'gongyuan', 29.1);
INSERT 0 1
MogDB=# INSERT INTO weather(time, city, location, temperature) VALUES('2022-07-06 00:00:00','beijing', 'chaoyang', 29.1), ('2022-7-6 00:00:00','shanghao', 'gongyuan', 29.2);
INSERT 0 2