1. Aggregate select
sum(revenue) aggregates each group and AS names the result column for later reference.
SELECT country, sum(revenue) AS totalTyporithm · easy
Temp Views & SQL
temp-view-querysparktemp-viewaggregationspark-sql
Saved on this device
Full lesson · 8 learning steps Open any exercise for focused practice
10%
Step 1 of 8 · intro card
Learn Temp Views & SQL
Spark SQL
Register a DataFrame as a temp view with createOrReplaceTempView, then query it with full SQL through spark.sql(...) — here a grouped revenue total per country.
Call df.createOrReplaceTempView("orders") to expose a DataFrame to the SQL engine under a name.
Once registered, spark.sql(...) runs any ANSI-style query against it — SELECT, GROUP BY, ORDER BY, and the full function library.
The result is just another DataFrame, so you can chain more transformations or write it out.
01
createOrReplaceTempView names a DataFrame for SQL.
02
spark.sql(...) runs full SQL over the view.
03
GROUP BY + sum() aggregates each group.
SELECT country, sum(revenue) AS total FROM orders GROUP BY country ORDER BY total DESCRead the implementation
Connect each part of the code to the concept before you type.
2. Query the view
orders is the temp view registered from a DataFrame, queried here as if it were a table.
FROM orders3. Group rows
GROUP BY collapses rows sharing the same country into one aggregated row.
GROUP BY country4. Sort results
ORDER BY total DESC sorts the grouped output from the highest revenue down.
ORDER BY total DESCA complete learning loop
01
Understand
Read the concept map and follow the code breakdown.
02
Reconstruct
Type the implementation, repair mistakes and work through every recall exercise.
03
Verify
Use the final check without hints; revisit weak concepts in short practice sessions.