sp26-cs544 cs544
Lecture 23: Spark SQL Lecture 23: Spark SQL
Content locked
The catalog is public. Reading this content requires approved access.
Sign in to readLecture 23: Spark SQL
Overview
Learning Objectives
Views and Tables
Option 1: Save as a Hive Table
Option 2: Create a Temporary View
Tables vs. Views: Tradeoffs
Grouping
DISTINCT
Groups and Aggregates
Partitions and Window Functions
Nested and Chained Grouping
Joining
INNER JOIN
LEFT JOIN
Combining SQL and DataFrames
Conclusion
Source