SQL & Querying Joins Window Functions Aggregate Combinators Mutations (UPDATE / DELETE)

SQL & Querying

SQL & Querying

Joins, windows, and the SQL features that behave differently here.

Joins, windows, and the SQL features that behave differently here.

Sections

5.1
JoinsAlgorithms, GLOBAL JOIN, pitfalls
5.2
Window FunctionsOVER, frames, and SAMPLE
5.3
Aggregate Combinators-If, -State, -Merge, -Distinct
5.4
Mutations (UPDATE / DELETE)Why they're heavyweight, async rewrites

Compression

Codecs & column encoding

Joins

Algorithms, GLOBAL JOIN, pitfalls