Hive – Introduction

Hive Tutorials

The term ‘Big Data’ is used for collections of large datasets that include huge volume, high velocity, and a variety of data that is increasing …

Read More ➜

Hive – Installation

Hive Tutorials

All Hadoop sub-projects such as Hive, Pig, and HBase support Linux operating system. Therefore, you need to install any Linux flavored OS. The following simple …

Read More ➜

Hive – Data Types

Hive Tutorials

All the data types in Hive are classified into four types, given as follows: Column Types Literals Null Values Complex Types Column Types Column type …

Read More ➜

Hive – Create Database

Hive Tutorials

Hive is a database technology that can define databases and tables to analyze structured data. The theme for structured data analysis is to store the …

Read More ➜

Hive – Drop Database

Hive Tutorials

The usage of SCHEMA and DATABASE are same. Drop Database Statement Drop Database is a statement that drops all the tables and deletes the database. …

Read More ➜

Hive – Create Table

Hive Tutorials

The conventions of creating a table in HIVE is quite similar to creating a table using SQL. Create Table Statement Create Table is a statement …

Read More ➜

Hive – Alter Table

Hive Tutorials

Alter Table Statement It is used to alter a table in Hive. Syntax The statement takes any of the following syntaxes based on what attributes …

Read More ➜

Hive – Drop Table

Hive Tutorials

When you drop a table from Hive Metastore, it removes the table/column data and their metadata. It can be a normal table (stored in Metastore) …

Read More ➜