Help Center > > Developer Guide> Time Series Engine> Support and Constraints

Support and Constraints

Updated at: Sep 17, 2021 GMT+08:00

Extension Constraints

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

Syntax

Supported or Not (Y/N)

CREATE TABLE

Y

DROP TABLE

Y

INSERT

Y

COPY

Y

SELECT

Y

TRUNCATE

Y

EXPLAIN

Y

ANALYZE

Y

VACUUM

Y

ALTER TABLE ADD(DROP) COLUMN

Y

ALTER TABLE ADD(DROP) PARTITION

Y

ALTER TABLE SET WITH OPTION

Y

ALTER TABLE DROP COLUMN

Y

ALTER TABLE ADD COLUMN

Y

ALTER TABLE CHANGE OWNER

Y

ALTER TABLE RENAME COLUMN

Y

ALTER TABLE TRUNCATE PARTITION

Y

CREATE INDEX

Y

DROP INDEX

Y

DELETE

Y

ALTER TABLE

N

ALTER INDEX

N

MERGE

N

SELECT INTO

Y

UPDATE

N

CREATE TABLE AS

N

  • In the time series table, the Tag column supports the TEXT, CHAR, BOOLEAN, INT, and BIGINT types, and the Field column supports the NUMERIC, TEXT, BOOLEAN, INT, BIGINT, and FLOAT types.
  • After time series is enabled, the compaction function is disabled by default.
  • Time series tables do not support table-level backup.
  • The time series table name cannot contain the number sign (#).

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