DESCRIBE TABLE
DESCRIBE | DESC [CATALOG identifier]? [INCLUDE FROZEN]? [table_identifier | LIKE pattern]- Catalog (cluster) identifier. Supports wildcards (
*). - Whether or not to include frozen indices.
- Single table (index or data stream) identifier or double-quoted multi-target pattern.
- SQL LIKE pattern matching table names.
Description:DESC andDESCRIBE are aliases toSHOW COLUMNS.
DESCRIBE emp; column | type | mapping--------------------+---------------+---------------birth_date |TIMESTAMP |datetimedep |STRUCT |nesteddep.dep_id |VARCHAR |keyworddep.dep_name |VARCHAR |textdep.dep_name.keyword|VARCHAR |keyworddep.from_date |TIMESTAMP |datetimedep.to_date |TIMESTAMP |datetimeemp_no |INTEGER |integerfirst_name |VARCHAR |textfirst_name.keyword |VARCHAR |keywordgender |VARCHAR |keywordhire_date |TIMESTAMP |datetimelanguages |TINYINT |bytelast_name |VARCHAR |textlast_name.keyword |VARCHAR |keywordname |VARCHAR |keywordsalary |INTEGER |integer