DESCRIBE statement allows you to print a metadata information for the specified database object.
Syntax:
DESCRIBE | DESC [TABLE] table_name
Example:
Describe src table in Hive:
desc src; -- key string default value string default
Compatibility: Oracle, IBM DB2, Hive, MySQL, MariaDB.
Version: HPL/SQL 0.3.17