- Product Introduction
- Purchase Guide
- 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
- Operation Guide
- Data Exploration
- Data Management
- Data Job
- Task History
- Insight Management
- Engine Management
- Data Engine Introduction
- SuperSQL Engine
- SuperSQL Engine Overview
- Purchasing Private Data Engine
- Renewing SuperSQL Engine
- Managing Private Data Engine
- Engine-Level Parameter Settings
- Disaster Recovery Cluster
- Engine Kernel Version
- Engine Network Configuration
- Associating Tag with Private Engine Resource
- Engine Local Cache
- Custom Task Scheduling Pool
- Standard Engine
- Ops Management
- Query Script Management
- Development Guide
- Client Access
- Practical Tutorial
- SQL Statement
- SuperSQL Statement
- Overview of SuperSQL Statement
- Unified Statement
- Common Data Types
- DDL Statement
- CREATE DATABASE
- SHOW DATABASES
- DESCRIBE DATABASE
- ALTER DATABASE
- DROP DATABASE
- CREATE TABLE
- REPLACE TABLE AS SELECT
- SHOW TABLES
- SHOW CREATE TABLE
- SHOW TBLPROPERTIES
- DESCRIBE TABLE
- SHOW COLUMNS IN TABLE
- ALTER TABLE
- ALTER TABLE ADD COLUMNS
- ALTER TABLE ADD COLUMN AFTER/FIRST
- ALTER TABLE DROP COLUMN
- ALTER TABLE ADD PARTATION
- SHOW PARTITIONS
- ALTER TABLE DROP PARTITION
- ALTER TABLE ADD PARTITION FIELD
- ALTER TABLE DROP PARTITION FIELD
- ALTER TABLE ... RENAME COLUMN
- ALTER TABLE SET TBLPROPERTIES
- ALTER TABLE SET LOCATION
- ALTER TABLE ... WRITE ORDERED BY
- ALTER TABLE ... WRITE DISTRIBUTED BY PARTITION
- ALTER TABLE ... SET IDENTIFIER FIELDS
- ALTER TABLE ... DROP IDENTIFIER FIELDS
- MSCK REPAIR TABLE
- ANALYZE TABLES
- DROP TABLE
- EXPLAIN
- CALL STATEMENT
- CREATE VIEW AS
- SHOW VIEWS
- DESCRIBE VIEW
- SHOW CREATE VIEW
- SHOW COLUMNS IN VIEW
- ALTER VIEW
- DROP VIEW
- CREATE FUNCTION
- SHOW FUNCTION
- DROP FUNCTION
- DML Statement
- DQL Statement
- Iceberg Table Statement
- Materialized View Statement
- SQL Implicit Conversion
- Functions
- Overview of Standard Spark Statement
- Overview of Standard Presto Statement
- Reserved Words
- SuperSQL Statement
- API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Data Table APIs
- Task APIs
- CreateSparkSessionBatchSQL
- CancelSparkSessionBatchSQL
- CancelTask
- CreateResultDownload
- CreateSparkAppTask
- CreateTask
- CreateTasks
- DeleteSparkApp
- DescribeEngineUsageInfo
- DescribeResultDownload
- DescribeSparkAppTasks
- DescribeTaskResult
- DescribeTasks
- QueryTaskCostDetail
- CreateSparkApp
- DescribeSparkAppJob
- DescribeSparkSessionBatchSqlLog
- ModifySparkApp
- DescribeSparkAppJobs
- ModifySparkAppBatch
- DescribeTaskStatistics
- DescribeQuery
- DescribeJobs
- DescribeJob
- Metadata APIs
- Service Configuration APIs
- CreateCHDFSBindingProduct
- DeleteCHDFSBindingProduct
- DescribeOtherCHDFSBindingList
- CreateStoreLocation
- DescribeStoreLocation
- ModifyDataEngineDescription
- RollbackDataEngineImage
- SwitchDataEngine
- SwitchDataEngineImage
- UpgradeDataEngineImage
- DeleteThirdPartyAccessUser
- DescribeDataEngineImageVersions
- DescribeSubUserAccessPolicy
- DescribeThirdPartyAccessUser
- RegisterThirdPartyAccessUser
- RestartDataEngine
- UpdateUserDataEngineConfig
- UpdateDataEngineConfig
- Permission Management APIs
- AddUsersToWorkGroup
- AttachUserPolicy
- AttachWorkGroupPolicy
- BindWorkGroupsToUser
- CreateUser
- CreateWorkGroup
- DeleteUser
- DeleteUsersFromWorkGroup
- DeleteWorkGroup
- DescribeUserInfo
- DescribeUserRoles
- DescribeUserType
- DescribeUsers
- DescribeWorkGroupInfo
- DescribeWorkGroups
- DetachUserPolicy
- DetachWorkGroupPolicy
- ModifyUser
- ModifyUserType
- ModifyWorkGroup
- UnbindWorkGroupsFromUser
- UpdateRowFilter
- CheckGrantedPermission
- Database APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- Data Types
- Error Codes
- General Reference
- DLC Policy
- Service Level Agreement
- Contact Us
- Product Introduction
- Purchase Guide
- 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
- Operation Guide
- Data Exploration
- Data Management
- Data Job
- Task History
- Insight Management
- Engine Management
- Data Engine Introduction
- SuperSQL Engine
- SuperSQL Engine Overview
- Purchasing Private Data Engine
- Renewing SuperSQL Engine
- Managing Private Data Engine
- Engine-Level Parameter Settings
- Disaster Recovery Cluster
- Engine Kernel Version
- Engine Network Configuration
- Associating Tag with Private Engine Resource
- Engine Local Cache
- Custom Task Scheduling Pool
- Standard Engine
- Ops Management
- Query Script Management
- Development Guide
- Client Access
- Practical Tutorial
- SQL Statement
- SuperSQL Statement
- Overview of SuperSQL Statement
- Unified Statement
- Common Data Types
- DDL Statement
- CREATE DATABASE
- SHOW DATABASES
- DESCRIBE DATABASE
- ALTER DATABASE
- DROP DATABASE
- CREATE TABLE
- REPLACE TABLE AS SELECT
- SHOW TABLES
- SHOW CREATE TABLE
- SHOW TBLPROPERTIES
- DESCRIBE TABLE
- SHOW COLUMNS IN TABLE
- ALTER TABLE
- ALTER TABLE ADD COLUMNS
- ALTER TABLE ADD COLUMN AFTER/FIRST
- ALTER TABLE DROP COLUMN
- ALTER TABLE ADD PARTATION
- SHOW PARTITIONS
- ALTER TABLE DROP PARTITION
- ALTER TABLE ADD PARTITION FIELD
- ALTER TABLE DROP PARTITION FIELD
- ALTER TABLE ... RENAME COLUMN
- ALTER TABLE SET TBLPROPERTIES
- ALTER TABLE SET LOCATION
- ALTER TABLE ... WRITE ORDERED BY
- ALTER TABLE ... WRITE DISTRIBUTED BY PARTITION
- ALTER TABLE ... SET IDENTIFIER FIELDS
- ALTER TABLE ... DROP IDENTIFIER FIELDS
- MSCK REPAIR TABLE
- ANALYZE TABLES
- DROP TABLE
- EXPLAIN
- CALL STATEMENT
- CREATE VIEW AS
- SHOW VIEWS
- DESCRIBE VIEW
- SHOW CREATE VIEW
- SHOW COLUMNS IN VIEW
- ALTER VIEW
- DROP VIEW
- CREATE FUNCTION
- SHOW FUNCTION
- DROP FUNCTION
- DML Statement
- DQL Statement
- Iceberg Table Statement
- Materialized View Statement
- SQL Implicit Conversion
- Functions
- Overview of Standard Spark Statement
- Overview of Standard Presto Statement
- Reserved Words
- SuperSQL Statement
- API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Data Table APIs
- Task APIs
- CreateSparkSessionBatchSQL
- CancelSparkSessionBatchSQL
- CancelTask
- CreateResultDownload
- CreateSparkAppTask
- CreateTask
- CreateTasks
- DeleteSparkApp
- DescribeEngineUsageInfo
- DescribeResultDownload
- DescribeSparkAppTasks
- DescribeTaskResult
- DescribeTasks
- QueryTaskCostDetail
- CreateSparkApp
- DescribeSparkAppJob
- DescribeSparkSessionBatchSqlLog
- ModifySparkApp
- DescribeSparkAppJobs
- ModifySparkAppBatch
- DescribeTaskStatistics
- DescribeQuery
- DescribeJobs
- DescribeJob
- Metadata APIs
- Service Configuration APIs
- CreateCHDFSBindingProduct
- DeleteCHDFSBindingProduct
- DescribeOtherCHDFSBindingList
- CreateStoreLocation
- DescribeStoreLocation
- ModifyDataEngineDescription
- RollbackDataEngineImage
- SwitchDataEngine
- SwitchDataEngineImage
- UpgradeDataEngineImage
- DeleteThirdPartyAccessUser
- DescribeDataEngineImageVersions
- DescribeSubUserAccessPolicy
- DescribeThirdPartyAccessUser
- RegisterThirdPartyAccessUser
- RestartDataEngine
- UpdateUserDataEngineConfig
- UpdateDataEngineConfig
- Permission Management APIs
- AddUsersToWorkGroup
- AttachUserPolicy
- AttachWorkGroupPolicy
- BindWorkGroupsToUser
- CreateUser
- CreateWorkGroup
- DeleteUser
- DeleteUsersFromWorkGroup
- DeleteWorkGroup
- DescribeUserInfo
- DescribeUserRoles
- DescribeUserType
- DescribeUsers
- DescribeWorkGroupInfo
- DescribeWorkGroups
- DetachUserPolicy
- DetachWorkGroupPolicy
- ModifyUser
- ModifyUserType
- ModifyWorkGroup
- UnbindWorkGroupsFromUser
- UpdateRowFilter
- CheckGrantedPermission
- Database APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- Data Types
- Error Codes
- General Reference
- DLC Policy
- Service Level Agreement
- Contact Us
1. API Description
Domain name for API request: dlc.tencentcloudapi.com.
This API is used to create a table.
A maximum of 20 requests can be initiated per second for this API.
We recommend you to use API Explorer
Try it
API Explorer provides a range of capabilities, including online call, signature authentication, SDK code generation, and API quick search. It enables you to view the request, response, and auto-generated examples.
2. Input Parameters
The following request parameter list only provides API request parameters and some common parameters. For the complete common parameter list, see Common Request Parameters.
| Parameter Name | Required | Type | Description |
|---|---|---|---|
| Action | Yes | String | Common Params. The value used for this API: CreateDLCTable. |
| Version | Yes | String | Common Params. The value used for this API: 2021-01-25. |
| Region | Yes | String | Common Params. For more information, please see the list of regions supported by the product. |
| TableBaseInfo | Yes | TableBaseInfo | Data table configuration information |
| TableType | Yes | String | Table type |
| Columns.N | No | Array of TColumn | Data table column information |
| Partitions.N | No | Array of TPartition | Data table partition information |
| Properties.N | No | Array of Property | Data table attribute information |
| ExternalDataConfiguration | No | ExternalDataConfiguration | External table configuration information |
| DataEngineName | No | String | Engine name |
| ResourceGroupname | No | String | Resource group name |
3. Output Parameters
| Parameter Name | Type | Description |
|---|---|---|
| DLCTable | DLCTable | DLC table information object Note: This field may return null, indicating that no valid values can be obtained. |
| Execution | String | The SQL statement for creating a managed storage internal table |
| RequestId | String | The unique request ID, generated by the server, will be returned for every request (if the request fails to reach the server for other reasons, the request will not obtain a RequestId). RequestId is required for locating a problem. |
4. Example
Example1 Creating a Table
Input Example
POST / HTTP/1.1
Host: dlc.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: CreateDLCTable
{
"TableBaseInfo": {
"DatabaseName": "abc",
"TableName": "abc",
"DatasourceConnectionName": "abc",
"TableComment": "abc",
"Type": "abc",
"TableFormat": "abc",
"UserAlias": "abc",
"UserSubUin": "abc",
"GovernPolicy": {
"RuleType": "abc",
"GovernEngine": "abc"
},
"DbGovernPolicyIsDisable": "abc",
"SmartPolicy": {
"BaseInfo": {
"Uin": "abc",
"PolicyType": "abc",
"Catalog": "abc",
"Database": "abc",
"Table": "abc",
"AppId": "abc"
},
"Policy": {
"Inherit": "abc",
"Resources": [
{
"AttributionType": "abc",
"ResourceType": "abc",
"Name": "abc",
"Instance": "abc",
"Favor": [
{
"Priority": 0,
"Catalog": "abc",
"DataBase": "abc",
"Table": "abc"
}
],
"Status": 0
}
],
"Written": {
"WrittenEnable": "abc"
},
"Lifecycle": {
"LifecycleEnable": "abc",
"Expiration": 0,
"DropTable": true,
"ExpiredField": "abc",
"ExpiredFieldFormat": "abc"
},
"Index": {
"IndexEnable": "abc"
}
}
}
},
"TableType": "abc",
"Columns": [
{
"Name": "abc",
"Type": "abc",
"Comment": "abc",
"Default": "abc",
"NotNull": true,
"Precision": 0,
"Scale": 0
}
],
"Partitions": [
{
"Name": "abc",
"Type": "abc",
"Comment": "abc",
"PartitionType": "abc",
"PartitionFormat": "abc",
"PartitionDot": 0,
"Transform": "abc",
"TransformArgs": [
"abc"
]
}
],
"Properties": [
{
"Key": "abc",
"Value": "abc"
}
],
"ExternalDataConfiguration": {
"Sds": {
"Location": "abc",
"InputFormat": "abc",
"OutputFormat": "abc",
"NumBuckets": 0,
"Compressed": true,
"StoredAsSubDirectories": true,
"SerdeLib": "abc",
"SerdeName": "abc",
"BucketCols": [
"abc"
],
"SerdeParams": [
{
"Key": "abc",
"Value": "abc"
}
],
"Params": [
{
"Key": "abc",
"Value": "abc"
}
],
"SortCols": {
"Col": "abc",
"Order": 0
},
"Cols": [
{
"Name": "abc",
"Description": "abc",
"Type": "abc",
"Position": 0,
"Params": [
{
"Key": "abc",
"Value": "abc"
}
],
"IsPartition": true
}
],
"SortColumns": [
{
"Col": "abc",
"Order": 0
}
]
},
"ViewOriginalText": "abc",
"ViewExpandedText": "abc",
"Retention": 0,
"LifeTime": 0,
"Partitions": [
{
"DatabaseName": "abc",
"SchemaName": "abc",
"TableName": "abc",
"DataVersion": 0,
"Name": "abc",
"Values": [
"abc"
],
"StorageSize": 0,
"RecordCount": 0,
"CreateTime": "2020-09-22T00:00:00+00:00",
"ModifiedTime": "2020-09-22T00:00:00+00:00",
"LastAccessTime": "2020-09-22T00:00:00+00:00",
"Sds": {
"Location": "abc",
"InputFormat": "abc",
"OutputFormat": "abc",
"NumBuckets": 0,
"Compressed": true,
"StoredAsSubDirectories": true,
"SerdeLib": "abc",
"SerdeName": "abc",
"BucketCols": [
"abc"
],
"SortCols": {
"Col": "abc",
"Order": 0
},
"Cols": [
{
"Name": "abc",
"Description": "abc",
"Type": "abc",
"Position": 0,
"IsPartition": true
}
]
}
}
]
},
"DataEngineName": "abc",
"ResourceGroupname": "abc"
}
Output Example
{
"Response": {
"DLCTable": {
"TableBaseInfo": {
"DatabaseName": "abc",
"TableName": "abc",
"DatasourceConnectionName": "abc",
"TableComment": "abc",
"Type": "abc",
"TableFormat": "abc",
"UserAlias": "abc",
"UserSubUin": "abc",
"GovernPolicy": {
"RuleType": "abc",
"GovernEngine": "abc"
},
"DbGovernPolicyIsDisable": "abc",
"SmartPolicy": {
"BaseInfo": {
"Uin": "abc",
"PolicyType": "abc",
"Catalog": "abc",
"Database": "abc",
"Table": "abc",
"AppId": "abc"
},
"Policy": {
"Inherit": "abc",
"Resources": [
{
"AttributionType": "abc",
"ResourceType": "abc",
"Name": "abc",
"Instance": "abc",
"Favor": [
{
"Priority": 0,
"Catalog": "abc",
"DataBase": "abc",
"Table": "abc"
}
],
"Status": 0
}
],
"Written": {
"WrittenEnable": "abc"
},
"Lifecycle": {
"LifecycleEnable": "abc",
"Expiration": 0,
"DropTable": true,
"ExpiredField": "abc",
"ExpiredFieldFormat": "abc"
},
"Index": {
"IndexEnable": "abc"
}
}
}
},
"Columns": [
{
"Name": "abc",
"Type": "abc",
"Comment": "abc",
"Default": "abc",
"NotNull": true,
"Precision": 0,
"Scale": 0,
"Position": 0,
"IsPartition": true
}
],
"Partitions": [
{
"Name": "abc",
"Type": "abc",
"Comment": "abc",
"PartitionType": "abc",
"PartitionFormat": "abc",
"PartitionDot": 0,
"Transform": "abc",
"TransformArgs": [
"abc"
]
}
],
"Location": "abc",
"Properties": [
{
"Key": "abc",
"Value": "abc"
}
],
"ModifiedTime": "abc",
"CreateTime": "abc",
"InputFormat": "abc",
"StorageSize": 0,
"RecordCount": 0,
"MapMaterializedViewName": "abc",
"HeatValue": 0,
"ExternalDataConfiguration": {
"Sds": {
"Location": "abc",
"InputFormat": "abc",
"OutputFormat": "abc",
"NumBuckets": 0,
"Compressed": true,
"StoredAsSubDirectories": true,
"SerdeLib": "abc",
"SerdeName": "abc",
"Params": [],
"SerdeParams": [],
"SortColumns": [],
"BucketCols": [
"abc"
],
"SortCols": {
"Col": "abc",
"Order": 0
},
"Cols": [
{
"Name": "abc",
"Description": "abc",
"Type": "abc",
"Position": 0,
"IsPartition": true
}
]
},
"ViewOriginalText": "abc",
"ViewExpandedText": "abc",
"Retention": 0,
"LifeTime": 0,
"Partitions": [
{
"DatabaseName": "abc",
"SchemaName": "abc",
"TableName": "abc",
"DataVersion": 0,
"Name": "abc",
"Params": [],
"Values": [
"abc"
],
"StorageSize": 0,
"RecordCount": 0,
"CreateTime": "2020-09-22T00:00:00+00:00",
"ModifiedTime": "2020-09-22T00:00:00+00:00",
"LastAccessTime": "2020-09-22T00:00:00+00:00",
"Sds": {
"Location": "abc",
"InputFormat": "abc",
"OutputFormat": "abc",
"NumBuckets": 0,
"Compressed": true,
"StoredAsSubDirectories": true,
"SerdeLib": "abc",
"SerdeName": "abc",
"Params": [],
"SerdeParams": [],
"SortColumns": [],
"BucketCols": [
"abc"
],
"SortCols": {
"Col": "abc",
"Order": 0
},
"Cols": [
{
"Name": "abc",
"Description": "abc",
"Type": "abc",
"Position": 0,
"IsPartition": true
}
]
}
}
]
}
},
"Execution": "create table `table1` ()",
"RequestId": "abc"
}
}
5. Developer Resources
SDK
TencentCloud API 3.0 integrates SDKs that support various programming languages to make it easier for you to call APIs.
- Tencent Cloud SDK 3.0 for Python
- Tencent Cloud SDK 3.0 for Java
- Tencent Cloud SDK 3.0 for PHP
- Tencent Cloud SDK 3.0 for Go
- Tencent Cloud SDK 3.0 for Node.js
- Tencent Cloud SDK 3.0 for .NET
- Tencent Cloud SDK 3.0 for C++
Command Line Interface
6. Error Code
The following only lists the error codes related to the API business logic. For other error codes, see Common Error Codes.
| Error Code | Description |
|---|---|
| InternalError | An internal error occurred. |
| InvalidParameter | The parameter is incorrect. |
| ResourceNotFound | The resource does not exist. |
| UnauthorizedOperation | Unauthorized operation. |
Yes
No
Was this page helpful?