Skip to content

Instantly share code, notes, and snippets.

@robert8138

robert8138/data_partition_create_statement.sql

Created February 7, 2018 06:53
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save robert8138/08c525785eb959ffe6b861f959db6c61 to your computer and use it in GitHub Desktop.
Save robert8138/08c525785eb959ffe6b861f959db6c61 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
data_partition_create_statement.sql
CREATE TABLE IF NOT EXISTS fct_bookings (
id_listing BIGINT COMMENT 'Unique ID of the listing'
, id_host BIGINT COMMENT 'Unique ID of the host who owns the listing'
, m_bookings BIGINT COMMENT 'Denoted 1 if a booking transaction occurred'
)
PARTITION BY ( -- this is how we define partition keys
ds STRING
);
@AlexisHe
Copy link

AlexisHe commented Sep 8, 2018

which database or data warehouse is used for this syntax?

@elbaza1
Copy link

elbaza1 commented Feb 10, 2020

which database or data warehouse is used for this syntax?

This is for Apache Hive

@robert8138
Copy link
Author

Correct!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment