Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

Hive DML Commands


To understand the Hive DML commands, let’s see the employee and employee_department table first.

Employee_Department_table

LOAD DATA

  1. hive> LOAD DATA LOCAL INPATH ‘./usr/Desktop/kv1.txt’ OVERWRITE INTO TABLE Employee;

SELECTS and FILTERS

  1. hive> SELECT  E.EMP_ID FROM Employee E  WHERE E.Address=‘US’;

GROUP BY

  1. hive> hive> SELECT  E.EMP_ID FROM Employee E GROUP BY E.Addresss;

Comments

comments