Overview
In this assignment, students are asked to conduct data processing using Hive and create Hive tables with their associated columns. Students will insert data in the created tables to have working examples. Students will create queries in order to filter and join data.
Purpose
This assignment will help students to learn how to process data using Hive. Students will learn how to create tables and insert data and be able to filter and join data based on the business needs.
Instructions
Students are expected to use tasks provided in Unit 04 and follow steps in Hortonworks tutorials. Student will create Hive tables. Students will insert data in the created tables. Students will create queries to filter and join data.
Submission
Submission will be via the Dropbox tool. There will be one Dropbox folder called: Hive Data Processing.
Grading Expectations
| Evaluation Rubric | |||||
| Criteria |
Level
3 (Exceeded) |
Level
2 (Attained) |
Level
1 (Developing) |
Level
0 (Un-attained) | POSSIBLE POINTS |
| Create Hive Tables | Successfully create Hive tables with their associated columns | Created Hive tables with some issues in associated columns | Not being able to create Hive Tables | Can’t open composition editor | /3 |
| Insert Data | Successfully inserted data into Hive tables | Inserted some rows into Hive tables | Not being able to insert any row | Can’t open composition editor | /3 |
| Run Queries | Successfully run queries to filter and join data | Run queries to either filter or join data (not being able to do both) | Not being able to run queries | Can’t open composition editor | /3 |
| TOTAL POINTS | /9 |