Apache Hive Cookbook

Using a database schema

In this recipe, you will learn how to use a database in Hive.

Getting ready

The USE DATABASE command is used to switch to the database, or it sets the database as the working database. It is analogous to the one used in the other RDBMS. The general format of using a database is as follows:

USE (DATABASE|SCHEMA) database_name;

Where:

DATABASE|SCHEMA: These are the same thing. These words can be used interchangeably.

How to do it…

The following command sets the database as the working database:

Use database Hive_learning;