Hive
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 :…
Hive Sort By vs Order By
Hive sort by and order by commands are used to fetch data in sorted order. The main differences between sort by and order by commands…
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;
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…
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…
HIVE Data Types
Hive data types are categorized in numeric types, string types, misc types and complex types. A list of Hive data types are given below. Numeric…
HIVE Installation
Step 1: The JAVA and Hadoop must be preinstalled on your system. Step 2: For Hive Download Hive from http://apache.petsads.us/hive/hive-0.14.0/. It gets downloaded in /user/download…
What is HIVE
Hive is a data ware house system for Hadoop. It runs SQL like queries called HQL (Hive query language) which gets internally converted to map…
Hive Tutorial
Hive tutorial provides basic and advanced concepts of Hive. Our Hive tutorial is designed for beginners and professionals. Apache Hive is a data ware house…