104

Hive Commands

Hive supports Data definition Language(DDL), Data Manipulation Language(DML) and User defined functions.

Hive DDL Commands

create database

drop database

create table

drop table

alter table

create index

create views

Hive DML Commands

Select

Where

Group By

Order By

Load Data

Join:

• Inner Join
• Left Outer Join
• Right Outer Join
• Full Outer Join