Section 6:53. Creating the Database in Hive and switching to Database

To create a database in Hive and switch to it, you can use the following commands:

  1. Creating a database:

CREATE DATABASE database_name;

Replace database_name with the name you want to give your database. This command will create a new database in Hive.

  1. Switching to a database:

USE database_name;

Replace database_name with the name of the database you want to switch to. This command will set the specified database as the current database in Hive.

Once you have switched to a database, any subsequent Hive commands you run will be executed in the context of that database. For example, if you run the command SHOW TABLES; after switching to a database, you will see a list of tables that belong to that database.

Share this post