Table of Contents

About the Tutorial ···· i

Audience ··· i

Prerequisites ··· i

Disclaimer & Copyright ··· i

Table of Contents ···· ii

1. INTRODUCTION ································ ····· 1

Hadoop ···· 1

What is Hive? ···· 2

Features of Hive ··· 2

Architecture of Hive ··· 2

Working of Hive ··· 4

2. HIVE INSTALLATION ································ ····· 6

Step 1: Verifying JAVA Installation ····· 6

Step 2: Verifying Hadoop Installation ···· 8

Step 3: Downloading Hive ···· 15

Step 4: Installing Hive ····· 15

Step 5: Configuring Hive ···· 16

Step 6: Downloading and Installing Apache Derby ··· 17

Step 7: Configuring Metastore of Hive ···· 19

Step 8: Verifying Hive Installation ···· 20

3. HIVE DATA TYPES ································ ···· 22

Column Types ····· 22

Literals ··· 24

Null Value ····· 24

Complex Types ··· 24