Help Center> Data Warehouse Service> Developer Guide> Real-Time GaussDB(DWS)> Time Series Engine> Support and Constraints
View PDF

Support and Constraints

Extension Constraints

  • The timing engine supports only some relational syntax. The details are as follows:

Syntax

Supported or Not

CREATE TABLE

Supported

DROP TABLE

Supported

INSERT

Supported

COPY

Supported

SELECT

Supported

TRUNCATE

Supported

EXPLAIN

Supported

ANALYZE

Supported

VACUUM

Supported

ALTER TABLE ADD(DROP) COLUMN

Supported

ALTER TABLE ADD(DROP) PARTITION

Supported

ALTER TABLE SET WITH OPTION

Supported

ALTER TABLE TRUNCATE PARTITION

Supported

CREATE INDEX

Not supported

DROP INDEX

Not supported

DELETE

Not supported

ALTER TABLE

Not supported

ALTER INDEX

Not supported

MERGE

Not supported

SELECT INTO

Not supported

UPDATE

Not supported

CREATE TABLE AS

Not supported
  • The tag column in a time series table supports only the text type, and the field column supports only the numeric type.
  • After time series is enabled, the compaction function is enabled by default.
  • Time series tables do not support online capacity expansion.
  • Time series tables do not support table-level backup.
Parent topic: Time Series Engine