tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Data Lake Compute
    Documentation
    Download PDF

    Quotas and limits

    Last updated: 2024-07-23 14:11:48
    Download PDF

      Resource Quota limits

      There are not any limits to private engine. But if you need to increase resource engine CU quota greater than 256CUs, please raise a request to DLC team.

      Job Limits

      Quota
      Default
      Notes
      Query usage per day
      Unlimited
      -
      Query usage per day per user
      Unlimited
      -
      Maximum number of concurrent multi-statement queries
      20
      Increased by request
      Daily query size limit
      Unlimited
      -
      Daily destination table update limit
      Unlimited
      -
      Query/multi-statement query execution-time limit
      Unlimited
      -
      Maximum number of sql query tables
      Unlimited
      -
      Maximum number of sql query parameters
      Unlimited
      -

      External Table Limits

      Quota
      Default
      Maximum number of files per external table
      Unlimited
      Maximum size of stored data on COS per external table
      Unlimited
      Maximum number of files in the source COS bucket
      Unlimited

      Database/Table/Column/Partition Limits

      Quota
      Default
      Notes
      Maximum number of DBS per user
      1,000
      Maximum number of tables per user
      10,000
      Maximum number of tables per db
      4,096
      Maximum number of columns per table
      4,096
      Maximum number of partitions per table
      100,000
      Maximum number of partitions per user
      1,000,000
      Maximum number of UDF per user
      100
      Maximum number of catalogs per user
      20
      Maximum length of db name
      127 characters
      Maximum length of db description
      2048 characters
      Maximum length of external table location (cos)
      888 characters
      Maximum length of parameters/total length for db
      127/3000 characters
      Format:Map<string:string>
      Maximum length of table/view name
      127 characters
      Maximum length of table/view description
      1000 characters
      Maximum length of parameters/total length for table/view
      127/512000 characters
      Format:Map<string:string>
      Maximum number of nested view levels
      Unlimited
      Maximum length of a SQL query used to define a view
      10M characters
      Maximum number of authorized views per dataset
      4096
      Maximum length of column name
      127 characters
      Maximum length of column description
      256 characters
      Maximum length of column type
      256 characters
      Maximum length of column partition
      127 characters

      UDF Limits

      Quota
      Default
      Maximum number of outputs per line
      5 MB
      Maximum embed code blob size
      32 KB
      Maximum size per external code resource
      1 MB
      Maximum length of UDF names
      256 characters
      Maximum number of parameters
      256 characters
      Maximum length of parameter names
      128 characters
      UDF reference chain depth limit
      16
      The upper limit of the depth of the STRUCT type parameter or output
      15 levels
      Maximum update rate per UDF every 10 seconds
      5
      Maximum number of fields in a parameter or output of type STRUCT per UDF
      1024 fields

      DML Limits

      Quota
      Default
      DML statements per day
      Unlimited
      Concurrent mutating DML statements per table
      20 statements
      Maximum rate of DML statements for each table
      100 statements every 1 seconds

      Row Level Permissions Limits

      Quota
      Default
      Maximum number of row access policies per table
      400 policies
      Maximum number of row access policies per query
      6,000 policies
      Maximum number of CREATE/DROP DDL statements per 10 seconds per policy
      5 statements
      Number of DROP ALL ROW ACCESS POLICIES statements per table per 10 seconds
      5 statements

      API Limits

      API limits refer to document API Category .
      
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy