Skip to main content
All Questions

Merge a stream of (timestamp, location, temperature) records with a stream of (timestamp, location, humidity) records, handling keys that appear in only one stream.

Unlock detailed company stats for this questionUpgrade
Two data streams arrive: one of (timestamp, location, temperature) records and one of (timestamp, location, humidity) records. Write code that merges them into combined records per timestamp and location, handling the cases where a timestamp or a location appears in only one stream.

Community answers

No answers contributed by the community yet.

Related courses

Course

SQL Interview Prep Course

Prepare for SQL interviews with lessons on joins, aggregations, and window functions, then practice real SQL interview questions in an interactive editor with expert solutions.

Course

Data Science Interview Prep

Land your dream data science role at Google, Amazon, Microsoft, Meta, Apple, and other top companies. Learn from mock interviews, frameworks, and advice from senior candidates. Practice statistics, experimentation, coding, SQL, machine learning, behavioral interviews, and more.