robert8138 · February 7, 2018 06:53 · AlexisHe · Sep 8, 2018 · elbaza1 · Feb 10, 2020
diff --git a/data_partition_create_statement.sql b/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
 );
	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
	);