Showing database schemas
In this recipe, you will learn how to show databases in Hive.
Getting ready
The SHOW DATABASE
command is used to list all the databases in the Hive metastore. The general format of using the SHOW DATABASE
command is as follows:
SHOW (DATABASES|SCHEMAS) [LIKE identifier_with_wildcards];
Where:
DATABASE|SCHEMA
: These are the same thing. These words can be used interchangeably.[LIKE]
: Is an optional clause. This clause is used to filter the databases with the help of a regular expression. There can only be two wildcards in the regular expression, which are*
for any character(s) or|
for a choice.
How to do it…
Follow these steps to show a database in Hive:
- The following command lists all the databases in Hive:
Show databases; ...
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.