Hive DDL Commands Create Database Statement A database in Hive is a namespace or a collection of tables. hive> CREATE SCHEMA userdb;…
Tag:
mapreduce
-
-
Hive DML Commands To understand the Hive DML commands, let’s see the employee and employee_department table first. LOAD DATA hive> LOAD DATA…
-
Hive Join Let’s see two tables Employee and EmployeeDepartment that are going to be joined. Inner joins Select * from employee join…
-
Hive Commands Hive supports Data definition Language(DDL), Data Manipulation Language(DML) and User defined functions. Hive DDL Commands create database drop database create…
-
Hive Sort By vs Order By Hive sort by and order by commands are used to fetch data in sorted order. The…
-
HIVE Partitioning Table partitioning means dividing table into some parts based on values of a particular column like date or country, segregate…
-
Apache Hive Installation In this section, we will perform the Hive installation. Pre-requisite Java Installation – Check whether the Java is installed…
-
Apache Pig Installation In this section, we will perform the pig installation. Pre-requisite Java Installation – Check whether the Java is installed…
-
HIVE Data Types Hive data types are categorized in numeric types, string types, misc types, and complex types. A list of Hive…
-
Apache Pig Run Modes Apache Pig executes in two modes: Local Mode and MapReduce Mode. Local Mode It executes in a single…
Newer Posts