Skip to content

Instantly share code, notes, and snippets.

@ldenson11

ldenson11/JoiningTwoKafkaTopics.sql Secret

Created October 28, 2019 17:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ldenson11/cd9beaba31b99241b7ba55fa4d0b3628 to your computer and use it in GitHub Desktop.
Save ldenson11/cd9beaba31b99241b7ba55fa4d0b3628 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
JoiningTwoKafkaTopics.sql
-- display reg and country for aircraft
SELECT a.icao, a.speed, b.type_aircraft, b.country
FROM airplanes a -- first table/stream
JOIN airplanes_registrations b -- second table/stream
ON a.icao = b.icao; -- join key
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment