quiz9-solution.pdf - Name USC ID INF 551 Fall 2018(Morning section Quiz 9 SQL via Hadoop MapReduce(10 points 10 minutes Consider a sales data stored as

quiz9-solution.pdf - Name USC ID INF 551 Fall 2018(Morning...

This preview shows page 1 out of 1 page.

Name: ___________________________ USC ID: ______________________ INF 551 Fall 2018 (Morning section) Quiz 9: SQL via Hadoop MapReduce (10 points), 10 minutes Consider a sales data stored as a csv file (fields are category, state, year, and amount): Cell,CA,2017,30 Cell,CA,2016,30 Cell,NY,2018,80 Laptop,CA,2017,15 Laptop,CA,2018,50 Laptop,NY,2015,35 Tablet,NY,2015,50 Consider computing the answer to the following SQL query using Hadoop MapReduce (assume that NO combiner is used). Select category, avg(amount) From sales Where year != 2016 Group by category Having count(*) > 1 1.[5 points] Write the logic of mapfunction in pseudocode. What will the map function output for the
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

  • Fall '14
  • Hadoop

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes