Loading
SHOW COLUMNS
SHOW COLUMNS [CATALOG identifier]? [INCLUDE FROZEN]? [FROM | IN] [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.
Seeindex patterns for more information about patterns.
Description: List the columns in table and their data type (and other attributes).
SHOW COLUMNS IN 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