Using Hive – creating a database

Hive is one of the languages used in Hadoop to interact with large volumes of data. It is very easy to learn since it uses SQL commands. This recipe will show you how we can use Hive to transform data from our source. Although we have only 542 lines of data in our file, we can still use it to learn Hadoop services calls.

In this recipe, we're going to create a database in Hive.

Getting ready

This recipe assumes that you have access to a Hortonworks sandbox on-premises or in Azure. It is also assumed that you have executed the previous recipe.

How to do it...

1. Open Ambari and navigate to http://Sandbox.Hortonworks.com:8080. Use raj_ops for both the username and password to log in.
2. Click on the more icon (nine-squares button near raj_ops) in the toolbar and select Hive View 2.0, as shown in the following screenshot:

3. Type create database SSISCookBook in Worksheet1 and click on Execute, as shown in the following screenshot:

4. Refresh your browser and click on Browse...