Import the dataset into Hadoop ecosystem. You can store your data in Hive, HBase. You
may use Sqoop to import into HBase or Hive, or directly import into Hive using the GUI,
if you configured that. As an alternative, you can also use MySQL (though Hive is highly
encouraged, you will not be penalised for using MySQL instead).
Provide screenshot(s) of your data in Hive/HBase/MySQL. 2. Write queries to answer the follow questions:
a. Which countries had the highest and least number of viewers respectively? Hint:
tables “plays”, “users” as well as SQL join b. What genre of TV Shows was the most watched by iOS users?
Hint: tables assets and demographics and/or plays c. Which country/countries had the highest number of "Romance Movies Fans"?
Hint: tables psychographics and users