You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by mj...@apache.org on 2016/09/14 22:21:21 UTC
[03/52] [partial] incubator-impala git commit: IMPALA-4110: Clean up
issues found by Apache RAT.
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/bd294732/testdata/data/mstr/eatwh1/csv/TRANS_MONTH_LY.TXT
----------------------------------------------------------------------
diff --git a/testdata/data/mstr/eatwh1/csv/TRANS_MONTH_LY.TXT b/testdata/data/mstr/eatwh1/csv/TRANS_MONTH_LY.TXT
deleted file mode 100644
index 00af569..0000000
--- a/testdata/data/mstr/eatwh1/csv/TRANS_MONTH_LY.TXT
+++ /dev/null
@@ -1,24 +0,0 @@
-199701,199601
-199702,199602
-199703,199603
-199704,199604
-199705,199605
-199706,199606
-199707,199607
-199708,199608
-199709,199609
-199710,199610
-199711,199611
-199712,199612
-199801,199701
-199802,199702
-199803,199703
-199804,199704
-199805,199705
-199806,199706
-199807,199707
-199808,199708
-199809,199709
-199810,199710
-199811,199711
-199812,199712
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/bd294732/testdata/data/mstr/eatwh1/csv/TRANS_QUARTER_LY.TXT
----------------------------------------------------------------------
diff --git a/testdata/data/mstr/eatwh1/csv/TRANS_QUARTER_LY.TXT b/testdata/data/mstr/eatwh1/csv/TRANS_QUARTER_LY.TXT
deleted file mode 100644
index 7c5a690..0000000
--- a/testdata/data/mstr/eatwh1/csv/TRANS_QUARTER_LY.TXT
+++ /dev/null
@@ -1,8 +0,0 @@
-199701,199601
-199702,199602
-199703,199603
-199704,199604
-199801,199701
-199802,199702
-199803,199703
-199804,199704
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/bd294732/testdata/data/mstr/eatwh1/csv/TRANS_YEAR_LY.TXT
----------------------------------------------------------------------
diff --git a/testdata/data/mstr/eatwh1/csv/TRANS_YEAR_LY.TXT b/testdata/data/mstr/eatwh1/csv/TRANS_YEAR_LY.TXT
deleted file mode 100644
index e473fb8..0000000
--- a/testdata/data/mstr/eatwh1/csv/TRANS_YEAR_LY.TXT
+++ /dev/null
@@ -1,2 +0,0 @@
-1997,1996
-1998,1997
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/bd294732/testdata/data/mstr/eatwh1/csv/YR_CATEGORY_SLS.TXT
----------------------------------------------------------------------
diff --git a/testdata/data/mstr/eatwh1/csv/YR_CATEGORY_SLS.TXT b/testdata/data/mstr/eatwh1/csv/YR_CATEGORY_SLS.TXT
deleted file mode 100644
index 4d61b75..0000000
--- a/testdata/data/mstr/eatwh1/csv/YR_CATEGORY_SLS.TXT
+++ /dev/null
@@ -1,14 +0,0 @@
-1,1997,60,10616
-1,1998,95,29299
-2,1997,155,5300
-2,1998,155,5638
-3,1997,315,16315
-3,1998,398,20047
-4,1997,136,6042
-4,1998,137,5665
-5,1997,350,38383
-5,1998,469,50391
-6,1997,135,2559
-6,1998,147,2943
-7,1997,83,4497
-7,1998,93,4792
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/bd294732/testdata/data/mstr/eatwh2/EATWH2-DDL.sql
----------------------------------------------------------------------
diff --git a/testdata/data/mstr/eatwh2/EATWH2-DDL.sql b/testdata/data/mstr/eatwh2/EATWH2-DDL.sql
deleted file mode 100644
index 3fb1709..0000000
--- a/testdata/data/mstr/eatwh2/EATWH2-DDL.sql
+++ /dev/null
@@ -1,604 +0,0 @@
-CREATE DATABASE IF NOT EXISTS eatwh2;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_BIG_ORDER_FACT;
-CREATE TABLE eatwh2.EATWH2_BIG_ORDER_FACT (
-CREDIT_CARD_ID FLOAT,
-TRANSACTION_AMOUNT FLOAT,
-Credit_Card_Order_ID FLOAT,
-Big_Float_Revenue INT,
-Big_SmallFloat_Revenue INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_CITY_CTR_SLS;
-CREATE TABLE eatwh2.EATWH2_CITY_CTR_SLS (
-CUST_CITY_ID INT,
-CALL_CTR_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_CITY_MNTH_SLS;
-CREATE TABLE eatwh2.EATWH2_CITY_MNTH_SLS (
-CUST_CITY_ID INT,
-MONTH_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_CITY_SUBCATEG_MNTH_SLS;
-CREATE TABLE eatwh2.EATWH2_CITY_SUBCATEG_MNTH_SLS (
-CUST_CITY_ID INT,
-SUBCAT_ID INT,
-MONTH_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_CITY_SUBCATEG_SLS;
-CREATE TABLE eatwh2.EATWH2_CITY_SUBCATEG_SLS (
-CUST_CITY_ID INT,
-SUBCAT_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_CUSTOMER_SLS;
-CREATE TABLE eatwh2.EATWH2_CUSTOMER_SLS (
-CUSTOMER_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_DAY_CTR_SLS;
-CREATE TABLE eatwh2.EATWH2_DAY_CTR_SLS (
-DAY_DATE string,
-CALL_CTR_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_INVENTORY_CURR;
-CREATE TABLE eatwh2.EATWH2_INVENTORY_CURR (
-ITEM_ID INT,
-TARGET_QTY FLOAT,
-EOH_QTY FLOAT,
-ON_ORDER_QTY FLOAT,
-UNIT_COST FLOAT,
-REORDER_QTY FLOAT,
-TOTAL_AMT FLOAT,
-LAST_TRANS_ID STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_INVENTORY_ORDERS;
-CREATE TABLE eatwh2.EATWH2_INVENTORY_ORDERS (
-MONTH_ID INT,
-ITEM_ID INT,
-UNITS_RECEIVED FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_INVENTORY_Q1_2000;
-CREATE TABLE eatwh2.EATWH2_INVENTORY_Q1_2000 (
-MONTH_ID INT,
-ITEM_ID INT,
-BOH_QTY FLOAT,
-EOH_QTY FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_INVENTORY_Q1_2001;
-CREATE TABLE eatwh2.EATWH2_INVENTORY_Q1_2001 (
-MONTH_ID INT,
-ITEM_ID INT,
-BOH_QTY FLOAT,
-EOH_QTY FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_INVENTORY_Q2_2000;
-CREATE TABLE eatwh2.EATWH2_INVENTORY_Q2_2000 (
-MONTH_ID INT,
-ITEM_ID INT,
-BOH_QTY FLOAT,
-EOH_QTY FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_INVENTORY_Q2_2001;
-CREATE TABLE eatwh2.EATWH2_INVENTORY_Q2_2001 (
-MONTH_ID INT,
-ITEM_ID INT,
-BOH_QTY FLOAT,
-EOH_QTY FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_INVENTORY_Q3_2000;
-CREATE TABLE eatwh2.EATWH2_INVENTORY_Q3_2000 (
-MONTH_ID INT,
-ITEM_ID INT,
-BOH_QTY FLOAT,
-EOH_QTY FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_INVENTORY_Q3_2001;
-CREATE TABLE eatwh2.EATWH2_INVENTORY_Q3_2001 (
-MONTH_ID INT,
-ITEM_ID INT,
-BOH_QTY FLOAT,
-EOH_QTY FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_INVENTORY_Q4_2000;
-CREATE TABLE eatwh2.EATWH2_INVENTORY_Q4_2000 (
-MONTH_ID INT,
-ITEM_ID INT,
-BOH_QTY FLOAT,
-EOH_QTY FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_INVENTORY_Q4_2001;
-CREATE TABLE eatwh2.EATWH2_INVENTORY_Q4_2001 (
-MONTH_ID INT,
-ITEM_ID INT,
-BOH_QTY FLOAT,
-EOH_QTY FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_ITEM_EMP_SLS;
-CREATE TABLE eatwh2.EATWH2_ITEM_EMP_SLS (
-ITEM_ID INT,
-EMP_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_ITEM_MNTH_CTR_SLS;
-CREATE TABLE eatwh2.EATWH2_ITEM_MNTH_CTR_SLS (
-ITEM_ID INT,
-MONTH_ID INT,
-CALL_CTR_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_ITEM_MNTH_SLS;
-CREATE TABLE eatwh2.EATWH2_ITEM_MNTH_SLS (
-ITEM_ID INT,
-MONTH_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_BRAND;
-CREATE TABLE eatwh2.EATWH2_LU_BRAND (
-BRAND_ID INT,
-BRAND_DESC STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_CALL_CTR;
-CREATE TABLE eatwh2.EATWH2_LU_CALL_CTR (
-CALL_CTR_ID INT,
-CENTER_NAME STRING,
-REGION_ID INT,
-MANAGER_ID INT,
-COUNTRY_ID INT,
-DIST_CTR_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_CATALOG;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_LU_CATEGORY;
-CREATE TABLE eatwh2.EATWH2_LU_CATEGORY (
-CATEGORY_ID INT,
-CATEGORY_DESC STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_COUNTRY;
-CREATE TABLE eatwh2.EATWH2_LU_COUNTRY (
-COUNTRY_ID INT,
-COUNTRY_NAME STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_COUNTRY_MANAGER;
-CREATE TABLE eatwh2.EATWH2_LU_COUNTRY_MANAGER (
-COUNTRY_ID SMALLINT,
-COUNTRY_MANAGER_ID SMALLINT,
-COUNTRY_MANAGER_NAME STRING,
-EFF_DT string,
-END_DT string
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_CUST_CITY;
-CREATE TABLE eatwh2.EATWH2_LU_CUST_CITY (
-CUST_CITY_ID INT,
-CUST_CITY_NAME STRING,
-CUST_STATE_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_CUST_REGION;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_LU_CUST_STATE;
-CREATE TABLE eatwh2.EATWH2_LU_CUST_STATE (
-CUST_STATE_ID INT,
-CUST_STATE_NAME STRING,
-CUST_REGION_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_CUSTOMER;
-CREATE TABLE eatwh2.EATWH2_LU_CUSTOMER (
-CUSTOMER_ID INT,
-CUST_LAST_NAME STRING,
-CUST_FIRST_NAME STRING,
-CUST_BIRTHDATE string,
-EMAIL STRING,
-ADDRESS STRING,
-ZIPCODE STRING,
-INCOME_ID INT,
-CUST_CITY_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_DAY;
-CREATE TABLE eatwh2.EATWH2_LU_DAY (
-DAY_DATE string,
-MONTH_ID INT,
-QUARTER_ID INT,
-YEAR_ID INT,
-PREV_DAY_DATE string,
-LM_DAY_DATE string,
-LQ_DAY_DATE string,
-LY_DAY_DATE string
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_DIST_CTR;
-CREATE TABLE eatwh2.EATWH2_LU_DIST_CTR (
-COUNTRY_ID INT,
-DIST_CTR_ID INT,
-DIST_CTR_NAME STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_EMPLOYEE;
-CREATE TABLE eatwh2.EATWH2_LU_EMPLOYEE (
-EMP_ID INT,
-EMP_LAST_NAME STRING,
-EMP_FIRST_NAME STRING,
-EMP_SSN STRING,
-BIRTH_DATE string,
-HIRE_DATE string,
-SALARY INT,
-COUNTRY_ID INT,
-DIST_CTR_ID INT,
-MANAGER_ID INT,
-CALL_CTR_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_INCOME;
-CREATE TABLE eatwh2.EATWH2_LU_INCOME (
-INCOME_ID INT,
-BRACKET_DESC STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_ITEM;
-CREATE TABLE eatwh2.EATWH2_LU_ITEM (
-ITEM_ID INT,
-ITEM_NAME STRING,
-ITEM_LONG_DESC STRING,
-ITEM_FOREIGN_NAME STRING,
-ITEM_URL STRING,
-DISC_CD INT,
-WARRANTY STRING,
-UNIT_PRICE FLOAT,
-UNIT_COST FLOAT,
-SUBCAT_ID INT,
-SUPPLIER_ID INT,
-BRAND_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_MANAGER;
-CREATE TABLE eatwh2.EATWH2_LU_MANAGER (
-MANAGER_ID INT,
-MGR_LAST_NAME STRING,
-MGR_FIRST_NAME STRING,
-EMAIL STRING,
-ADDRESS_DISPLAY STRING,
-DEVICE_ID STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_MONTH;
-CREATE TABLE eatwh2.EATWH2_LU_MONTH (
-MONTH_ID INT,
-MONTH_DATE string,
-MONTH_DESC STRING,
-MONTH_OF_YEAR INT,
-QUARTER_ID INT,
-YEAR_ID INT,
-MONTH_DURATION INT,
-PREV_MONTH_ID INT,
-LQ_MONTH_ID INT,
-LY_MONTH_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_MONTH_OF_YEAR;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_LU_ORDER;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_LU_PROMO_TYPE;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_LU_PROMOTION;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_LU_PYMT_TYPE;
-CREATE TABLE eatwh2.EATWH2_LU_PYMT_TYPE (
-PYMT_TYPE INT,
-PYMT_DESC STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_QUARTER;
-CREATE TABLE eatwh2.EATWH2_LU_QUARTER (
-QUARTER_ID INT,
-QUARTER_DATE string,
-QUARTER_DESC STRING,
-YEAR_ID INT,
-QUARTER_DURATION INT,
-PREV_QUARTER_ID INT,
-LY_QUARTER_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_LU_REGION;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_LU_SHIPPER;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_LU_SUBCATEG;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_LU_SUPPLIER;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_LU_YEAR;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_MNTH_CATEGORY_SLS;
-CREATE TABLE eatwh2.EATWH2_MNTH_CATEGORY_SLS (
-MONTH_ID INT,
-CATEGORY_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_MSI_STATS_LOG;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_MSI_STATS_PROP;
-CREATE TABLE eatwh2.EATWH2_MSI_STATS_PROP (
-PROP_NAME STRING,
-PROP_VAL STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_MTD_DAY;
-CREATE TABLE eatwh2.EATWH2_MTD_DAY (
-DAY_DATE string,
-MTD_DAY_DATE string
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_ORDER_DETAIL;
-CREATE TABLE eatwh2.EATWH2_ORDER_DETAIL (
-ORDER_ID INT,
-ITEM_ID INT,
-ORDER_DATE string,
-EMP_ID INT,
-PROMOTION_ID INT,
-QTY_SOLD FLOAT,
-UNIT_PRICE FLOAT,
-UNIT_COST FLOAT,
-DISCOUNT FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_ORDER_FACT;
-CREATE TABLE eatwh2.EATWH2_ORDER_FACT (
-ORDER_ID INT,
-ORDER_DATE string,
-EMP_ID INT,
-ORDER_AMT FLOAT,
-ORDER_COST FLOAT,
-QTY_SOLD FLOAT,
-FREIGHT FLOAT,
-SHIP_DATE string,
-RUSH_ORDER STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_PMT_INVENTORY;
-CREATE TABLE eatwh2.EATWH2_PMT_INVENTORY (
-QUARTER_ID INT,
-PBTNAME STRING
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_PROMOTIONS;
-CREATE TABLE eatwh2.EATWH2_PROMOTIONS (
-ITEM_ID INT,
-DAY_DATE string,
-PROMO_SALE_ID INT,
-DISCOUNT FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_QTD_DAY;
-CREATE TABLE eatwh2.EATWH2_QTD_DAY (
-DAY_DATE string,
-QTD_DAY_DATE string
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_QTR_CATEGORY_SLS;
-CREATE TABLE eatwh2.EATWH2_QTR_CATEGORY_SLS (
-QUARTER_ID INT,
-CATEGORY_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_REL_CAT_ITEM;
-CREATE TABLE eatwh2.EATWH2_REL_CAT_ITEM (
-CAT_ID INT,
-ITEM_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_REL_GROUPS;
-CREATE TABLE eatwh2.EATWH2_REL_GROUPS (
-GROUP_ID INT,
-PARENT_GROUP_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_REL_USERS_GROUPS;
-CREATE TABLE eatwh2.EATWH2_REL_USERS_GROUPS (
-GROUP_ID INT,
-USER_ID INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_RELATE_PROJECTS_CATEGORIES;
-CREATE TABLE eatwh2.EATWH2_RELATE_PROJECTS_CATEGORIES (
-PROJECT_ID INT,
-CATEGORY_ID INT,
-SUBCATEGORY_ID INT,
-RANKS INT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_RUSH_ORDER;
-CREATE TABLE eatwh2.EATWH2_RUSH_ORDER (
-ORDER_ID INT,
-RUSH_CHARGE FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_STATE_REGION_MNTH_SLS;
-CREATE TABLE eatwh2.EATWH2_STATE_REGION_MNTH_SLS (
-CUST_STATE_ID INT,
-REGION_ID INT,
-MONTH_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_STATE_SUBCATEG_MNTH_SLS;
-CREATE TABLE eatwh2.EATWH2_STATE_SUBCATEG_MNTH_SLS (
-CUST_STATE_ID INT,
-SUBCAT_ID INT,
-MONTH_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_STATE_SUBCATEG_REGION_SLS;
-CREATE TABLE eatwh2.EATWH2_STATE_SUBCATEG_REGION_SLS (
-CUST_STATE_ID INT,
-SUBCAT_ID INT,
-REGION_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_SUBCATEG_MNTH_CTR_SLS;
-CREATE TABLE eatwh2.EATWH2_SUBCATEG_MNTH_CTR_SLS (
-SUBCAT_ID INT,
-MONTH_ID INT,
-CALL_CTR_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_TE_TRANS_STATISTICS;
-CREATE TABLE eatwh2.EATWH2_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 eatwh2.EATWH2_YR_CATEGORY_SLS;
-CREATE TABLE eatwh2.EATWH2_YR_CATEGORY_SLS (
-YEAR_ID INT,
-CATEGORY_ID INT,
-TOT_DOLLAR_SALES FLOAT,
-TOT_UNIT_SALES FLOAT,
-TOT_COST FLOAT
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_YTD_DAY;
-CREATE TABLE eatwh2.EATWH2_YTD_DAY (
-DAY_DATE string,
-YTD_DAY_DATE string
-) row format delimited fields terminated by ',' escaped by '\\' stored as textfile;
-
-DROP TABLE IF EXISTS eatwh2.EATWH2_YTM_MONTH;
-CREATE TABLE eatwh2.EATWH2_YTM_MONTH (
-MONTH_ID INT,
-YTM_MONTH_ID INT
-) 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/eatwh2/LoadTablesEATWH2.sql
----------------------------------------------------------------------
diff --git a/testdata/data/mstr/eatwh2/LoadTablesEATWH2.sql b/testdata/data/mstr/eatwh2/LoadTablesEATWH2.sql
deleted file mode 100644
index 89c3e27..0000000
--- a/testdata/data/mstr/eatwh2/LoadTablesEATWH2.sql
+++ /dev/null
@@ -1,71 +0,0 @@
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/BIG_ORDER_FACT.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_BIG_ORDER_FACT;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/CITY_CTR_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_CITY_CTR_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/CITY_MNTH_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_CITY_MNTH_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/CITY_SUBCATEG_MNTH_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_CITY_SUBCATEG_MNTH_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/CITY_SUBCATEG_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_CITY_SUBCATEG_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/CUSTOMER_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_CUSTOMER_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/DAY_CTR_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_DAY_CTR_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/INVENTORY_CURR.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_INVENTORY_CURR;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/INVENTORY_ORDERS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_INVENTORY_ORDERS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/INVENTORY_Q1_2000.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_INVENTORY_Q1_2000;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/INVENTORY_Q1_2001.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_INVENTORY_Q1_2001;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/INVENTORY_Q2_2000.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_INVENTORY_Q2_2000;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/INVENTORY_Q2_2001.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_INVENTORY_Q2_2001;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/INVENTORY_Q3_2000.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_INVENTORY_Q3_2000;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/INVENTORY_Q3_2001.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_INVENTORY_Q3_2001;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/INVENTORY_Q4_2000.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_INVENTORY_Q4_2000;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/INVENTORY_Q4_2001.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_INVENTORY_Q4_2001;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/ITEM_EMP_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_ITEM_EMP_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/ITEM_MNTH_CTR_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_ITEM_MNTH_CTR_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/ITEM_MNTH_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_ITEM_MNTH_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_BRAND.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_BRAND;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_CALL_CTR.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_CALL_CTR;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_CATALOG.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_CATALOG;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_CATEGORY.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_CATEGORY;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_COUNTRY.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_COUNTRY;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_COUNTRY_MANAGER.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_COUNTRY_MANAGER;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_CUSTOMER.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_CUSTOMER;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_CUST_CITY.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_CUST_CITY;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_CUST_REGION.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_CUST_REGION;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_CUST_STATE.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_CUST_STATE;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_DAY.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_DAY;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_DIST_CTR.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_DIST_CTR;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_EMPLOYEE.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_EMPLOYEE;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_INCOME.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_INCOME;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_ITEM.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_ITEM;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_MANAGER.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_MANAGER;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_MONTH.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_MONTH;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_MONTH_OF_YEAR.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_MONTH_OF_YEAR;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_ORDER.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_ORDER;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_PROMOTION.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_PROMOTION;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_PROMO_TYPE.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_PROMO_TYPE;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_PYMT_TYPE.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_PYMT_TYPE;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_QUARTER.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_QUARTER;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_REGION.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_REGION;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_SHIPPER.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_SHIPPER;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_SUBCATEG.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_SUBCATEG;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_SUPPLIER.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_SUPPLIER;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/LU_YEAR.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_LU_YEAR;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/MNTH_CATEGORY_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_MNTH_CATEGORY_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/MSI_STATS_LOG.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_MSI_STATS_LOG;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/MSI_STATS_PROP.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_MSI_STATS_PROP;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/MTD_DAY.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_MTD_DAY;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/ORDER_DETAIL.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_ORDER_DETAIL;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/ORDER_FACT.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_ORDER_FACT;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/PMT_INVENTORY.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_PMT_INVENTORY;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/PROMOTIONS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_PROMOTIONS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/QTD_DAY.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_QTD_DAY;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/QTR_CATEGORY_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_QTR_CATEGORY_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/RELATE_PROJECTS_CATEGORIES.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_RELATE_PROJECTS_CATEGORIES;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/REL_CAT_ITEM.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_REL_CAT_ITEM;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/REL_GROUPS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_REL_GROUPS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/REL_USERS_GROUPS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_REL_USERS_GROUPS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/RUSH_ORDER.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_RUSH_ORDER;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/STATE_REGION_MNTH_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_STATE_REGION_MNTH_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/STATE_SUBCATEG_MNTH_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_STATE_SUBCATEG_MNTH_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/STATE_SUBCATEG_REGION_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_STATE_SUBCATEG_REGION_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/SUBCATEG_MNTH_CTR_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_SUBCATEG_MNTH_CTR_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/TE_TRANS_STATISTICS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_TE_TRANS_STATISTICS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/YR_CATEGORY_SLS.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_YR_CATEGORY_SLS;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/YTD_DAY.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_YTD_DAY;
-LOAD DATA LOCAL INPATH '${hiveconf:mstr.eatwh2.data.dir}/YTM_MONTH.TXT' OVERWRITE INTO TABLE eatwh2.EATWH2_YTM_MONTH;