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.
Diese Übung ist Teil des Kurses
Data Transformation with Spark SQL in Databricks
Interaktive Übung
In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.
Übung starten