Describe Table

DESCRIBE [EXTENDED] [db_name.]table_name

Return the metadata of an existing table (column names, data types, and comments). If the table does not exist, an exception will be thrown.

EXTENDED
Display detailed information about the table, including parent database, table type, storage information, and properties.

Describe Partition

DESCRIBE [EXTENDED] [db_name.]table_name PARTITION partition_spec

Return the metadata of a specified partition. The partition_spec must provide the values for all the partition columns.

EXTENDED
Display basic information about the table and the partition-specific storage information.

Describe Columns

New in version runtime-3.3.

DESCRIBE [EXTENDED] [db_name.]table_name column_name

Return the metadata of a specified column.

EXTENDED
Display detailed information about the specified columns, including the column statistics collected by the command ANALYZE TABLE table_name COMPUTE STATISTICS FOR COLUMNS column_name [column_name, ...].