Describing a database schema

In this recipe, you will learn how to describe databases in Hive.

Getting ready

The DESCRIBE DATABASE command is used to get information about the database, such as the name of the database, its comment (if attached during the creation of the database), its location on the filesystem, and its dbproperties. The general format of using the DESCRIBE DATABASE command is as follows:

DESCRIBE DATABASE [EXTENDED] db_name;
DESCRIBE SCHEMA [EXTENDED] db_name;

Where:

  • DATABASE|SCHEMA: These are the same thing. These words can be used interchangeably.
  • [EXTENDED]: This is an optional clause. This clause will list all the dbproperties attached to a particular database in Hive.

How to do it…

Follow these steps to describe a database in ...

Get Apache Hive Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial