Merge the Feeds, Keep the Truth
Easy About 10 min Katabench Pro
UNION deduplicates and UNION ALL does not: merge two event feeds without losing real duplicate events.
The full brief is part of Katabench Pro
Pro opens this kata's brief, its starter code and its grader. To see how the track works first, try Existence Without Loading, which is free.
How it is graded
Your LINQ or SQL runs against real PostgreSQL. You see the SQL your code generates on the sample tests and can inspect its execution plan, so you learn when the database did the wrong work.
What it practices
- Set operations
- UNION, INTERSECT and EXCEPT, with and without ALL, and what deduplication they imply.
Related katas
- Products Both Markets Buy Medium Pro Compose two product-id queries with Intersect so Postgres returns the overlap in one statement instead of two market-sized lists.
- Here, But Never There Medium Pro Use queryable Except to find products sold in one market and absent from another without materializing either market set.
- Who Stopped Listening Medium Pro Set difference between two time windows with EXCEPT: dedup semantics, positional columns, and a join back for the report row.
- Two Warehouses, Matching Stock Medium Pro INTERSECT returns a set and throws duplicate rows away: count matched stock units with multiset semantics instead.