Help Center > > Developer Guide> Real-Time GaussDB(DWS)> Time Series Engine> Support and Constraints

Support and Constraints

Updated at: Dec 30, 2020 GMT+08:00

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel