Core concept
Partition by aligns with skew handling. Order by within partition.
Advertisement
How it works
Expensive for large partitions. Careful with unbounded windows.
Advertisement
Trade-offs + gotchas
Sessionization, top-N per group, running totals.