118

Hive DDL Commands

Create Database Statement

A database in Hive is a namespace or a collection of tables.

Drop database

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