Querying a Partition

Problem

Your events table has billions of rows and is partitioned by year. A junior analyst wrote a query without a WHERE clause, causing a full table scan that crashed the cluster. Write a query that outputs concept with the value: "Partition pruning significantly improves query performance by only scanning the relevant partitions based on the WHERE clause filters."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution