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 a 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.

Custom field name for a time series identifier

Unique within a table

Naming conventions for the custom field for a time series identifier:

• 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.

Maximum number of custom fields for time series identifiers

6

Up to 6 custom fields for time series identifiers can be specified.

Maximum number of data fields that can be used as primary key columns

4

Up to 4 data fields can be specified as primary key columns.

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.

Item

Limit

Description

Name of an analytical store

Unique within a table

Naming conventions for an analytical store:

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

• The name cannot start with a digit.

Maximum number of analytical stores

1

You can create only one analytical store for a time series table.

Time to live (TTL) for the data in an analytical store

-1 or a positive integer that is greater than or equal to 2592000

The value of TTL for the data in an analytical store is -1 or an int32 positive integer that is greater than or equal to 2592000. The unit of TTL is seconds. The value of -1 specifies that data in the analytical store never expires. The value of 2592000 equals to 30 days.

Item

Limit

Description

Name of a Lastpoint index

Unique within an instance

Naming conventions for a Lastpoint index:

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

• The name cannot start with a digit.

Maximum number of Lastpoint indexes

10

The sum of the numbers of Lastpoint indexes and analytical stores that are created for a time series table cannot exceed 10.