tpc-ds doris 24张建表的sql

CREATE TABLE dbgen_version (
    `dv_version` varchar(16),
    `dv_create_date` DATETIME,
    `dv_create_time` DATETIME,
    `dv_cmdline_args` varchar(200)
) 
DISTRIBUTED BY HASH(`dv_version`) BUCKETS 1 
PROPERTIES (
    "replication_num" = "3"
);

CREATE TABLE customer_address (
    `ca_address_sk` INT NOT NULL ,
    `ca_address_id` CHAR(16) NOT NULL ,
    `ca_street_number` CHAR(10) NULL ,
    `ca_street_name` VARCHAR(60) NULL ,
    `ca_street_type` CHAR(15) NULL ,
    `ca_suite_number` CHAR(10) NULL ,
    `ca_city` VARCHAR(60) NULL ,
    `ca_county` VARCHAR(30) NULL ,
    `ca_state` CHAR(2) NULL ,
    `ca_zip` CHAR(10) NULL ,
    `ca_country` VARCHAR(20) NULL ,
    `ca_gmt_offset` DECIMAL(5,2) NULL ,
    `ca_location_type` CHAR(20) NULL
) 
DUPLICATE KEY(`ca_address_sk`) 
DISTRIBUTED BY HASH(`ca_address_sk`) BUCKETS 1 
PROPERTIES (
    "replication_num" = "3"
);

