Big Data Analytics with Hadoop 3
上QQ阅读APP看书,第一时间看更新

Creating a database

We first have to create a database to hold all the tables created in Hive. This step is easy and similar to most other databases:

create database mydb;

The following is the hive console showing the query execution:

We then begin using the database we just created to create the tables required by our database as follows:

use mydb;

The following is the hive console showing the query execution: