Skip to content

Instantly share code, notes, and snippets.

@afcotroneo
Created May 26, 2021 19:39
Show Gist options
  • Select an option

  • Save afcotroneo/d1ad9aefb546115df5609a2f38226282 to your computer and use it in GitHub Desktop.

Select an option

Save afcotroneo/d1ad9aefb546115df5609a2f38226282 to your computer and use it in GitHub Desktop.
let hash_table = build_hash_table(t2.rows.a); // build hash table over column a in t2
for t1_row in t1.rows:
for t2_row in hash_table(t1_row.a): // lookup the corresponding entry for t1’s row
if (t1_row.a = t2_row.a):
output_match()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment