CREATE TABLE test_orc.catalog_sales(
cs_sold_date_sk int DEFAULT NULL COMMENT ' ',
cs_sold_time_sk int DEFAULT NULL COMMENT ' ',
cs_ship_date_sk int DEFAULT NULL COMMENT ' ',
cs_bill_customer_sk int DEFAULT NULL COMMENT ' ',
cs_bill_cdemo_sk int DEFAULT NULL COMMENT ' ',
cs_bill_hdemo_sk int DEFAULT NULL COMMENT ' ',
cs_bill_addr_sk int DEFAULT NULL COMMENT ' ',
cs_ship_customer_sk int DEFAULT NULL COMMENT ' ',
cs_ship_cdemo_sk int DEFAULT NULL COMMENT ' ',
cs_ship_hdemo_sk int DEFAULT NULL COMMENT ' ',
cs_ship_addr_sk int DEFAULT NULL COMMENT ' ',
cs_call_center_sk int DEFAULT NULL COMMENT ' ',
cs_catalog_page_sk int DEFAULT NULL COMMENT ' ',
cs_ship_mode_sk int DEFAULT NULL COMMENT ' ',
cs_warehouse_sk int DEFAULT NULL COMMENT ' ',
cs_item_sk int DEFAULT NULL COMMENT ' ',
cs_promo_sk int DEFAULT NULL COMMENT ' ',
cs_order_number int DEFAULT NULL COMMENT ' ',
cs_quantity int DEFAULT NULL COMMENT ' ',
cs_wholesale_cost float DEFAULT NULL COMMENT ' ',
cs_list_price float DEFAULT NULL COMMENT ' ',
cs_sales_price float DEFAULT NULL COMMENT ' ',
cs_ext_discount_amt float DEFAULT NULL COMMENT ' ',
cs_ext_sales_price float DEFAULT NULL COMMENT ' ',
cs_ext_wholesale_cost float DEFAULT NULL COMMENT ' ',
cs_ext_list_price float DEFAULT NULL COMMENT ' ',
cs_ext_tax float DEFAULT NULL COMMENT ' ',
cs_coupon_amt float DEFAULT NULL COMMENT ' ',
cs_ext_ship_cost float DEFAULT NULL COMMENT ' ',
cs_net_paid float DEFAULT NULL COMMENT ' ',
cs_net_paid_inc_tax float DEFAULT NULL COMMENT ' ',
cs_net_paid_inc_ship float DEFAULT NULL COMMENT ' ',
cs_net_paid_inc_ship_tax float DEFAULT NULL COMMENT ' ',
cs_net_profit float DEFAULT NULL COMMENT ' '
)
clustered by (cs_order_number) into 5 buckets
stored as orc ;