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;
