Skip to content

Instantly share code, notes, and snippets.

@robert8138

robert8138/partition_by_ds.sql

Created February 6, 2018 06:39
Show Gist options
  • Save robert8138/846a65b2484f757281e5c2fe43f97086 to your computer and use it in GitHub Desktop.
Save robert8138/846a65b2484f757281e5c2fe43f97086 to your computer and use it in GitHub Desktop.
Download ZIP
A table partitioned by datestamp
Raw
partition_by_ds.sql
Column | Type | Extra | Comment
--------------------+---------+-----------------+-------------------------------------------
id_listing | bigint | | Unique id of the listing.
id_host | bigint | | Unique id of the host for the listing
dim_market | varchar | | The market in which the listing is located
ds | varchar | partition key |
(4 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment