http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/bd294732/testdata/data/mstr/eatwh1/EATWH1-DDL.sql ---------------------------------------------------------------------- diff --git a/testdata/data/mstr/eatwh1/EATWH1-DDL.sql b/testdata/data/mstr/eatwh1/EATWH1-DDL.sql deleted file mode 100644 index ab874ea..0000000 --- a/testdata/data/mstr/eatwh1/EATWH1-DDL.sql +++ /dev/null @@ -1,1254 +0,0 @@ -CREATE DATABASE IF NOT EXISTS eatwh1; - -DROP TABLE IF EXISTS eatwh1.EATWH1_COST_MARKET_CLASS; -CREATE TABLE eatwh1.EATWH1_COST_MARKET_CLASS ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -MARKET_NBR INT, -COST_AMT FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_COST_MARKET_DEP; -CREATE TABLE eatwh1.EATWH1_COST_MARKET_DEP ( -CUR_TRN_DT STRING, -DEPARTMENT_NBR INT, -MARKET_NBR INT, -COST_AMT FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_COST_MARKET_DIV; -CREATE TABLE eatwh1.EATWH1_COST_MARKET_DIV ( -CUR_TRN_DT STRING, -DIVISION_NBR INT, -MARKET_NBR INT, -COST_AMT FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_COST_REGION_CLASS; -CREATE TABLE eatwh1.EATWH1_COST_REGION_CLASS ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -REGION_NBR INT, -COST_AMT FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_COST_REGION_ITEM; -CREATE TABLE eatwh1.EATWH1_COST_REGION_ITEM ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -ITEM_NBR INT, -REGION_NBR INT, -COST_AMT FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_COST_STORE_DEP; -CREATE TABLE eatwh1.EATWH1_COST_STORE_DEP ( -CUR_TRN_DT STRING, -DEPARTMENT_NBR INT, -STORE_NBR INT, -COST_AMT FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_COST_STORE_ITEM; -CREATE TABLE eatwh1.EATWH1_COST_STORE_ITEM ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -ITEM_NBR INT, -STORE_NBR INT, -COST_AMT FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT1; -CREATE TABLE eatwh1.EATWH1_FT1 ( -STORE_NBR INT, -M1 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT10; -CREATE TABLE eatwh1.EATWH1_FT10 ( -REGION_NBR INT, -MONTH_ID INT, -DEPARTMENT_NBR INT, -M10 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT11; -CREATE TABLE eatwh1.EATWH1_FT11 ( -STORE_NBR INT, -M7 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT12; -CREATE TABLE eatwh1.EATWH1_FT12 ( -DEPARTMENT_NBR INT, -M12 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT13; -CREATE TABLE eatwh1.EATWH1_FT13 ( -DEPARTMENT_NBR INT, -CLASS_NBR INT, -M13 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT14; -CREATE TABLE eatwh1.EATWH1_FT14 ( -MARKET_NBR INT, -M14 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT15; -CREATE TABLE eatwh1.EATWH1_FT15 ( -REGION_NBR INT, -M14 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT17; -CREATE TABLE eatwh1.EATWH1_FT17 ( -MARKET_NBR INT, -WEEK_ID INT, -M8 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT2; -CREATE TABLE eatwh1.EATWH1_FT2 ( -STORE_NBR INT, -MONTH_ID INT, -M3 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT3; -CREATE TABLE eatwh1.EATWH1_FT3 ( -STORE_NBR INT, -CLASS_NBR INT, -M1 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT4; -CREATE TABLE eatwh1.EATWH1_FT4 ( -STORE_NBR INT, -CLASS_NBR INT, -MONTH_ID INT, -ACCT_MONTH_DESC string, -M3 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT5; -CREATE TABLE eatwh1.EATWH1_FT5 ( -REGION_NBR INT, -DEPARTMENT_NBR INT, -MONTH_ID INT, -M5 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT6; -CREATE TABLE eatwh1.EATWH1_FT6 ( -REGION_NBR INT, -DEPARTMENT_NBR INT, -M6 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT7; -CREATE TABLE eatwh1.EATWH1_FT7 ( -REGION_NBR INT, -M7 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT8; -CREATE TABLE eatwh1.EATWH1_FT8 ( -STORE_NBR INT, -WEEK_ID INT, -M8 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_FT9; -CREATE TABLE eatwh1.EATWH1_FT9 ( -REGION_NBR INT, -WEEK_ID INT, -M8 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_INVENTORY_CURR; -CREATE TABLE eatwh1.EATWH1_INVENTORY_CURR ( -ITEM_ID int, -TARGET_QTY int, -EOH_QTY int, -ON_ORDER_QTY int, -UNIT_COST int, -REORDER_QTY int, -TOTAL_AMT int, -LAST_TRANS_ID string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_INVENTORY_ORDERS; -CREATE TABLE eatwh1.EATWH1_INVENTORY_ORDERS ( -ITEM_ID int, -REGION_ID int, -QUARTER_ID int, -UNITS_RECEIVED int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_INVENTORY_Q1_1997; -CREATE TABLE eatwh1.EATWH1_INVENTORY_Q1_1997 ( -ITEM_ID int, -REGION_ID int, -QUARTER_ID int, -BOH_DLL FLOAT, -EOH_DLL FLOAT, -BOH_QTY FLOAT, -EOH_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_INVENTORY_Q1_1998; -CREATE TABLE eatwh1.EATWH1_INVENTORY_Q1_1998 ( -ITEM_ID int, -REGION_ID int, -QUARTER_ID int, -BOH_DLL FLOAT, -EOH_DLL FLOAT, -BOH_QTY FLOAT, -EOH_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_INVENTORY_Q2_1997; -CREATE TABLE eatwh1.EATWH1_INVENTORY_Q2_1997 ( -ITEM_ID int, -REGION_ID int, -QUARTER_ID int, -BOH_DLL FLOAT, -EOH_DLL FLOAT, -BOH_QTY FLOAT, -EOH_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_INVENTORY_Q2_1998; -CREATE TABLE eatwh1.EATWH1_INVENTORY_Q2_1998 ( -ITEM_ID int, -REGION_ID int, -QUARTER_ID int, -BOH_DLL FLOAT, -EOH_DLL FLOAT, -BOH_QTY FLOAT, -EOH_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_INVENTORY_Q3_1997; -CREATE TABLE eatwh1.EATWH1_INVENTORY_Q3_1997 ( -ITEM_ID int, -REGION_ID int, -QUARTER_ID int, -BOH_DLL FLOAT, -EOH_DLL FLOAT, -BOH_QTY FLOAT, -EOH_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_INVENTORY_Q3_1998; -CREATE TABLE eatwh1.EATWH1_INVENTORY_Q3_1998 ( -ITEM_ID int, -REGION_ID int, -QUARTER_ID int, -BOH_DLL FLOAT, -EOH_DLL FLOAT, -BOH_QTY FLOAT, -EOH_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_INVENTORY_Q4_1997; -CREATE TABLE eatwh1.EATWH1_INVENTORY_Q4_1997 ( -ITEM_ID int, -REGION_ID int, -QUARTER_ID int, -BOH_DLL FLOAT, -EOH_DLL FLOAT, -BOH_QTY FLOAT, -EOH_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_INVENTORY_Q4_1998; -CREATE TABLE eatwh1.EATWH1_INVENTORY_Q4_1998 ( -ITEM_ID int, -REGION_ID int, -QUARTER_ID int, -BOH_DLL FLOAT, -EOH_DLL FLOAT, -BOH_QTY FLOAT, -EOH_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_CLASS; -CREATE TABLE eatwh1.EATWH1_LOOKUP_CLASS ( -CLASS_NBR INT, -CLASS_DESC string, -DEPARTMENT_NBR INT, -DIVISION_NBR INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_COLOR; -CREATE TABLE eatwh1.EATWH1_LOOKUP_COLOR ( -ITEM_COLOR_ID INT, -COLOR_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_DAY; -CREATE TABLE eatwh1.EATWH1_LOOKUP_DAY ( -CUR_TRN_DT STRING, -WEEK_ID INT, -WEEK_NBR INT, -WEEK_MONTH_NBR INT, -DAY_MONTH_NBR INT, -WEEKDAY_NBR INT, -MONTH_NBR INT, -MONTH_ID INT, -QUARTER_ID INT, -SEASON_ID INT, -YEAR_ID INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_DEMOG; -CREATE TABLE eatwh1.EATWH1_LOOKUP_DEMOG ( -DEMOG_ID INT, -DEMOG_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_DEPARTMENT; -CREATE TABLE eatwh1.EATWH1_LOOKUP_DEPARTMENT ( -DEPARTMENT_NBR INT, -DEPARTMENT_DESC string, -DIVISION_NBR INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_DIVISION; -CREATE TABLE eatwh1.EATWH1_LOOKUP_DIVISION ( -DIVISION_NBR INT, -DIVISION_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_ITEM; -CREATE TABLE eatwh1.EATWH1_LOOKUP_ITEM ( -CLASS_NBR INT, -ITEM_NBR INT, -CLASS_DESC string, -ITEM_DESC string, -DEPARTMENT_NBR INT, -DIVISION_NBR INT, -LONG_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_MANAGER; -CREATE TABLE eatwh1.EATWH1_LOOKUP_MANAGER ( -MANAGER_ID INT, -MANAGER_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_MARKET; -CREATE TABLE eatwh1.EATWH1_LOOKUP_MARKET ( -MARKET_NBR INT, -MARKET_DESC string, -REGION_NBR INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_MONTH; -CREATE TABLE eatwh1.EATWH1_LOOKUP_MONTH ( -MONTH_ID INT, -MONTH_NBR INT, -MONTH_DESC string, -ACCT_MONTH_DESC string, -QUARTER_ID INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_PRICEZONE; -CREATE TABLE eatwh1.EATWH1_LOOKUP_PRICEZONE ( -PRICEZONE_ID INT, -MARKET_NBR INT, -DEPARTMENT_NBR INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_QUAL; -CREATE TABLE eatwh1.EATWH1_LOOKUP_QUAL ( -CLASS_NBR INT, -ITEM_NBR INT, -ON_ORDER FLOAT, -STORE_NBR INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_QUARTER; -CREATE TABLE eatwh1.EATWH1_LOOKUP_QUARTER ( -QUARTER_ID INT, -QUARTER_NBR int, -QUARTER_DESC string, -SEASON_ID INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_REGION; -CREATE TABLE eatwh1.EATWH1_LOOKUP_REGION ( -REGION_NBR INT, -REGION_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_SEASON; -CREATE TABLE eatwh1.EATWH1_LOOKUP_SEASON ( -SEASON_ID INT, -SEASON_NBR int, -SEASON_DESC string, -YEAR_ID INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_SIZE; -CREATE TABLE eatwh1.EATWH1_LOOKUP_SIZE ( -ITEM_SIZE FLOAT, -SIZE_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_STATE; -CREATE TABLE eatwh1.EATWH1_LOOKUP_STATE ( -STATE_NBR int, -STATE_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_STORE; -CREATE TABLE eatwh1.EATWH1_LOOKUP_STORE ( -STORE_NBR INT, -STORE_DESC string, -MARKET_NBR INT, -REGION_NBR INT, -STATE_NBR INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_STYLE; -CREATE TABLE eatwh1.EATWH1_LOOKUP_STYLE ( -ITEM_STYLE INT, -STYLE_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_TYPE; -CREATE TABLE eatwh1.EATWH1_LOOKUP_TYPE ( -STORE_TYPE INT, -TYPE_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_WEEK; -CREATE TABLE eatwh1.EATWH1_LOOKUP_WEEK ( -WEEK_ID INT, -WEEK_NBR int, -WEEK_DESC string, -MONTH_ID INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_WEEKDAY; -CREATE TABLE eatwh1.EATWH1_LOOKUP_WEEKDAY ( -WEEKDAY_NBR INT, -WEEKDAY_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LOOKUP_YEAR; -CREATE TABLE eatwh1.EATWH1_LOOKUP_YEAR ( -YEAR_ID INT, -YEAR_NBR int, -YEAR_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_CALL_CTR; -CREATE TABLE eatwh1.EATWH1_LU_CALL_CTR ( -CALL_CTR_ID int, -CENTER_NAME string, -COUNTRY_ID int, -REGION_ID int, -DIST_CTR_ID int, -MANAGER_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_CATALOG; -CREATE TABLE eatwh1.EATWH1_LU_CATALOG ( -CAT_ID int, -CAT_DESC string, -CAT_URL string, -CAT_SHIP_COUNT int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_CATEGORY; -CREATE TABLE eatwh1.EATWH1_LU_CATEGORY ( -CATEGORY_ID int, -CATEGORY_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_COUNTRY; -CREATE TABLE eatwh1.EATWH1_LU_COUNTRY ( -COUNTRY_ID int, -COUNTRY_NAME string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_CUST_CITY; -CREATE TABLE eatwh1.EATWH1_LU_CUST_CITY ( -CUST_CITY_ID int, -CUST_CITY_NAME string, -CUST_REGION_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_CUST_REGION; -CREATE TABLE eatwh1.EATWH1_LU_CUST_REGION ( -CUST_REGION_ID int, -CUST_REGION_NAME string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_CUSTOMER; -CREATE TABLE eatwh1.EATWH1_LU_CUSTOMER ( -CUSTOMER_ID int, -CUST_FIRST_NAME string, -CUST_LAST_NAME string, -CUST_BIRTHSTRING STRING, -ADDRESS string, -INCOME_ID int, -EMAIL string, -CUST_CITY_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_DATE; -CREATE TABLE eatwh1.EATWH1_LU_DATE ( -DATE_ID STRING, -MONTH_ID int, -QUARTER_ID int, -YEAR_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_DIST_CTR; -CREATE TABLE eatwh1.EATWH1_LU_DIST_CTR ( -DIST_CTR_ID int, -DIST_CTR_NAME string, -COUNTRY_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_EMPLOYEE; -CREATE TABLE eatwh1.EATWH1_LU_EMPLOYEE ( -EMP_ID int, -EMP_LAST_NAME string, -EMP_FIRST_NAME string, -EMP_SSN int, -CALL_CTR_ID int, -DIST_CTR_ID int, -COUNTRY_ID int, -MANAGER_ID int, -SALARY int, -BIRTH_DATE STRING, -HIRE_DATE STRING -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_INCOME; -CREATE TABLE eatwh1.EATWH1_LU_INCOME ( -INCOME_ID int, -BRACKET_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_ITEM; -CREATE TABLE eatwh1.EATWH1_LU_ITEM ( -ITEM_ID int, -ITEM_NAME string, -SUPPLIER_ID int, -ITEM_FOREIGN_NAME string, -ITEM_URL string, -SUBCAT_ID int, -DISC_CD int, -ITEM_LONG_DESC string, -WARRANTY string, -UNIT_PRICE FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_MANAGER; -CREATE TABLE eatwh1.EATWH1_LU_MANAGER ( -MANAGER_ID int, -MGR_LAST_NAME string, -MGR_FIRST_NAME string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_MONTH; -CREATE TABLE eatwh1.EATWH1_LU_MONTH ( -MONTH_ID int, -MONTH_DESC string, -MONTH_OF_YEAR int, -QUARTER_ID int, -YEAR_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_MONTH_OF_YEAR; -CREATE TABLE eatwh1.EATWH1_LU_MONTH_OF_YEAR ( -MONTH_OF_YEAR int, -MONTH_OF_YEAR_NAME string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_ORDER; -CREATE TABLE eatwh1.EATWH1_LU_ORDER ( -ORDER_ID int, -CUSTOMER_ID int, -PYMT_TYPE int, -SHIPPER_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_PROMO_TYPE; -CREATE TABLE eatwh1.EATWH1_LU_PROMO_TYPE ( -PROMO_TYPE_ID int, -PROMO_TYPE_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_PROMOTION; -CREATE TABLE eatwh1.EATWH1_LU_PROMOTION ( -PROMO_SALE_ID int, -PROMO_SALE string, -PROMO_TYPE_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_PYMT_TYPE; -CREATE TABLE eatwh1.EATWH1_LU_PYMT_TYPE ( -PYMT_TYPE int, -PYMT_DESC string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_QUARTER; -CREATE TABLE eatwh1.EATWH1_LU_QUARTER ( -QUARTER_ID int, -QUARTER_DESC string, -YEAR_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_REGION; -CREATE TABLE eatwh1.EATWH1_LU_REGION ( -REGION_ID int, -REGION_NAME string, -COUNTRY_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_SHIPPER; -CREATE TABLE eatwh1.EATWH1_LU_SHIPPER ( -SHIPPER_ID int, -SHIPPER_DESC string, -CONTRACT_NBR int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_SUBCATEG; -CREATE TABLE eatwh1.EATWH1_LU_SUBCATEG ( -SUBCAT_ID int, -SUBCAT_DESC string, -CATEGORY_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_SUPPLIER; -CREATE TABLE eatwh1.EATWH1_LU_SUPPLIER ( -SUPPLIER_ID int, -SUPPLIER_NAME string, -CONTACT_LAST_NAME string, -CONTACT_FIRST_NAME string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_LU_YEAR; -CREATE TABLE eatwh1.EATWH1_LU_YEAR ( -YEAR_ID int, -YEAR_DATE STRING, -YEAR_DURATION int, -PREV_YEAR_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_MARKET_CLASS; -CREATE TABLE eatwh1.EATWH1_MARKET_CLASS ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -MARKET_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_MARKET_DEPARTMENT; -CREATE TABLE eatwh1.EATWH1_MARKET_DEPARTMENT ( -CUR_TRN_DT STRING, -DEPARTMENT_NBR INT, -MARKET_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_MARKET_DIVISION; -CREATE TABLE eatwh1.EATWH1_MARKET_DIVISION ( -CUR_TRN_DT STRING, -DIVISION_NBR INT, -MARKET_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_MARKET_ITEM; -CREATE TABLE eatwh1.EATWH1_MARKET_ITEM ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -ITEM_NBR INT, -MARKET_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_MNTH_CATEGORY_SLS; -CREATE TABLE eatwh1.EATWH1_MNTH_CATEGORY_SLS ( -CATEGORY_ID int, -MONTH_ID int, -TOT_UNIT_SALES FLOAT, -TOT_DOLLAR_SALES FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_MSI_STATS_LOG; -CREATE TABLE eatwh1.EATWH1_MSI_STATS_LOG ( -SESSIONID string, -PROJECTID int, -EVENTTIME STRING, -EVENT INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_MSI_STATS_PROP; -CREATE TABLE eatwh1.EATWH1_MSI_STATS_PROP ( -PROP_NAME string, -PROP_VAL string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_ORDER_DETAIL; -CREATE TABLE eatwh1.EATWH1_ORDER_DETAIL ( -ORDER_ID int, -CALL_CTR_ID int, -ORDER_DATE STRING, -ITEM_ID int, -QTY_SOLD FLOAT, -UNIT_PRICE FLOAT, -PROMOTION_ID int, -DISCOUNT FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_ORDER_FACT; -CREATE TABLE eatwh1.EATWH1_ORDER_FACT ( -ORDER_ID int, -EMP_ID int, -ORDER_DATE STRING, -ORDER_AMT FLOAT, -FREIGHT FLOAT, -SHIP_DATE STRING, -QTY_SOLD FLOAT, -RUSH_ORDER string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_P_DAY_DEC_94; -CREATE TABLE eatwh1.EATWH1_P_DAY_DEC_94 ( -DAY STRING, -CLASS_ID int, -ITEM_ID int, -STORE_ID int, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_P_MONTH_DEC_93; -CREATE TABLE eatwh1.EATWH1_P_MONTH_DEC_93 ( -MONTH int, -CLASS_ID int, -ITEM_ID int, -STORE_ID int, -SALES_DLR FLOAT, -SALES_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_P_WEEK_DEC_94_1; -CREATE TABLE eatwh1.EATWH1_P_WEEK_DEC_94_1 ( -WEEK int, -CLASS_ID int, -ITEM_ID int, -STORE_ID int, -SALES_DLR FLOAT, -SALES_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_P_WEEK_DEC_94_2; -CREATE TABLE eatwh1.EATWH1_P_WEEK_DEC_94_2 ( -WEEK int, -CLASS_ID int, -ITEM_ID int, -STORE_ID int, -SALES_DLR FLOAT, -SALES_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_P_WEEK_DEC_94_3; -CREATE TABLE eatwh1.EATWH1_P_WEEK_DEC_94_3 ( -WEEK int, -CLASS_ID int, -ITEM_ID int, -STORE_ID int, -SALES_DLR FLOAT, -SALES_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_PMT_INVENTORY; -CREATE TABLE eatwh1.EATWH1_PMT_INVENTORY ( -QUARTER_ID int, -PBTNAME string -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_PRODUCT_DETAIL; -CREATE TABLE eatwh1.EATWH1_PRODUCT_DETAIL ( -ITEM_ID int, -QUARTER_ID int, -QTY_PER_UNIT int, -DISCOUNT_PRICE FLOAT, -UNIT_COST FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_PROMOTIONS; -CREATE TABLE eatwh1.EATWH1_PROMOTIONS ( -ITEM_ID int, -QUARTER_ID int, -DISCOUNT FLOAT, -PROMO_SALE_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_QTR_CATEGORY_SLS; -CREATE TABLE eatwh1.EATWH1_QTR_CATEGORY_SLS ( -CATEGORY_ID int, -QUARTER_ID int, -TOT_UNIT_SALES FLOAT, -TOT_DOLLAR_SALES FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_REGION_CLASS; -CREATE TABLE eatwh1.EATWH1_REGION_CLASS ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -REGION_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_REGION_DEPARTMENT; -CREATE TABLE eatwh1.EATWH1_REGION_DEPARTMENT ( -CUR_TRN_DT STRING, -DEPARTMENT_NBR INT, -REGION_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_REGION_DIVISION; -CREATE TABLE eatwh1.EATWH1_REGION_DIVISION ( -CUR_TRN_DT STRING, -DIVISION_NBR INT, -REGION_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_REGION_ITEM; -CREATE TABLE eatwh1.EATWH1_REGION_ITEM ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -ITEM_NBR INT, -REGION_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_REL_CAT_ITEM; -CREATE TABLE eatwh1.EATWH1_REL_CAT_ITEM ( -ITEM_ID int, -CAT_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_RELATE_ITEM_COLOR; -CREATE TABLE eatwh1.EATWH1_RELATE_ITEM_COLOR ( -CLASS_NBR INT, -ITEM_NBR INT, -ITEM_COLOR_ID INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_RELATE_ITEM_SIZE; -CREATE TABLE eatwh1.EATWH1_RELATE_ITEM_SIZE ( -CLASS_NBR INT, -ITEM_NBR INT, -ITEM_SIZE INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_RELATE_ITEM_STYLE; -CREATE TABLE eatwh1.EATWH1_RELATE_ITEM_STYLE ( -CLASS_NBR INT, -ITEM_NBR INT, -ITEM_STYLE INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_RELATE_LY_LW; -CREATE TABLE eatwh1.EATWH1_RELATE_LY_LW ( -CUR_TRN_DT STRING, -LAST_YEAR_DATE STRING, -LAST_MONTH_DATE STRING, -LAST_WEEK_DATE STRING -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_RELATE_MTD; -CREATE TABLE eatwh1.EATWH1_RELATE_MTD ( -CUR_TRN_DT STRING, -MONTH_TO_DATE STRING -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_RELATE_REGION_MAN; -CREATE TABLE eatwh1.EATWH1_RELATE_REGION_MAN ( -REGION_NBR INT, -MANAGER_ID INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_RELATE_STORE_DEMOG; -CREATE TABLE eatwh1.EATWH1_RELATE_STORE_DEMOG ( -STORE_NBR INT, -DEMOG_ID INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_RELATE_STORE_TYPE; -CREATE TABLE eatwh1.EATWH1_RELATE_STORE_TYPE ( -STORE_NBR INT, -STORE_TYPE INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_RUSH_ORDER; -CREATE TABLE eatwh1.EATWH1_RUSH_ORDER ( -ORDER_ID int, -CUSTOMER_ID int, -EMP_ID int, -ORDER_DATE STRING, -ORDER_AMT FLOAT, -RUSH_CHARGE FLOAT, -SHIP_CHARGE FLOAT, -AMT_PAID FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_SEPERATE_FACT; -CREATE TABLE eatwh1.EATWH1_SEPERATE_FACT ( -YEAR_ID INT, -YEAR_DESC string, -TOTALQTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_STORE_CLASS; -CREATE TABLE eatwh1.EATWH1_STORE_CLASS ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -STORE_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT, -QUAL INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_STORE_DEPARTMENT; -CREATE TABLE eatwh1.EATWH1_STORE_DEPARTMENT ( -CUR_TRN_DT STRING, -DEPARTMENT_NBR INT, -STORE_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_STORE_DIVISION; -CREATE TABLE eatwh1.EATWH1_STORE_DIVISION ( -CUR_TRN_DT STRING, -DIVISION_NBR INT, -STORE_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY FLOAT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY FLOAT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY FLOAT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY FLOAT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY FLOAT, -BGN_CLE_STK_QTY FLOAT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY FLOAT, -END_CLE_STK_QTY FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_STORE_ITEM_93; -CREATE TABLE eatwh1.EATWH1_STORE_ITEM_93 ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -ITEM_NBR INT, -STORE_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY INT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY INT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY INT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY INT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY INT, -BGN_CLE_STK_QTY INT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY INT, -END_CLE_STK_QTY INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_STORE_ITEM_93_HETERO; -CREATE TABLE eatwh1.EATWH1_STORE_ITEM_93_HETERO ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -ITEM_NBR INT, -STORE_NBR INT, -DLR_93 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_STORE_ITEM_94; -CREATE TABLE eatwh1.EATWH1_STORE_ITEM_94 ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -ITEM_NBR INT, -STORE_NBR INT, -REG_SLS_DLR FLOAT, -REG_SLS_QTY INT, -PML_SLS_DLR FLOAT, -PML_SLS_QTY INT, -CLE_SLS_DLR FLOAT, -CLE_SLS_QTY INT, -PLN_SLS_DLR FLOAT, -TOT_SLS_DLR FLOAT, -TOT_SLS_QTY INT, -BGN_REG_STK_DLR FLOAT, -BGN_CLE_STK_DLR FLOAT, -BGN_REG_STK_QTY INT, -BGN_CLE_STK_QTY INT, -END_REG_STK_DLR FLOAT, -END_CLE_STK_DLR FLOAT, -END_REG_STK_QTY INT, -END_CLE_STK_QTY INT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_STORE_ITEM_94_HETERO; -CREATE TABLE eatwh1.EATWH1_STORE_ITEM_94_HETERO ( -CUR_TRN_DT STRING, -CLASS_NBR INT, -ITEM_NBR INT, -STORE_NBR INT, -DLR_94 FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_STORE_ITEM_ORDERS; -CREATE TABLE eatwh1.EATWH1_STORE_ITEM_ORDERS ( -CLASS_NBR INT, -ITEM_NBR INT, -STORE_NBR INT, -ON_ORDER FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_STORE_ITEM_PTMAP; -CREATE TABLE eatwh1.EATWH1_STORE_ITEM_PTMAP ( -YEAR_ID INT, -PBTNAME string, -DDBSOURCE FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_TE_TRANS_STATISTICS; -CREATE TABLE eatwh1.EATWH1_TE_TRANS_STATISTICS ( -SERVER_ID string, -MACHINE string, -TRANS_ID string, -TRANS_TYPE string, -TRANS_PARA string, -TRANS_RESULT string, -START_TIME FLOAT, -END_TIME FLOAT, -CUR_TRANS int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_TRANS_DATE_LW_LY; -CREATE TABLE eatwh1.EATWH1_TRANS_DATE_LW_LY ( -DATE_ID STRING, -LW_DATE_ID STRING, -LY_DATE_ID STRING -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_TRANS_DATE_MTD; -CREATE TABLE eatwh1.EATWH1_TRANS_DATE_MTD ( -DATE_ID STRING, -MTD_DATE_ID STRING -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_TRANS_MONTH_LY; -CREATE TABLE eatwh1.EATWH1_TRANS_MONTH_LY ( -MONTH_ID int, -LY_MONTH_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_TRANS_QUARTER_LY; -CREATE TABLE eatwh1.EATWH1_TRANS_QUARTER_LY ( -QUARTER_ID int, -LY_QUARTER_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_TRANS_YEAR_LY; -CREATE TABLE eatwh1.EATWH1_TRANS_YEAR_LY ( -YEAR_ID int, -LY_YEAR_ID int -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile; - -DROP TABLE IF EXISTS eatwh1.EATWH1_YR_CATEGORY_SLS; -CREATE TABLE eatwh1.EATWH1_YR_CATEGORY_SLS ( -CATEGORY_ID int, -YEAR_ID int, -TOT_UNIT_SALES FLOAT, -TOT_DOLLAR_SALES FLOAT -) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/bd294732/testdata/data/mstr/eatwh1/LoadTablesEATWH1.sql ---------------------------------------------------------------------- diff --git a/testdata/data/mstr/eatwh1/LoadTablesEATWH1.sql b/testdata/data/mstr/eatwh1/LoadTablesEATWH1.sql deleted file mode 100644 index 1f748e8..0000000 --- a/testdata/data/mstr/eatwh1/LoadTablesEATWH1.sql +++ /dev/null @@ -1,130 +0,0 @@ -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/COST_MARKET_CLASS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_COST_MARKET_CLASS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/COST_MARKET_DEP.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_COST_MARKET_DEP; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/COST_MARKET_DIV.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_COST_MARKET_DIV; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/COST_REGION_CLASS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_COST_REGION_CLASS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/COST_REGION_ITEM.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_COST_REGION_ITEM; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/COST_STORE_DEP.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_COST_STORE_DEP; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/COST_STORE_ITEM.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_COST_STORE_ITEM; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT1.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT1; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT10.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT10; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT11.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT11; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT12.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT12; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT13.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT13; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT14.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT14; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT15.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT15; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT17.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT17; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT2.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT2; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT3.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT3; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT4.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT4; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT5.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT5; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT6.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT6; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT7.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT7; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT8.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT8; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/FT9.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_FT9; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/INVENTORY_CURR.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_INVENTORY_CURR; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/INVENTORY_ORDERS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_INVENTORY_ORDERS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/INVENTORY_Q1_1997.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_INVENTORY_Q1_1997; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/INVENTORY_Q1_1998.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_INVENTORY_Q1_1998; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/INVENTORY_Q2_1997.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_INVENTORY_Q2_1997; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/INVENTORY_Q2_1998.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_INVENTORY_Q2_1998; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/INVENTORY_Q3_1997.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_INVENTORY_Q3_1997; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/INVENTORY_Q3_1998.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_INVENTORY_Q3_1998; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/INVENTORY_Q4_1997.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_INVENTORY_Q4_1997; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/INVENTORY_Q4_1998.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_INVENTORY_Q4_1998; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_CLASS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_CLASS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_COLOR.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_COLOR; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_DAY.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_DAY; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_DEMOG.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_DEMOG; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_DEPARTMENT.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_DEPARTMENT; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_DIVISION.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_DIVISION; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_ITEM.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_ITEM; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_MANAGER.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_MANAGER; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_MARKET.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_MARKET; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_MONTH.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_MONTH; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_PRICEZONE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_PRICEZONE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_QUAL.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_QUAL; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_QUARTER.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_QUARTER; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_REGION.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_REGION; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_SEASON.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_SEASON; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_SIZE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_SIZE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_STATE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_STATE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_STORE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_STORE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_STYLE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_STYLE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_TYPE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_TYPE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_WEEK.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_WEEK; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_WEEKDAY.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_WEEKDAY; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LOOKUP_YEAR.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LOOKUP_YEAR; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_CALL_CTR.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_CALL_CTR; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_CATALOG.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_CATALOG; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_CATEGORY.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_CATEGORY; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_COUNTRY.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_COUNTRY; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_CUSTOMER.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_CUSTOMER; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_CUST_CITY.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_CUST_CITY; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_CUST_REGION.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_CUST_REGION; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_DATE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_DATE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_DIST_CTR.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_DIST_CTR; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_EMPLOYEE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_EMPLOYEE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_INCOME.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_INCOME; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_ITEM.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_ITEM; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_MANAGER.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_MANAGER; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_MONTH.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_MONTH; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_MONTH_OF_YEAR.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_MONTH_OF_YEAR; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_ORDER.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_ORDER; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_PROMOTION.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_PROMOTION; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_PROMO_TYPE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_PROMO_TYPE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_PYMT_TYPE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_PYMT_TYPE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_QUARTER.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_QUARTER; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_REGION.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_REGION; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_SHIPPER.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_SHIPPER; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_SUBCATEG.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_SUBCATEG; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_SUPPLIER.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_SUPPLIER; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/LU_YEAR.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_LU_YEAR; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/MARKET_CLASS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_MARKET_CLASS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/MARKET_DEPARTMENT.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_MARKET_DEPARTMENT; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/MARKET_DIVISION.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_MARKET_DIVISION; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/MARKET_ITEM.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_MARKET_ITEM; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/MNTH_CATEGORY_SLS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_MNTH_CATEGORY_SLS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/MSI_STATS_LOG.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_MSI_STATS_LOG; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/MSI_STATS_PROP.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_MSI_STATS_PROP; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/ORDER_DETAIL.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_ORDER_DETAIL; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/ORDER_FACT.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_ORDER_FACT; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/PMT_INVENTORY.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_PMT_INVENTORY; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/PRODUCT_DETAIL.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_PRODUCT_DETAIL; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/PROMOTIONS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_PROMOTIONS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/P_DAY_DEC_94.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_P_DAY_DEC_94; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/P_MONTH_DEC_93.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_P_MONTH_DEC_93; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/P_WEEK_DEC_94_1.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_P_WEEK_DEC_94_1; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/P_WEEK_DEC_94_2.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_P_WEEK_DEC_94_2; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/P_WEEK_DEC_94_3.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_P_WEEK_DEC_94_3; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/QTR_CATEGORY_SLS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_QTR_CATEGORY_SLS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/REGION_CLASS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_REGION_CLASS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/REGION_DEPARTMENT.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_REGION_DEPARTMENT; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/REGION_DIVISION.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_REGION_DIVISION; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/REGION_ITEM.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_REGION_ITEM; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/RELATE_ITEM_COLOR.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_RELATE_ITEM_COLOR; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/RELATE_ITEM_SIZE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_RELATE_ITEM_SIZE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/RELATE_ITEM_STYLE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_RELATE_ITEM_STYLE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/RELATE_LY_LW.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_RELATE_LY_LW; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/RELATE_MTD.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_RELATE_MTD; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/RELATE_REGION_MAN.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_RELATE_REGION_MAN; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/RELATE_STORE_DEMOG.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_RELATE_STORE_DEMOG; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/RELATE_STORE_TYPE.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_RELATE_STORE_TYPE; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/REL_CAT_ITEM.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_REL_CAT_ITEM; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/RUSH_ORDER.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_RUSH_ORDER; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/SEPERATE_FACT.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_SEPERATE_FACT; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/STORE_CLASS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_STORE_CLASS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/STORE_DEPARTMENT.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_STORE_DEPARTMENT; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/STORE_DIVISION.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_STORE_DIVISION; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/STORE_ITEM_93.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_STORE_ITEM_93; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/STORE_ITEM_93_HETERO.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_STORE_ITEM_93_HETERO; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/STORE_ITEM_94.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_STORE_ITEM_94; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/STORE_ITEM_94_HETERO.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_STORE_ITEM_94_HETERO; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/STORE_ITEM_ORDERS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_STORE_ITEM_ORDERS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/STORE_ITEM_PTMAP.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_STORE_ITEM_PTMAP; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/TE_TRANS_STATISTICS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_TE_TRANS_STATISTICS; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/TRANS_DATE_LW_LY.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_TRANS_DATE_LW_LY; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/TRANS_DATE_MTD.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_TRANS_DATE_MTD; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/TRANS_MONTH_LY.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_TRANS_MONTH_LY; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/TRANS_QUARTER_LY.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_TRANS_QUARTER_LY; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/TRANS_YEAR_LY.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_TRANS_YEAR_LY; -LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh1.data.dir}/YR_CATEGORY_SLS.TXT' OVERWRITE INTO TABLE eatwh1.EATWH1_YR_CATEGORY_SLS; \ No newline at end of file
