The following lists the limits on the numbers of databases, data tables, attribute columns, and partitions.
Item | 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 | 10,000 |
Number of Partitions per Master 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 |
Databases
Name: Should not exceed 127 characters, and within the same data link, identical database names are not permitted.
Description: Should not exceed 2048 characters.
External Table Data Address (COS Address): 888 characters (limited by the length of the COS path).
Parameters: In the form of
Map<string:string>, each parameter is limited to 127 characters, with a total length limit of 3000 characters.Data Table/View
Name: Should not exceed 127 characters, and within the same database, identical table names are not permitted.
Description: Should not exceed 1000 characters.
External Table Data Address (COS Address): Should not exceed 888 characters (limited by the length of the COS path).
Parameters: In the form of
Map<string:string>, each parameter can contain up to 127 characters, with a total character limit of 512,000.Attribute Column
Name: Should not exceed 127 characters, and within the same table, identical attribute column names are not permitted.
Description: Should not exceed 256 characters.
Type: Should not exceed 131,072 characters. Exceeding this limit will prevent creation.
Partition
Partition Field Name: Should not exceed 127 characters.