Skip to content

Instantly share code, notes, and snippets.

@benjaminlaird

benjaminlaird/gist:03b1bbd323b6e7bb0455c0a7489a3529

Created August 22, 2020 17:57
Show Gist options
  • Save benjaminlaird/03b1bbd323b6e7bb0455c0a7489a3529 to your computer and use it in GitHub Desktop.
Save benjaminlaird/03b1bbd323b6e7bb0455c0a7489a3529 to your computer and use it in GitHub Desktop.
Download ZIP
Range join query
Raw
gistfile1.txt
spark.sql('''
SELECT ips.ip, ips.ip_int, asns.asn
FROM ips inner join asns
ON ips.ip_network = asns.network
WHERE ips.ip_int > asns.ip_min and ips.ip_int < asns.ip_max
''').count()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment