Hive


Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages
Hadoop

Hive Join

Let’s see two tables Employee and EmployeeDepartment that are going to be joined. Inner joins Select  *  from employee join employeedepartment  ON (employee.empid=employeedepartment.empId) Output : <<InnerJoin.png>> Left outer joins Select e.empId, empName, department from employee e Left outer join employeedepartment ed on(e.empId=ed.empId); Output :…

Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages
Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages
Hadoop

Hive DML Commands

To understand the Hive DML commands, let’s see the employee and employee_department table first. LOAD DATA hive> LOAD DATA LOCAL INPATH ‘./usr/Desktop/kv1.txt’ OVERWRITE INTO TABLE Employee; SELECTS and FILTERS hive> SELECT  E.EMP_ID FROM Employee E  WHERE E.Address=‘US’; GROUP BY hive> hive> SELECT  E.EMP_ID FROM Employee E GROUP BY E.Addresss;

Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages
Hadoop

Hive DDL Commands

Create Database Statement A database in Hive is a namespace or a collection of tables. hive> CREATE SCHEMA userdb; hive> SHOW DATABASES; Drop database hive> DROP DATABASE IF EXISTS userdb; Creating Hive Tables Create a…

Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages
Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages
Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages
Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages
Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages