Hive Validation

Step 1 : Invoke Hive shell

hive

Step 2 : Create a Database

hive> CREATE DATABASE userdb;

Step 3 : Verify an existing Databases

hive> SHOW DATABASES;

Step 4 : Drop Database

hive> DROP DATABASE userdb;

Step 5 : Create Table

hive> CREATE EXTERNAL TABLE EMPLOYEE (EID String, NAME String, SALARY String,Designation String) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;

Verify the tables has been created

hive> SHOW TABLES;