- Community aggregator
- Country: United States
Zero-downtime partition swaps on Athena: build in a new prefix, flip with SET LOCATION
In part 1 I made partition rebuilds idempotent with delete prefix → INSERT INTO → add partition . In the comments, Karan Pulyala pointed out two weak spots. This post fixes the first one, hands-on and from scratch: delete-then-INSERT leaves a window where Athena readers see an empty partition, and…