Hive DDL Commands
Create Database Statement
A database in Hive is a namespace or a collection of tables.
Creating Hive Tables
Create a table called Tutoraspire with two columns, the first being an integer and the other a string.
Create a table called HIVE_TABLE with two columns and a partition column called ds. The partition column is a virtual column. It is not part of the data itself but is derived from the partition that a particular dataset is loaded into.By default, tables are assumed to be of text input format and the delimiters are assumed to be ^A(ctrl-a).
Browse the table
Altering and Dropping Tables