Skip to content

Instantly share code, notes, and snippets.

@1ambda
Created December 26, 2021 23:30
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/555b02ab2162eeca46219e0b4de27ad8 to your computer and use it in GitHub Desktop.
Save 1ambda/555b02ab2162eeca46219e0b4de27ad8 to your computer and use it in GitHub Desktop.
spark.sql("""
CREATE TABLE IF NOT EXISTS airbnb_db.listing_availability (
listing_id BIGINT,
listing_name STRING,
listing_url STRING,
review_scores_rating BIGINT,
listing_price_basic DOUBLE,
count_date_available BIGINT,
count_date_unavailable BIGINT
)
USING PARQUET
LOCATION 's3://airbnb-data-lake/db/listing_availability';
COMMENT 'Listing Availability'
""")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment