Complete this project using your an understanding of Hadoop, HDFS, Hive, HiveQL and Hive DDL to perform data management, storage, retrieval, and analysis. Do not answer questions using any other software or method.
Dataset
Download two CSV files
Sample of Questions:
1. Find the 'most popular bike, i.e. the bike that has made the highest number of trips
The steps should be provided for each question, command, queries in both text and image form.
You should take a clear and readable screenshot of the shell of commands along with the outputs