drop table store_sales; CREATE TABLE store_sales( SUBVENDOR_ID_KEY int , VENDOR_KEY int , RETAILER_KEY int , ITEM_KEY int , STORE_KEY int , SubvendorId string, OOS_REASON_KEY int , Total_Sales_Amount float , Total_Sales_Volume_Units float , Store_On_Hand_Volume_Units float , Promoted_Sales_Amount float , Promoted_Sales_Volume_Units float , Regular_Sales_Amount float , Regular_Sales_Volume_Units float , Store_Ordered_Volume_Units float , Store_Ordered_Volume_Cases float , Store_Receipts_Volume_Units float , Store_Receipts_Volume_Cases float , productline string, Store_On_Hand_Amount float , Store_On_Hand_Volume_Cases float , Total_Sales_Volume_Cases float , DC_RETAILER_KEY int , DC_KEY int , Total_Price float , Promoted_Price float , Regular_Price float , Zero_Scan_Day int , Ordered_Date int , Receipt_Date int , OOS_Indicator int , Scan_Date int , Store_On_Hand_Volume float , Conversion float ) PARTITIONED BY (PERIOD_KEY STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
