Intervalsmedium45 minData Engineer

Join Capacity Interval Planner

Data Engineer signal: line sweep + interval merge in a stream-table join context. This is a ProdMatch-owned data engineer drill, framed as a March 2026 Chargebee Warehouse Platform simulation, not a copied platform question.

Company context

Chargebee · Warehouse Platform

Freshness

March 2026

Product surface

stream-table join

ProdMatch interview simulation based on product-team patterns; not a claim of a real company question.

Question

Plan capacity for stream-table join. Given reservation intervals with requested units, return the minimum capacity needed and all time ranges where capacity crosses a critical threshold.

Input

Intervals [start, end, units] and threshold.

Output

Peak capacity and merged high-pressure intervals.

Constraints

1 <= intervals.length <= 200000
Intervals are half-open: [start, end).
Timestamps fit in signed 32-bit integers.

Concepts

stream windows
watermarks
lineage DAGs
line sweep
interval merge
capacity planning

[[1,4,3],[2,5,4]], threshold=6 -> peak=7, hot=[[2,4]]

Approach

Try framing your own approach first. The 30 seconds you think before peeking is where learning happens.

Clean Solution

Reveal the approach first.

How well did you understand?

Your rating tunes when this problem shows up again.

Common Mistakes

Be explicit about whether touching endpoints overlap.
Process end events before start events for half-open intervals.

Next Similar Problems

Watermark Capacity Interval Plannerhard Lineage Capacity Interval Plannerhard Dedupe Capacity Interval Plannerhard