Joining and aggregating retail data
Your team at Global Retail Analytics wants to understand revenue patterns across regions. A new CSV file called country_lookup.csv has been added to the datasets volume, mapping each country to its region and currency.
You'll enrich the online_retail data with this lookup dataset using a broadcast join, verify the query plan, and aggregate revenue by region.
Deze oefening maakt deel uit van de cursus
Data Transformation with Spark SQL in Databricks
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen