Find the top 10 users that have traveled the least distance. Output their id, name and a total distance traveled.

Problem Difficulty Level : Medium

Data Structure ride_log

• id
• user_id
• travel

user

• id
• name

Data for ride_log and user table

In CSV Format
In CSV Format

In Spark we will solve this problem using two ways

1. Using PySpark Functions
2. Using Spark SQL

Use below notebook for solution

Problem Solution First Part

In MySQL We will load data from CSV using MySQL Import functionality. And then we will solve this problem.

Output Query

Problem Solution

Please also follow below blog for understanding this problem