Metadata Information
Last updated:2024-07-17 18:17:23
The following lists the limits on the numbers of databases, data tables, attribute columns, and partitions.
Item | Maximum Number |
Databases per account | 1,000 |
Data tables per account | 10,000 |
Tables per database | 4,096 |
Columns per data table | 4,096 |
Partitions per table | 10,000 |
Partitions per root account | 1,000,000 |
Fields per table | 4,096 |
Custom functions per account | 100 |
Catalogs that can be created | 20 |
Database
Name: It can contain up to 127 characters and must be unique in a data link.
Description: It can contain up to 2,048 characters.
Data address of an external table (COS address): It can contain up to 888 characters (COS path length limit).
Parameter: It is in the
Map<string:string> format and can contain up to 127 characters. All parameters can contain up to 3,000 characters in total.Data table/View
Name: It can contain up to 127 characters and must be unique in a database.
Description: It can contain up to 1,000 characters.
Data address of an external table (COS address): It can contain up to 888 characters (COS path length limit).
Parameter: It is in the
Map<string:string> format and can contain up to 127 characters. All parameters can contain up to 512,000 characters in total.Attribute column
Name: It can contain up to 127 characters and must be unique in a data table.
Description: It can contain up to 256 characters.
Field value: It can contain up to 131,072 characters. Longer values cannot be created.
Partition
Partition field name: It can contain up to 127 characters.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback