The number of databases, data tables, attribute columns, and partitions.
Project | Maximum Quantity |
Number of databases per account | 1,000 |
Number of data tables per account | 10,000 |
Number of tables per database | 4,096 |
Number of columns per data table | 4,096 |
Number of partitions per table | 100,000 |
Number of partitions per primary account | 1,000,000 |
Maximum number of fields per table | 4096 |
Number of custom functions per account | 100 |
Number of catalogs that can be created | 20 |
Database
Name: It must not exceed 127 characters, and duplicate database names are not allowed under the same data link.
Description: It must not exceed 2048 characters.
Data address for the external table (COS address): 888 characters (COS path length limitation).
Parameters: They must be in the format of
Map<string:string>. The length of each parameter is limited to 127 characters, and the total length is limited to 3000 characters.Data Table/View
Name: It must not exceed 127 characters, and duplicate table names are not allowed within the same database.
Description: It must not exceed 1000 characters.
Data address for the external table (COS address): It can contain up to 888 characters (COS path length limitation).
Parameters: They must be in the format of
Map<string:string>. The length of each parameter is limited to 127 characters, and the total length is limited to 512000 characters.Attribute Column
Name: It must not exceed 127 characters, and duplicate column names are not allowed within the same table.
Description: It can contain up to 256 characters.
Type: It can contain up to 131072 characters. Creation will fail if this limit is exceeded.
Partition
Partition field name: It must not exceed 127 characters.