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;
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.
