DESCRIBE DATABASE| SCHEMA
Syntax
DESCRIBE DATABASE|SCHEMA [EXTENDED] schema_name
Description
DATABASE and SCHEMA are equivalent and interchangeable. They have the same meaning.
This statement is used to display the name, comment, and root path of a schema on the file system.
The option EXTENDED can be used to display the database attributes of the schema.
Example
CREATE SCHEMA web; DESCRIBE SCHEMA web; Describe Schema ------------------------------------------------------------------------- web hdfs://hacluster/user/hive/warehouse/web.db admintest USER (1 row)
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.