Core concept
PARTITIONED BY (date STRING). Files under /table/date=2026-07-04/.
Advertisement
How it works
Over-partitioning = tiny files problem. Under = full-table scans.
Advertisement
Trade-offs + gotchas
Time-series tables. Log data. Big fact tables.