301.3.2-Hive Introduction

Hive

• Hive runs on top of Hadoop
• Hive is SQL on top of Hadoop
• Our Sql queries are converted into MapReduce programs and executed on top of hive data warehouse tables
• Developed by Facebook
• Further developed and maintained by Apache Software Foundation
• Majorly used for basic statistics, reporting and data analytics

Features of Hive

• Enables easy data summarization
• Ad-hoc analysis of large volumes of data
• SQL like queries
• Scaling-up is easy

LAB: Start Hive

Start Hive

hive

Show tables

show tables;