Data Imported Out of Order

Uqbar support data import out of order. Typically, data written into Uqbar is ordered by time. It means that the value of the time column for data written later is greater than that for data written early. Due to such reasons as network or message queue, the value of the time column for data written later is lower than that for data written early. It is called out of order. Out-of-order is for data from the same tag set.

Note: Uqbar supports uncompressed data imported out of order. Compressed data is not allowed to be imported out of order.

Syntax Format

INSERT INTO table VALUES [, ...];

Examples

Uqbar=# CREATE TIMESERIES TABLE weather(time timestamp TSTIME, city text TSTAG, location text TSTAG, temperature float) POLICY default_policy;
CREATE TIMESERIES TABLE
Uqbar=# INSERT INTO weather VALUES('2022-06-18 00:00:00', 'beijing', 'park', 36);
INSERT 0 1
Uqbar=# INSERT INTO weather VALUES('2022-06-17 12:00:00', 'beijing', 'park', 30);
INSERT 0 1