DESCRIBE TABLE
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 tableExample
DESCRIBE tbl;DESCRIBE FORMATTED tbl PARTITION (date_id = '2019-01-07');
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback