Just type the following in the Hive Shell:

hive> create database <your database name>
> location < '/complete path of the folder you want to save your database' > ;

use the command "show databases; " to verify that your database has been created.

=) Happy learning fellows!

Hi Shakeel
I am unable to ssh into systemt.datascientistworkbench.com.
Can you please help/ suggest how I can, it is unable to reach the host.

I have found its solution:
By Default hive uses /apps/hive/warehouse for LOCATION

First you need to create a directory in HDFS e.g:
/user/yourusername/hive/warehouse

Now in order to create database your command must be look like:
hive> Create database yourdatabasename
> Location '/user/yourusername/hive/warehouse'

OK
Time taken: 0.025 seconds
So in order to verify submit below:

hive> show databases;

Good luck!

try this :
beeline -u jdbc:hive2://iop-bi-master:10000/default -n hadoop

Me too, we need the Admin team to help us out ..

Anyone can you please help...

Me too :(