Hive

Load data with local file and hdfs

load data into partitioned tables

load data form another table 

check for charset

UDFs using python and java.

Hive 

hiveserver1

hiveserver2

beeline (!help, !scan, !connect)

metastore  - embeded, local, remote

----

Managed Table 

External Table

-----

Partitions (Static & Dynamic).