Tablestore:Limits on the TimeSeries model

Item

Limit

Description

Name of a time series table

Unique within an instance

Naming conventions for a time series table:

• The name must be 1 to 128 characters in length and can contain letters, digits, and underscores (_). The name is case-sensitive.

• The name must start with a letter or an underscore (_).

Name of a time series column

Unique within a table

Naming conventions for time series column:

• The name must be 1 to 128 bytes in length and can contain lowercase letters, digits, and underscores (_). The name is case-sensitive.

• The name cannot start with a digit.

• The name cannot contain _m_name, _data_source, _tags, _time, _meta_update_time, or _attributes.

Data type of a time series column

String, Integer, Double, Boolean, and Binary

• String: a UTF-8-encoded string that does not exceed 2 MB in length.

• Integer: a 64-bit signed integer that is 8 bytes in length.

• Double: a 64-bit Double value that is 8 bytes in length.

• Boolean: True or False that is 1 byte in length.

• Binary: binary data that does not exceed 2 MB in length.

Name of a data field in a time series

Unique within a table

Naming conventions for a data field in a time series:

• The name must be 1 to 128 bytes in length and can contain lowercase letters, digits, and underscores (_). The name is case-sensitive.

• The name cannot start with a digit.

Measurement name

Unique within a table

The measurement name must be a UTF-8-encoded string that is 1 to 128 bytes in length. The name cannot contain number signs (#) or non-printable characters such as spaces.

Data source

Unique within a table

The data source must be a UTF-8-encoded string that is 0 to 256 bytes in length.

Tags

In the ["k1=v1","k2=v2"] format

The tags must be in the ["k1=v1","k2=v2"] format. Each tag consists of a key and a value that are connected by an equal sign (=).

• The tag key must contain only printable ASCII characters. The tag value can be a UTF-8-encoded string.

• The tag key and tag value cannot contain double quotation marks (") or equal signs (=).

Time column

Greater than or equal to 0

Unit: microseconds.

Item

Limit

Description

Maximum number of columns that can be written at the same time

1024

You can write up to 1,024 attribute columns in a single row to a time series table at the same time.

Maximum number of rows that can be written at the same time

200

You can write up to 200 rows to a time series table at the same time.

Maximum size of data that can be written to a time series table at the same time

4 MB

You can write up to 4 MB of data to a time series table at the same time.