[46/51] [abbrv] [partial] incubator-impala git commit: IMPALA-4110: Clean up issues found by Apache RAT.

[jb...@apache.org]

http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/d385ac72/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/d385ac72/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