Hive DDL Commands Create Database Statement A database in Hive is a namespace or a collection of tables. hive> CREATE SCHEMA userdb;…
Tag:
hive
-
-
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…
-
Partitioning in Hive The partitioning in Hive means dividing the table into some parts based on the values of a particular column…
-
Hive – Create Table In Hive, we can create a table by using the conventions similar to the SQL. It supports a…
-
What is HIVE Hive is a data warehouse system which is used to analyze structured data. It is built on the top…
Newer Posts