Upload Data into HDFS and Execute Queries AssignmentTutorOnline | Good Grade Guarantee!
Week 6 Assignment 2 – Upload Data into HDFS and Execute Queries
In this assignment you will be running the HQL queries with the baseball data.
Your options are:
Azure HDInsight (Difficulty level : Easy)
Create the HDInsight cluster if you are using Azure
Use the Hive command line interface (CLI) or the browser based Ambari Hive View or HUE to execute the Hive commands from this week’s Assignment #1
NOTE: For CLI, you can use the ‘hive’ command if available. Otherwise you have to use ‘beeline’.
Create the Hive tables
Ensure that the tables are created and data inside the tables looks good
Execute the queries and capture the results
Provide a write up of the commands and the results. Did the output meet your expectations? If not, why not?
If using CLI, don’t forget to exit out of the Hive CLI and close the server connection
Terminate the Azure HDInsight cluster to avoid using up the available credit
Requirements for the assignments:
Assignment file must have a .doc or .docx extension; screen shots should be in .jpg, .gif, or .pdf
Points for this assignment = 45
QUALITY: 100% ORIGINAL – NO PLAGIARISM.
- **REMEMBER TO PRECISE PAGE NUMBER**
- Hit The Order Button To Order A **Custom Paper**