spark

Hive DDL Commands Create Database Statement A database in Hive is a namespace or a collection of tables. hive> CREATE SCHEMA userdb;…

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…

Hive Tutorial Hive tutorial provides basic and advanced concepts of Hive. Our Hive tutorial is designed for beginners and professionals. Apache Hive…

Sqoop Where You can place restrictions on data imported by using “where” clause. Let’s import cityByCountry table where state ( 6th column…

What is Big Data Data which are very large in size is called Big Data. Normally we work on data of size…