HADOOP ICP 4 - Apoorvag2597/BDP_Revised GitHub Wiki

Objective - Create Hive Tables and Perform Queries on Petrol Data

Create Hive Tables and Perform Queries on Olympics Data

Features -

We first create a table using hive tables, and then perform different operations on that.

i. Petrol Data

Table

Query 1 - Amount of Petrol sold by each distributor

Query 2 - Top 10 Petrol sold by distributors along with their ID

Query 3 - Top 10 distributors sold by least amount

Query 4 - Distributors along with their difference and with their year

Olympics Case

Table Creation

Query 1- Number of medals won by each country in swimming

Query 2 - Real life medals won by India in each year

Query 3 - Number of medals won by each country along with name, total medals

Query 4 - Medals won for Shooting by year wise