Review the rubric to make sure you understand the criteria for earning your grade.
Review these resources:
eBook: Big Data and Hadoop – VK Jain – Google Books(new tab)
Hadoop User Interface (HUE) Website – Hue – The open-source SQL Assistant for Data Warehouses(new tab)
An Introduction to Hadoop Hue Gui(new tab)
Hadoop User Experience – Tutorial For Beginners(new tab)
Introduction to Hive and Hue using Cloudera(new tab)
Convert CSV to JSON(new tab)
Using HUE for HIVE Query (for the Project)(new tab)
Complete these exercises:
Use the given data set – SalesJan2009.csv(Excel spreadsheet) and generate/run a Hive query: “Find out Number of Products Sold in Each Country”, after creating an account at Home – Hadoop In Real World(new tab).
Generate and run 2 Hive queries (choose and modify queries from the set of HIVE queries given) – (Hortonworks.CheatSheet.SQLtoHive(PDF document)).
Record your resultant work in a Microsoft Word document, write a page or two interpreting the results, and then submit it by the end of the workshop.