CREATE TABLE customer_demographics (
    `cd_demo_sk` INT NOT NULL,
    `cd_gender` CHAR(1) NULL,
    `cd_marital_status` CHAR(1) NULL,
    `cd_education_status` CHAR(20) NULL,
    `cd_purchase_estimate` INT NULL,
    `cd_credit_rating` CHAR(10) NULL,
    `cd_dep_count` INT NULL,
    `cd_dep_employed_count` INT NULL,
    `cd_dep_college_count` INT NULL
)
DUPLICATE KEY(`cd_demo_sk`)
DISTRIBUTED BY HASH(`cd_demo_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

CREATE TABLE date_dim (
    `d_date_sk` INT NOT NULL,
    `d_date_id` CHAR(16) NOT NULL,
    `d_date` DATETIME NULL,
    `d_month_seq` INT NULL,
    `d_week_seq` INT NULL,
    `d_quarter_seq` INT NULL,
    `d_year` INT NULL,
    `d_dow` INT NULL,
    `d_moy` INT NULL,
    `d_dom` INT NULL,
    `d_qoy` INT NULL,
    `d_fy_year` INT NULL,
    `d_fy_quarter_seq` INT NULL,
    `d_fy_week_seq` INT NULL,
    `d_day_name` CHAR(9) NULL,
    `d_quarter_name` CHAR(6) NULL,
    `d_holiday` CHAR(1) NULL,
    `d_weekend` CHAR(1) NULL,    
    `d_following_holiday` CHAR(1) NULL,
    `d_first_dom` INT NULL,
    `d_last_dom` INT NULL,
    `d_same_day_ly` INT NULL,
    `d_same_day_lq` INT NULL,
    `d_current_day` CHAR(1) NULL,
    `d_current_week` CHAR(1) NULL,
    `d_current_month` CHAR(1) NULL,
    `d_current_quarter` CHAR(1) NULL,
    `d_current_year` CHAR(1) NULL
)
DUPLICATE KEY(`d_date_sk`)
DISTRIBUTED BY HASH(`d_date_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

CREATE TABLE warehouse (
    `w_warehouse_sk` INT NOT NULL,
    `w_warehouse_id` CHAR(16) NOT NULL,
    `w_warehouse_name` VARCHAR(20) NULL,
    `w_warehouse_sq_ft` INT NULL,
    `w_street_number` CHAR(10) NULL,
    `w_street_name` VARCHAR(60) NULL,
    `w_street_type` CHAR(15) NULL,
    `w_suite_number` CHAR(10) NULL,
    `w_city` VARCHAR(60) NULL,
    `w_county` VARCHAR(30) NULL,
    `w_state` CHAR(2) NULL,
    `w_zip` CHAR(10) NULL,    
    `w_country` VARCHAR(20) NULL,
    `w_gmt_offset` DECIMAL(5,2) NULL
)
DUPLICATE KEY(`w_warehouse_sk`)
DISTRIBUTED BY HASH(`w_warehouse_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

CREATE TABLE ship_mode (
    `sm_ship_mode_sk` INT NOT NULL,
    `sm_ship_mode_id` CHAR(16) NOT NULL,
    `sm_type` CHAR(30) NULL,
    `sm_code` CHAR(10) NULL,
    `sm_carrier` CHAR(20) NULL,
    `sm_contract` CHAR(20) NULL
)
DUPLICATE KEY(`sm_ship_mode_sk`)
DISTRIBUTED BY HASH(`sm_ship_mode_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

CREATE TABLE time_dim (
    `t_time_sk` INT NOT NULL,
    `t_time_id` CHAR(16) NOT NULL,
    `t_time` INT NULL,
    `t_hour` INT NULL,
    `t_minute` INT NULL,
    `t_second` INT NULL,
    `t_am_pm` CHAR(2) NULL,
    `t_shift` CHAR(20) NULL,
    `t_sub_shift` CHAR(20) NULL,
    `t_meal_time` CHAR(20) NULL
)
DUPLICATE KEY(`t_time_sk`)
DISTRIBUTED BY HASH(`t_time_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

CREATE TABLE reason (
    `r_reason_sk` INT NOT NULL,
    `r_reason_id` CHAR(16) NOT NULL,
    `r_reason_desc` CHAR(100) NULL
)
DUPLICATE KEY(`r_reason_sk`)
DISTRIBUTED BY HASH(`r_reason_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

CREATE TABLE income_band (
    `ib_income_band_sk` INT NOT NULL,
    `ib_lower_bound` INT NULL,
    `ib_upper_bound` INT NULL
)
DUPLICATE KEY(`ib_income_band_sk`)
DISTRIBUTED BY HASH(`ib_income_band_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);


create table item
(
    `i_item_sk`                 INT               not null,
    `i_item_id`                 char(16)              not null,
    `i_rec_start_date`          DATETIME                         ,
    `i_rec_end_date`            DATETIME                         ,
    `i_item_desc`               varchar(200)                  ,
    `i_current_price`           decimal(7,2)                  ,
    `i_wholesale_cost`          decimal(7,2)                  ,
    `i_brand_id`                INT                       ,
    `i_brand`                   char(50)                      ,
    `i_class_id`                INT                       ,
    `i_class`                   char(50)                      ,
    `i_category_id`             INT                       ,
    `i_category`                char(50)                      ,
    `i_manufact_id`             INT                       ,
    `i_manufact`                char(50)                      ,
    `i_size`                    char(20)                      ,
    `i_formulation`             char(20)                      ,
    `i_color`                   char(20)                      ,
    `i_units`                   char(10)                      ,
    `i_container`               char(10)                      ,
    `i_manager_id`              INT                       ,
    `i_product_name`            char(50)                     
)
DUPLICATE KEY(`i_item_sk`)
DISTRIBUTED BY HASH(`i_item_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table store
(
    `s_store_sk`                INT               not null,
    `s_store_id`                char(16)              not null,
    `s_rec_start_date`          DATETIME                         ,
    `s_rec_end_date`            DATETIME                         ,
    `s_closed_date_sk`          INT                       ,
    `s_store_name`              varchar(50)                   ,
    `s_number_employees`        INT                       ,
    `s_floor_space`             INT                       ,
    `s_hours`                   char(20)                      ,
    `s_manager`                 varchar(40)                   ,
    `s_market_id`               INT                       ,
    `s_geography_class`         varchar(100)                  ,
    `s_market_desc`             varchar(100)                  ,
    `s_market_manager`          varchar(40)                   ,
    `s_division_id`             INT                       ,
    `s_division_name`           varchar(50)                   ,
    `s_company_id`              INT                       ,
    `s_company_name`            varchar(50)                   ,
    `s_street_number`           varchar(10)                   ,
    `s_street_name`             varchar(60)                   ,
    `s_street_type`             char(15)                      ,
    `s_suite_number`            char(10)                      ,
    `s_city`                    varchar(60)                   ,
    `s_county`                  varchar(30)                   ,
    `s_state`                   char(2)                       ,
    `s_zip`                     char(10)                      ,
    `s_country`                 varchar(20)                   ,
    `s_gmt_offset`              decimal(5,2)                  ,
    `s_tax_precentage`          decimal(5,2)                 
)
DUPLICATE KEY(`s_store_sk`)
DISTRIBUTED BY HASH(`s_store_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table call_center
(
    `cc_call_center_sk`         INT               not null,
    `cc_call_center_id`         char(16)              not null,
    `cc_rec_start_date`         DATETIME                         ,
    `cc_rec_end_date`           DATETIME                         ,
    `cc_closed_date_sk`         INT                       ,
    `cc_open_date_sk`           INT                       ,
    `cc_name`                   varchar(50)                   ,
    `cc_class`                  varchar(50)                   ,
    `cc_employees`              INT                       ,
    `cc_sq_ft`                  INT                       ,
    `cc_hours`                  char(20)                      ,
    `cc_manager`                varchar(40)                   ,
    `cc_mkt_id`                 INT                       ,
    `cc_mkt_class`              char(50)                      ,
    `cc_mkt_desc`               varchar(100)                  ,
    `cc_market_manager`         varchar(40)                   ,
    `cc_division`              INT                       ,
    `cc_division_name`          varchar(50)                   ,
    `cc_company`                INT                       ,
    `cc_company_name`           char(50)                      ,
    `cc_street_number`          char(10)                      ,
    `cc_street_name`            varchar(60)                   ,
    `cc_street_type`            char(15)                      ,
    `cc_suite_number`           char(10)                      ,
    `cc_city`                   varchar(60)                   ,
    `cc_county`                 varchar(30)                   ,
    `cc_state`                  char(2)                       ,
    `cc_zip`                    char(10)                      ,
    `cc_country`                varchar(20)                   ,
    `cc_gmt_offset`             decimal(5,2)                  ,
    `cc_tax_percentage`         decimal(5,2)                
)
DUPLICATE KEY(`cc_call_center_sk`)
DISTRIBUTED BY HASH(`cc_call_center_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table customer
(
    `c_customer_sk`             INT               not null,
    `c_customer_id`             char(16)              not null,
    `c_current_cdemo_sk`        INT                       ,
    `c_current_hdemo_sk`        INT                       ,
    `c_current_addr_sk`         INT                       ,
    `c_first_shipto_date_sk`    INT                       ,
    `c_first_sales_date_sk`     INT                       ,
    `c_salutation`              char(10)                      ,
    `c_first_name`              char(20)                      ,
    `c_last_name`               char(30)                      ,
    `c_preferred_cust_flag`     char(1)                       ,
    `c_birth_day`               INT                       ,
    `c_birth_month`             INT                       ,
    `c_birth_year`              INT                       ,
    `c_birth_country`           varchar(20)                   ,
    `c_login`                   char(13)                      ,
    `c_email_address`           char(50)                      ,
    `c_last_review_date`        char(10)                      
)
DUPLICATE KEY(`c_customer_sk`)
DISTRIBUTED BY HASH(`c_customer_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table web_site
(
    `web_site_sk`               INT               not null,
    `web_site_id`               char(16)              not null,
    `web_rec_start_date`        DATETIME                         ,
    `web_rec_end_date`          DATETIME                         ,
    `web_name`                  varchar(50)                   ,
    `web_open_date_sk`          INT                       ,
    `web_close_date_sk`         INT                       ,
    `web_class`                 varchar(50)                   ,
    `web_manager`               varchar(40)                   ,
    `web_mkt_id`                INT                       ,
    `web_mkt_class`             varchar(50)                   ,
    `web_mkt_desc`              varchar(100)                  ,
    `web_market_manager`        varchar(40)                   ,
    `web_company_id`            INT                       ,
    `web_company_name`          char(50)                      ,
    `web_street_number`         char(10)                      ,
    `web_street_name`           varchar(60)                   ,
    `web_street_type`           char(15)                      ,
    `web_suite_number`          char(10)                      ,
    `web_city`                  varchar(60)                   ,
    `web_county`                varchar(30)                   ,
    `web_state`                 char(2)                       ,
    `web_zip`                   char(10)                      ,
    `web_country`               varchar(20)                   ,
    `web_gmt_offset`            decimal(5,2)                  ,
    `web_tax_percentage`        decimal(5,2)                  
)
DUPLICATE KEY(`web_site_sk`)
DISTRIBUTED BY HASH(`web_site_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table store_returns
(
    `sr_item_sk`                INT               not null,
    `sr_ticket_number`          INT               not null,
    `sr_returned_date_sk`       INT                       ,
    `sr_return_time_sk`         INT                       ,
    
    `sr_customer_sk`            INT                       ,
    `sr_cdemo_sk`               INT                       ,
    `sr_hdemo_sk`               INT                       ,
    `sr_addr_sk`                INT                       ,
    `sr_store_sk`               INT                       ,
    `sr_reason_sk`              INT                       ,
    
    `sr_return_quantity`        INT                       ,
    `sr_return_amt`             decimal(7,2)                  ,
    `sr_return_tax`             decimal(7,2)                  ,
    `sr_return_amt_inc_tax`    decimal(7,2)                  ,
    `sr_fee`                    decimal(7,2)                  ,
    `sr_return_ship_cost`       decimal(7,2)                  ,
    `sr_refunded_cash`          decimal(7,2)                  ,
    `sr_reversed_charge`        decimal(7,2)                  ,
    `sr_store_credit`           decimal(7,2)                  ,
    `sr_net_loss`               decimal(7,2)                 
)
DUPLICATE KEY(`sr_item_sk`,`sr_ticket_number`)
DISTRIBUTED BY HASH(`sr_item_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table household_demographics
(
    `hd_demo_sk`                INT               not null,
    `hd_income_band_sk`         INT                       ,
    `hd_buy_potential`          char(15)                      ,
    `hd_dep_count`              INT                       ,
    `hd_vehicle_count`          INT                      
)
DUPLICATE KEY(`hd_demo_sk`)
DISTRIBUTED BY HASH(`hd_demo_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table web_page
(
    `wp_web_page_sk`            INT               not null,
    `wp_web_page_id`            char(16)              not null,
    `wp_rec_start_date`         DATETIME                         ,
    `wp_rec_end_date`           DATETIME                         ,
    `wp_creation_date_sk`       INT                       ,
    `wp_access_date_sk`         INT                       ,
    `wp_autogen_flag`           char(1)                       ,
    `wp_customer_sk`            INT                       ,
    `wp_url`                    varchar(100)                  ,
    `wp_type`                   char(50)                      ,
    `wp_char_count`             INT                       ,
    `wp_link_count`             INT                       ,
    `wp_image_count`            INT                       ,
    `wp_max_ad_count`           INT                      
)
DUPLICATE KEY(`wp_web_page_sk`)
DISTRIBUTED BY HASH(`wp_web_page_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table promotion
(
    `p_promo_sk`                INT               not null,
    `p_promo_id`                char(16)              not null,
    `p_start_date_sk`           INT                       ,
    `p_end_date_sk`             INT                       ,
    `p_item_sk`                 INT                       ,
    `p_cost`                    decimal(15,2)                 ,
    `p_response_target`         INT                       ,
    `p_promo_name`              char(50)                      ,
    `p_channel_dmail`           char(1)                       ,
    `p_channel_email`           char(1)                       ,
    `p_channel_catalog`         char(1)                       ,
    `p_channel_tv`              char(1)                       ,
    `p_channel_radio`           char(1)                       ,
    `p_channel_press`           char(1)                       ,
    `p_channel_event`           char(1)                       ,
    `p_channel_demo`            char(1)                       ,
    `p_channel_details`         varchar(100)                  ,
    `p_purpose`                 char(15)                      ,
    `p_discount_active`         char(1)     
)                  
DUPLICATE KEY(`p_promo_sk`)
DISTRIBUTED BY HASH(`p_promo_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table catalog_page
(
    `cp_catalog_page_sk`        INT               not null,
    `cp_catalog_page_id`        char(16)              not null,
    `cp_start_date_sk`          INT                       ,
    `cp_end_date_sk`            INT                       ,
    `cp_department`             varchar(50)                   ,
    `cp_catalog_number`         INT                       ,
    `cp_catalog_page_number`    INT                       ,
    `cp_description`            varchar(100)                  ,
    `cp_type`                   varchar(100)                  
)
DUPLICATE KEY(`cp_catalog_page_sk`)
DISTRIBUTED BY HASH(`cp_catalog_page_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table inventory
(
    `inv_date_sk`               INT               not null,
    `inv_item_sk`               INT               not null,
    `inv_warehouse_sk`          INT               not null,
    `inv_quantity_on_hand`      INT                     
)
DUPLICATE KEY(`inv_date_sk`,`inv_item_sk`,`inv_warehouse_sk`)
DISTRIBUTED BY HASH(`inv_date_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table catalog_returns
(
    `cr_item_sk`                INT               not null,
    `cr_order_number`           INT               not null,
    
    `cr_returned_date_sk`       INT                       ,
    `cr_returned_time_sk`       INT                       ,
    
    `cr_refunded_customer_sk`   INT                       ,
    `cr_refunded_cdemo_sk`      INT                       ,
    `cr_refunded_hdemo_sk`      INT                       ,
    `cr_refunded_addr_sk`       INT                       ,
    `cr_returning_customer_sk`  INT                       ,
    `cr_returning_cdemo_sk`     INT                       ,
    `cr_returning_hdemo_sk`     INT                       ,
    `cr_returning_addr_sk`      INT                       ,
    `cr_call_center_sk`         INT                       ,
    `cr_catalog_page_sk`        INT                       ,
    `cr_ship_mode_sk`           INT                       ,
    `cr_warehouse_sk`           INT                       ,
    `cr_reason_sk`              INT                       ,
    
    `cr_return_quantity`        INT                       ,
    `cr_return_amount`          decimal(7,2)                  ,
    `cr_return_tax`             decimal(7,2)                  ,
    `cr_return_amt_inc_tax`     decimal(7,2)                  ,
    `cr_fee`                    decimal(7,2)                  ,
    `cr_return_ship_cost`       decimal(7,2)                  ,
    `cr_refunded_cash`          decimal(7,2)                  ,
    `cr_reversed_charge`        decimal(7,2)                  ,
    `cr_store_credit`           decimal(7,2)                  ,
    `cr_net_loss`               decimal(7,2)                 
)
DUPLICATE KEY(`cr_item_sk`,`cr_order_number`)
DISTRIBUTED BY HASH(`cr_item_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table web_returns
(
    `wr_item_sk`                INT               not null,
    `wr_order_number`           INT               not null,
    `wr_returned_date_sk`       INT                       ,
    `wr_returned_time_sk`       INT                       ,
    
    `wr_refunded_customer_sk`   INT                       ,
    `wr_refunded_cdemo_sk`      INT                       ,
    `wr_refunded_hdemo_sk`      INT                       ,
    `wr_refunded_addr_sk`       INT                       ,
    `wr_returning_customer_sk`  INT                       ,
    `wr_returning_cdemo_sk`     INT                       ,
    `wr_returning_hdemo_sk`     INT                       ,
    `wr_returning_addr_sk`      INT                       ,
    `wr_web_page_sk`            INT                       ,
    `wr_reason_sk`              INT                       ,
    
    `wr_return_quantity`        INT                       ,
    `wr_return_amt`             decimal(7,2)                  ,
    `wr_return_tax`             decimal(7,2)                  ,
    `wr_return_amt_inc_tax`     decimal(7,2)                  ,
    `wr_fee`                    decimal(7,2)                  ,
    `wr_return_ship_cost`       decimal(7,2)                  ,
    `wr_refunded_cash`          decimal(7,2)                  ,
    `wr_reversed_charge`        decimal(7,2)                  ,
    `wr_account_credit`         decimal(7,2)                  ,
    `wr_net_loss`               decimal(7,2)                
)
DUPLICATE KEY(`wr_item_sk`,`wr_order_number`)
DISTRIBUTED BY HASH(`wr_item_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table web_sales
(
    `ws_item_sk`                INT               not null,
    `ws_order_number`           INT               not null,
    `ws_sold_date_sk`           INT                       ,
    `ws_sold_time_sk`           INT                       ,
    `ws_ship_date_sk`           INT                       ,
    
    `ws_bill_customer_sk`       INT                       ,
    `ws_bill_cdemo_sk`          INT                       ,
    `ws_bill_hdemo_sk`          INT                       ,
    `ws_bill_addr_sk`           INT                       ,
    `ws_ship_customer_sk`       INT                       ,
    `ws_ship_cdemo_sk`          INT                       ,
    `ws_ship_hdemo_sk`          INT                       ,
    `ws_ship_addr_sk`           INT                       ,
    `ws_web_page_sk`            INT                       ,
    `ws_web_site_sk`            INT                       ,
    `ws_ship_mode_sk`           INT                       ,
    `ws_warehouse_sk`           INT                       ,
    `ws_promo_sk`               INT                       ,
    
    `ws_quantity`               INT                       ,
    `ws_wholesale_cost`         decimal(7,2)                  ,
    `ws_list_price`             decimal(7,2)                  ,
    `ws_sales_price`           decimal(7,2)                  ,
    `ws_ext_discount_amt`       decimal(7,2)                  ,
    `ws_ext_sales_price`        decimal(7,2)                  ,
    `ws_ext_wholesale_cost`     decimal(7,2)                  ,
    `ws_ext_list_price`         decimal(7,2)                  ,
    `ws_ext_tax`                decimal(7,2)                  ,
    `ws_coupon_amt`             decimal(7,2)                  ,
    `ws_ext_ship_cost`          decimal(7,2)                  ,
    `ws_net_paid`               decimal(7,2)                  ,
    `ws_net_paid_inc_tax`       decimal(7,2)                  ,
    `ws_net_paid_inc_ship`      decimal(7,2)                  ,
    `ws_net_paid_inc_ship_tax`  decimal(7,2)                  ,
    `ws_net_profit`             decimal(7,2)               
)
DUPLICATE KEY(`ws_item_sk`,`ws_order_number`)
DISTRIBUTED BY HASH(`ws_item_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table catalog_sales
(
    `cs_item_sk`                INT               not null,
    `cs_order_number`           INT               not null,
    `cs_sold_date_sk`           INT                       ,
    `cs_sold_time_sk`           INT                       ,
    `cs_ship_date_sk`           INT                       ,
    `cs_bill_customer_sk`       INT                       ,
    `cs_bill_cdemo_sk`          INT                       ,
    `cs_bill_hdemo_sk`          INT                       ,
    `cs_bill_addr_sk`           INT                       ,
    `cs_ship_customer_sk`       INT                       ,
    `cs_ship_cdemo_sk`          INT                       ,
    `cs_ship_hdemo_sk`          INT                       ,
    `cs_ship_addr_sk`           INT                       ,
    `cs_call_center_sk`         INT                       ,
    `cs_catalog_page_sk`        INT                       ,
    `cs_ship_mode_sk`           INT                       ,
    `cs_warehouse_sk`           INT                       ,
    
    `cs_promo_sk`               INT                       ,
    
    `cs_quantity`               INT                       ,
    `cs_wholesale_cost`         decimal(7,2)                  ,
    `cs_list_price`             decimal(7,2)                  ,
    `cs_sales_price`            decimal(7,2)                  ,
    `cs_ext_discount_amt`       decimal(7,2)                  ,
    `cs_ext_sales_price`        decimal(7,2)                  ,
    `cs_ext_wholesale_cost`     decimal(7,2)                  ,
    `cs_ext_list_price`         decimal(7,2)                  ,
    `cs_ext_tax`                decimal(7,2)                  ,
    `cs_coupon_amt`             decimal(7,2)                  ,
    `cs_ext_ship_cost`          decimal(7,2)                  ,
    `cs_net_paid`               decimal(7,2)                  ,
    `cs_net_paid_inc_tax`       decimal(7,2)                  ,
    `cs_net_paid_inc_ship`      decimal(7,2)                  ,
    `cs_net_paid_inc_ship_tax`  decimal(7,2)                  ,
    `cs_net_profit`             decimal(7,2)           
)
DUPLICATE KEY(`cs_item_sk`,`cs_order_number`)
DISTRIBUTED BY HASH(`cs_item_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);

create table store_sales
(
    `ss_item_sk`                INT               not null,
    `ss_ticket_number`          INT               not null,
    `ss_sold_date_sk`           INT                       ,
    `ss_sold_time_sk`           INT                       ,
    
    `ss_customer_sk`            INT                       ,
    `ss_cdemo_sk`               INT                       ,
    `ss_hdemo_sk`               INT                       ,
    `ss_addr_sk`                INT                       ,
    `ss_store_sk`               INT                       ,
    `ss_promo_sk`               INT                       ,
    
    `ss_quantity`               INT                       ,
    `ss_wholesale_cost`         decimal(7,2)                  ,
    `ss_list_price`             decimal(7,2)                  ,
    `ss_sales_price`            decimal(7,2)                  ,
    `ss_ext_discount_amt`       decimal(7,2)                  ,
    `ss_ext_sales_price`        decimal(7,2)                  ,
    `ss_ext_wholesale_cost`     decimal(7,2)                  ,
    `ss_ext_list_price`         decimal(7,2)                  ,
    `ss_ext_tax`                decimal(7,2)                  ,
    `ss_coupon_amt`             decimal(7,2)                  ,
    `ss_net_paid`               decimal(7,2)                  ,
    `ss_net_paid_inc_tax`       decimal(7,2)                  ,
    `ss_net_profit`             decimal(7,2)            
)
DUPLICATE KEY(`ss_item_sk`,`ss_ticket_number`)
DISTRIBUTED BY HASH(`ss_item_sk`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3"
);