Help Center > > Developer Guide

Support and Constraints

Updated at: Jul 14, 2021 GMT+08:00

Extension Constraints

  • The time series 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

Supported

DROP INDEX

Supported

DELETE

Supported

ALTER TABLE

Not supported

ALTER INDEX

Not supported

MERGE

Not supported

SELECT INTO

Supported

UPDATE

Not supported

CREATE TABLE AS

Not supported

  • In the time series table, the tag column supports the text, boolean, int, and big int types and the field column supports the numeric, text, boolean, int, and big int 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 (#), and the length cannot exceed 54 characters.

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