Athena Partitioning: Why Your Queries Are Still Slow

Partitioning an Athena table is not the same as getting the benefit of it. A walkthrough of the three failure families behind slow queries on partitioned external data: predicates that never prune, catalog lookups that dominate planning, and file layouts that undo everything. Includes partition projection trade-offs, Glue partition indexes, compaction patterns, and how to tell which problem you have.

Continue ReadingAthena Partitioning: Why Your Queries Are Still Slow