Skip to content

Instantly share code, notes, and snippets.

@1ambda

1ambda/df-sql.py

Created December 26, 2021 05:51
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 1ambda/f29fb5527ac24f307476f284d697ee75 to your computer and use it in GitHub Desktop.
Save 1ambda/f29fb5527ac24f307476f284d697ee75 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
df-sql.py
dfListing.createOrReplaceTempView("LISTING_META")
dfCalendar.createOrReplaceTempView("LISTING_CALENDAR")
spark.sql("""
SELECT id, listing_url, name, property_type
FROM LISTING_META
LIMIT 10
""").show()
spark.sql("""
SELECT *
FROM LISTING_CALENDAR
LIMIT 10
""").show()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment