tencent cloud

Data Lake Compute

Release Notes
Product Introduction
Overview
Strengths
Use Cases
Purchase Guide
Billing Overview
Refund
Payment Overdue
Configuration Adjustment Fees
Getting Started
Complete Process for New User Activation
DLC Data Import Guide
Quick Start with Data Analytics in Data Lake Compute
Quick Start with Permission Management in Data Lake Compute
Quick Start with Partition Table
Enabling Data Optimization
Cross-Source Analysis of EMR Hive Data
Standard Engine Configuration Guide
Configuring Data Access Policy
Operation Guide
Console Operation Introduction
Development Guide
Runtime Environment
SparkJar Job Development Guide
PySpark Job Development Guide
Query Performance Optimization Guide
UDF Function Development Guide
System Restraints
Client Access
JDBC Access
TDLC Command Line Interface Tool Access
Third-party Software Linkage
Python Access
Practical Tutorial
Accessing DLC Data with Power BI
Table Creation Practice
Using Apache Airflow to Schedule DLC Engine to Submit Tasks
Direct Query of DLC Internal Storage with StarRocks
Spark cost optimization practice
DATA + AI
Using DLC to Analyze CLS Logs
Using Role SSO to Access DLC
Resource-Level Authentication Guide
Implementing Tencent Cloud TCHouse-D Read and Write Operations in DLC
DLC Native Table
SQL Statement
SuperSQL Statement
Overview of Standard Spark Statement
Overview of Standard Presto Statement
Reserved Words
API Documentation
History
Introduction
API Category
Making API Requests
Data Table APIs
Task APIs
Metadata APIs
Service Configuration APIs
Permission Management APIs
Database APIs
Data Source Connection APIs
Data Optimization APIs
Data Engine APIs
Resource Group for the Standard Engine APIs
Data Types
Error Codes
General Reference
Error Codes
Quotas and limits
Operation Guide on Connecting Third-Party Software to DLC
FAQs
FAQs on Permissions
FAQs on Engines
FAQs on Features
FAQs on Spark Jobs
DLC Policy
Privacy Policy
Data Privacy And Security Agreement
Service Level Agreement
Contact Us
DocumentationData Lake ComputeGeneral ReferenceQuotas and limits

Quotas and limits

PDF
Focus Mode
Font Size
Last updated: 2024-07-23 14:11:48

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 .

Previous Topic: Error CodesNext Topic: Connecting CBoard to DLC

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback