Updated on 2022-11-18 GMT+08:00

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)