SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectDebugging Questionsm3 partitioning lifecycle

Debug Cast Preventing Partition Pruning

Fix query: SELECT COUNT(*) FROM events WHERE CAST(event_time AS DATE) = CURRENT_DATE;

Schema Context

events(event_id, event_time) -- partitioned by event_time