tencent cloud

Data Lake Compute

DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementDESCRIBE TABLE

DESCRIBE TABLE

Download
Focus Mode
Font Size
Last updated: 2024-08-07 17:13:35

Description

Supported engines: Presto and SparkSQL
Applicable table: Native and external tables
Purpose: View column information and metadata information on the data table.

Standard Statement

DESCRIBE [EXTENDED | FORMATTED] [db_name.]table_name [PARTITION partition_spec];

Parameter

[EXTENDED | FORMATTED]: Specify the format of the table.
table_name: Table name
[PARTITION partition_spec]: List of partitions in the table

Example

DESCRIBE tbl;
DESCRIBE FORMATTED tbl PARTITION (date_id = '2019-01-07');


Previous Topic: SHOW TBLPROPERTIESNext Topic: SHOW COLUMNS IN TABLE

Help and Support

Was this page helpful?

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

Feedback