• National Institute of Fashion Technology UAE

• BFTECH 2044

/ Practice Project 1 - Yellow taxi trip analysis using Hive Content Hadoop: Master your Big Data Hive: Big data SQL Practice Project - I Practice Project 1 - Yellow taxi trip analysis using Hive Data information Data dictionary trip records yellow.pdf Reference Document -SQL to Hive.pdf yellow_tripdata_2015-01-06.csv Sample Solution: Yellow taxi Practice Project 1 - Yellow taxi trip analysis using Hive Submission type : Not graded Due Date : Dec 31, 2020, 11:59 PM Description Problem statement: In this case study, we are giving a real world example of how to use HIVE on top of the HADOOP for different exploratory data analysis. In here, we have a predefined dataset (2018_Yellow_Taxi_Trip_Data.csv) having more than 15 columns and more than 100000 records in it. The dataset has different attributes like 1. vendor_id string, 2. pickup_datetime string, 3. dropoff_datetime string, 4. passenger_count int, 5. trip_distance DECIMAL(9,6), 6. pickup_longitude DECIMAL(9,6), 7. pickup_latitude DECIMAL(9,6), 8. rate_code int, D