framework/resources/Datasources/hive_storage/md1119.ddl

DROP TABLE IF EXISTS md1119_parquet;
CREATE EXTERNAL TABLE md1119_parquet (
  `bz_date` string, 
  `effectivedate` string, 
  `effectivedateint` int, 
  `load_data_time` string, 
  `sourcesystemid` string, 
  `version` int, 
  `tag` int, 
  `vmdr_trade_id` string, 
  `src_trade_id` string, 
  `product_group` string, 
  `product_subgroup` string, 
  `product_description` string, 
  `inventory_master_id` int, 
  `src_trading_book` string, 
  `trade_date` string, 
  `settlement_date` string, 
  `last_lifecycle_date` string, 
  `last_lifecycle_event` string, 
  `trade_status` string, 
  `cid_legal_id` string, 
  `cid_short_name` string, 
  `src_cpty_id` string, 
  `src_cpty_short_name` string, 
  `iscustomer` string, 
  `iscustomerbasis` string, 
  `isasset` string, 
  `isassetbasis` string, 
  `wastradedtoday` string, 
  `wastradedtodaybasis` string, 
  `iscashtrade` string, 
  `trade_value_usd` string, 
  `trade_value_usdbasis` string, 
  `current_close_price` string, 
  `execution_price` string, 
  `trade_npv_usd` string, 
  `commodity_volume` string, 
  `signed_current_notional_usd` string, 
  `aged_days` string, 
  `trade_ccy` string, 
  `settle_ccy` string, 
  `cusip` string, 
  `comprehensive_pl` string, 
  `existing_pl` string, 
  `new_position_pl` string, 
  `unexplained_pl` string, 
  `cash_flow_pl` string, 
  `carry_pl` string, 
  `pl_due_to_change_in_rf` string, 
  `other_pl` string, 
  `reserve_valuation_adj_change_pl` string, 
  `trade_change_pl` string, 
  `sourcesubsystem` string, 
  `commissions_usd` string, 
  `volcker_eligible_fees_usd` string, 
  `productid` int, 
  `isdisabled` string, 
  `pricingfactor` string, 
  `eodfxratecurrdt` string, 
  `factor` string, 
  `maturity_date` string, 
  `price_basis` string, 
  `unadjusted_notional` string, 
  `pnl_source_factor` string, 
  `notional_adjustment_basis` string, 
  `daily_cash_amt_usd` string, 
  `trade_npv_ccy` string, 
  `src_original_cpty_id` string, 
  `src_original_cpty_short_name` string, 
  `call_put_ind` string, 
  `future_option_ind` string, 
  `option_delta` string, 
  `blockid` int, 
  `allocnumber` int, 
  `frontofcsysrefid1` string, 
  `frontofcsystradeid` string, 
  `description` string, 
  `disabledon` string, 
  `exclude_from` string, 
  `exclude_from_basis` string, 
  `security_adp_nbr` string, 
  `eodfxratebasis` string, 
  `rfrnc_trans_id` string, 
  `tbaind` string, 
  `trans_rsn_cd` string, 
  `trans_to_cd` string, 
  `tbacusip` string, 
  `finance_trading_pnl` string, 
  `pnl_source_trading_pnl` string, 
  `iscustomeripm` string, 
  `iscustomeripmbasedon` string, 
  `blottercd` string, 
  `mpid` string, 
  `fistimportsource` string, 
  `quantity` string, 
  `trade01` string, 
  `finance_trading_adj` string, 
  `finance_unexplained_pl` string, 
  `holding_limit_breach` string)
  PARTITIONED BY ( 
  `businessdate` string)
STORED AS PARQUET
LOCATION
  'maprfs:/drill/testdata/md1119_parquet';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-02') location '/drill/testdata/md1119_parquet/2014-01-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-03') location '/drill/testdata/md1119_parquet/2014-01-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-04') location '/drill/testdata/md1119_parquet/2014-01-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-05') location '/drill/testdata/md1119_parquet/2014-01-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-06') location '/drill/testdata/md1119_parquet/2014-01-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-07') location '/drill/testdata/md1119_parquet/2014-01-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-08') location '/drill/testdata/md1119_parquet/2014-01-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-09') location '/drill/testdata/md1119_parquet/2014-01-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-10') location '/drill/testdata/md1119_parquet/2014-01-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-11') location '/drill/testdata/md1119_parquet/2014-01-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-12') location '/drill/testdata/md1119_parquet/2014-01-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-13') location '/drill/testdata/md1119_parquet/2014-01-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-14') location '/drill/testdata/md1119_parquet/2014-01-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-15') location '/drill/testdata/md1119_parquet/2014-01-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-16') location '/drill/testdata/md1119_parquet/2014-01-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-17') location '/drill/testdata/md1119_parquet/2014-01-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-18') location '/drill/testdata/md1119_parquet/2014-01-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-19') location '/drill/testdata/md1119_parquet/2014-01-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-20') location '/drill/testdata/md1119_parquet/2014-01-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-21') location '/drill/testdata/md1119_parquet/2014-01-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-22') location '/drill/testdata/md1119_parquet/2014-01-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-23') location '/drill/testdata/md1119_parquet/2014-01-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-24') location '/drill/testdata/md1119_parquet/2014-01-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-25') location '/drill/testdata/md1119_parquet/2014-01-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-26') location '/drill/testdata/md1119_parquet/2014-01-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-27') location '/drill/testdata/md1119_parquet/2014-01-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-28') location '/drill/testdata/md1119_parquet/2014-01-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-29') location '/drill/testdata/md1119_parquet/2014-01-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-30') location '/drill/testdata/md1119_parquet/2014-01-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-01-31') location '/drill/testdata/md1119_parquet/2014-01-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-01') location '/drill/testdata/md1119_parquet/2014-02-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-02') location '/drill/testdata/md1119_parquet/2014-02-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-03') location '/drill/testdata/md1119_parquet/2014-02-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-04') location '/drill/testdata/md1119_parquet/2014-02-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-05') location '/drill/testdata/md1119_parquet/2014-02-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-06') location '/drill/testdata/md1119_parquet/2014-02-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-07') location '/drill/testdata/md1119_parquet/2014-02-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-08') location '/drill/testdata/md1119_parquet/2014-02-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-09') location '/drill/testdata/md1119_parquet/2014-02-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-10') location '/drill/testdata/md1119_parquet/2014-02-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-11') location '/drill/testdata/md1119_parquet/2014-02-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-12') location '/drill/testdata/md1119_parquet/2014-02-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-13') location '/drill/testdata/md1119_parquet/2014-02-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-14') location '/drill/testdata/md1119_parquet/2014-02-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-15') location '/drill/testdata/md1119_parquet/2014-02-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-16') location '/drill/testdata/md1119_parquet/2014-02-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-17') location '/drill/testdata/md1119_parquet/2014-02-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-18') location '/drill/testdata/md1119_parquet/2014-02-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-19') location '/drill/testdata/md1119_parquet/2014-02-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-20') location '/drill/testdata/md1119_parquet/2014-02-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-21') location '/drill/testdata/md1119_parquet/2014-02-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-22') location '/drill/testdata/md1119_parquet/2014-02-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-23') location '/drill/testdata/md1119_parquet/2014-02-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-24') location '/drill/testdata/md1119_parquet/2014-02-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-25') location '/drill/testdata/md1119_parquet/2014-02-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-26') location '/drill/testdata/md1119_parquet/2014-02-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-27') location '/drill/testdata/md1119_parquet/2014-02-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-02-28') location '/drill/testdata/md1119_parquet/2014-02-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-01') location '/drill/testdata/md1119_parquet/2014-03-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-02') location '/drill/testdata/md1119_parquet/2014-03-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-03') location '/drill/testdata/md1119_parquet/2014-03-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-04') location '/drill/testdata/md1119_parquet/2014-03-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-05') location '/drill/testdata/md1119_parquet/2014-03-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-06') location '/drill/testdata/md1119_parquet/2014-03-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-07') location '/drill/testdata/md1119_parquet/2014-03-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-08') location '/drill/testdata/md1119_parquet/2014-03-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-09') location '/drill/testdata/md1119_parquet/2014-03-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-10') location '/drill/testdata/md1119_parquet/2014-03-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-11') location '/drill/testdata/md1119_parquet/2014-03-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-12') location '/drill/testdata/md1119_parquet/2014-03-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-13') location '/drill/testdata/md1119_parquet/2014-03-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-14') location '/drill/testdata/md1119_parquet/2014-03-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-15') location '/drill/testdata/md1119_parquet/2014-03-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-16') location '/drill/testdata/md1119_parquet/2014-03-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-17') location '/drill/testdata/md1119_parquet/2014-03-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-18') location '/drill/testdata/md1119_parquet/2014-03-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-19') location '/drill/testdata/md1119_parquet/2014-03-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-20') location '/drill/testdata/md1119_parquet/2014-03-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-21') location '/drill/testdata/md1119_parquet/2014-03-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-22') location '/drill/testdata/md1119_parquet/2014-03-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-23') location '/drill/testdata/md1119_parquet/2014-03-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-24') location '/drill/testdata/md1119_parquet/2014-03-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-25') location '/drill/testdata/md1119_parquet/2014-03-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-26') location '/drill/testdata/md1119_parquet/2014-03-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-27') location '/drill/testdata/md1119_parquet/2014-03-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-28') location '/drill/testdata/md1119_parquet/2014-03-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-29') location '/drill/testdata/md1119_parquet/2014-03-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-30') location '/drill/testdata/md1119_parquet/2014-03-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-03-31') location '/drill/testdata/md1119_parquet/2014-03-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-01') location '/drill/testdata/md1119_parquet/2014-04-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-02') location '/drill/testdata/md1119_parquet/2014-04-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-03') location '/drill/testdata/md1119_parquet/2014-04-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-04') location '/drill/testdata/md1119_parquet/2014-04-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-05') location '/drill/testdata/md1119_parquet/2014-04-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-06') location '/drill/testdata/md1119_parquet/2014-04-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-07') location '/drill/testdata/md1119_parquet/2014-04-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-08') location '/drill/testdata/md1119_parquet/2014-04-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-09') location '/drill/testdata/md1119_parquet/2014-04-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-10') location '/drill/testdata/md1119_parquet/2014-04-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-11') location '/drill/testdata/md1119_parquet/2014-04-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-12') location '/drill/testdata/md1119_parquet/2014-04-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-13') location '/drill/testdata/md1119_parquet/2014-04-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-14') location '/drill/testdata/md1119_parquet/2014-04-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-15') location '/drill/testdata/md1119_parquet/2014-04-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-16') location '/drill/testdata/md1119_parquet/2014-04-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-17') location '/drill/testdata/md1119_parquet/2014-04-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-18') location '/drill/testdata/md1119_parquet/2014-04-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-19') location '/drill/testdata/md1119_parquet/2014-04-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-20') location '/drill/testdata/md1119_parquet/2014-04-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-21') location '/drill/testdata/md1119_parquet/2014-04-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-22') location '/drill/testdata/md1119_parquet/2014-04-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-23') location '/drill/testdata/md1119_parquet/2014-04-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-24') location '/drill/testdata/md1119_parquet/2014-04-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-25') location '/drill/testdata/md1119_parquet/2014-04-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-26') location '/drill/testdata/md1119_parquet/2014-04-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-27') location '/drill/testdata/md1119_parquet/2014-04-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-28') location '/drill/testdata/md1119_parquet/2014-04-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-29') location '/drill/testdata/md1119_parquet/2014-04-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-04-30') location '/drill/testdata/md1119_parquet/2014-04-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-01') location '/drill/testdata/md1119_parquet/2014-05-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-02') location '/drill/testdata/md1119_parquet/2014-05-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-03') location '/drill/testdata/md1119_parquet/2014-05-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-04') location '/drill/testdata/md1119_parquet/2014-05-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-05') location '/drill/testdata/md1119_parquet/2014-05-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-06') location '/drill/testdata/md1119_parquet/2014-05-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-07') location '/drill/testdata/md1119_parquet/2014-05-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-08') location '/drill/testdata/md1119_parquet/2014-05-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-09') location '/drill/testdata/md1119_parquet/2014-05-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-10') location '/drill/testdata/md1119_parquet/2014-05-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-11') location '/drill/testdata/md1119_parquet/2014-05-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-12') location '/drill/testdata/md1119_parquet/2014-05-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-13') location '/drill/testdata/md1119_parquet/2014-05-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-14') location '/drill/testdata/md1119_parquet/2014-05-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-15') location '/drill/testdata/md1119_parquet/2014-05-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-16') location '/drill/testdata/md1119_parquet/2014-05-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-17') location '/drill/testdata/md1119_parquet/2014-05-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-18') location '/drill/testdata/md1119_parquet/2014-05-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-19') location '/drill/testdata/md1119_parquet/2014-05-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-20') location '/drill/testdata/md1119_parquet/2014-05-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-21') location '/drill/testdata/md1119_parquet/2014-05-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-22') location '/drill/testdata/md1119_parquet/2014-05-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-23') location '/drill/testdata/md1119_parquet/2014-05-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-24') location '/drill/testdata/md1119_parquet/2014-05-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-25') location '/drill/testdata/md1119_parquet/2014-05-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-26') location '/drill/testdata/md1119_parquet/2014-05-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-27') location '/drill/testdata/md1119_parquet/2014-05-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-28') location '/drill/testdata/md1119_parquet/2014-05-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-29') location '/drill/testdata/md1119_parquet/2014-05-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-30') location '/drill/testdata/md1119_parquet/2014-05-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-05-31') location '/drill/testdata/md1119_parquet/2014-05-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-01') location '/drill/testdata/md1119_parquet/2014-06-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-02') location '/drill/testdata/md1119_parquet/2014-06-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-03') location '/drill/testdata/md1119_parquet/2014-06-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-04') location '/drill/testdata/md1119_parquet/2014-06-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-05') location '/drill/testdata/md1119_parquet/2014-06-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-06') location '/drill/testdata/md1119_parquet/2014-06-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-07') location '/drill/testdata/md1119_parquet/2014-06-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-08') location '/drill/testdata/md1119_parquet/2014-06-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-09') location '/drill/testdata/md1119_parquet/2014-06-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-10') location '/drill/testdata/md1119_parquet/2014-06-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-11') location '/drill/testdata/md1119_parquet/2014-06-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-12') location '/drill/testdata/md1119_parquet/2014-06-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-13') location '/drill/testdata/md1119_parquet/2014-06-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-14') location '/drill/testdata/md1119_parquet/2014-06-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-15') location '/drill/testdata/md1119_parquet/2014-06-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-16') location '/drill/testdata/md1119_parquet/2014-06-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-17') location '/drill/testdata/md1119_parquet/2014-06-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-18') location '/drill/testdata/md1119_parquet/2014-06-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-19') location '/drill/testdata/md1119_parquet/2014-06-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-20') location '/drill/testdata/md1119_parquet/2014-06-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-21') location '/drill/testdata/md1119_parquet/2014-06-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-22') location '/drill/testdata/md1119_parquet/2014-06-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-23') location '/drill/testdata/md1119_parquet/2014-06-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-24') location '/drill/testdata/md1119_parquet/2014-06-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-25') location '/drill/testdata/md1119_parquet/2014-06-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-26') location '/drill/testdata/md1119_parquet/2014-06-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-27') location '/drill/testdata/md1119_parquet/2014-06-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-28') location '/drill/testdata/md1119_parquet/2014-06-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-29') location '/drill/testdata/md1119_parquet/2014-06-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-06-30') location '/drill/testdata/md1119_parquet/2014-06-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-01') location '/drill/testdata/md1119_parquet/2014-07-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-02') location '/drill/testdata/md1119_parquet/2014-07-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-03') location '/drill/testdata/md1119_parquet/2014-07-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-04') location '/drill/testdata/md1119_parquet/2014-07-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-05') location '/drill/testdata/md1119_parquet/2014-07-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-06') location '/drill/testdata/md1119_parquet/2014-07-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-07') location '/drill/testdata/md1119_parquet/2014-07-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-08') location '/drill/testdata/md1119_parquet/2014-07-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-09') location '/drill/testdata/md1119_parquet/2014-07-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-10') location '/drill/testdata/md1119_parquet/2014-07-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-11') location '/drill/testdata/md1119_parquet/2014-07-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-12') location '/drill/testdata/md1119_parquet/2014-07-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-13') location '/drill/testdata/md1119_parquet/2014-07-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-14') location '/drill/testdata/md1119_parquet/2014-07-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-15') location '/drill/testdata/md1119_parquet/2014-07-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-16') location '/drill/testdata/md1119_parquet/2014-07-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-17') location '/drill/testdata/md1119_parquet/2014-07-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-18') location '/drill/testdata/md1119_parquet/2014-07-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-19') location '/drill/testdata/md1119_parquet/2014-07-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-20') location '/drill/testdata/md1119_parquet/2014-07-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-21') location '/drill/testdata/md1119_parquet/2014-07-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-22') location '/drill/testdata/md1119_parquet/2014-07-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-23') location '/drill/testdata/md1119_parquet/2014-07-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-24') location '/drill/testdata/md1119_parquet/2014-07-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-25') location '/drill/testdata/md1119_parquet/2014-07-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-26') location '/drill/testdata/md1119_parquet/2014-07-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-27') location '/drill/testdata/md1119_parquet/2014-07-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-28') location '/drill/testdata/md1119_parquet/2014-07-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-29') location '/drill/testdata/md1119_parquet/2014-07-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-30') location '/drill/testdata/md1119_parquet/2014-07-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-07-31') location '/drill/testdata/md1119_parquet/2014-07-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-01') location '/drill/testdata/md1119_parquet/2014-08-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-02') location '/drill/testdata/md1119_parquet/2014-08-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-03') location '/drill/testdata/md1119_parquet/2014-08-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-04') location '/drill/testdata/md1119_parquet/2014-08-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-05') location '/drill/testdata/md1119_parquet/2014-08-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-06') location '/drill/testdata/md1119_parquet/2014-08-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-07') location '/drill/testdata/md1119_parquet/2014-08-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-08') location '/drill/testdata/md1119_parquet/2014-08-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-09') location '/drill/testdata/md1119_parquet/2014-08-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-10') location '/drill/testdata/md1119_parquet/2014-08-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-11') location '/drill/testdata/md1119_parquet/2014-08-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-12') location '/drill/testdata/md1119_parquet/2014-08-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-13') location '/drill/testdata/md1119_parquet/2014-08-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-14') location '/drill/testdata/md1119_parquet/2014-08-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-15') location '/drill/testdata/md1119_parquet/2014-08-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-16') location '/drill/testdata/md1119_parquet/2014-08-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-17') location '/drill/testdata/md1119_parquet/2014-08-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-18') location '/drill/testdata/md1119_parquet/2014-08-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-19') location '/drill/testdata/md1119_parquet/2014-08-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-20') location '/drill/testdata/md1119_parquet/2014-08-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-21') location '/drill/testdata/md1119_parquet/2014-08-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-22') location '/drill/testdata/md1119_parquet/2014-08-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-23') location '/drill/testdata/md1119_parquet/2014-08-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-24') location '/drill/testdata/md1119_parquet/2014-08-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-25') location '/drill/testdata/md1119_parquet/2014-08-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-26') location '/drill/testdata/md1119_parquet/2014-08-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-27') location '/drill/testdata/md1119_parquet/2014-08-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-28') location '/drill/testdata/md1119_parquet/2014-08-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-29') location '/drill/testdata/md1119_parquet/2014-08-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-30') location '/drill/testdata/md1119_parquet/2014-08-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-08-31') location '/drill/testdata/md1119_parquet/2014-08-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-01') location '/drill/testdata/md1119_parquet/2014-09-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-02') location '/drill/testdata/md1119_parquet/2014-09-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-03') location '/drill/testdata/md1119_parquet/2014-09-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-04') location '/drill/testdata/md1119_parquet/2014-09-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-05') location '/drill/testdata/md1119_parquet/2014-09-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-06') location '/drill/testdata/md1119_parquet/2014-09-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-07') location '/drill/testdata/md1119_parquet/2014-09-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-08') location '/drill/testdata/md1119_parquet/2014-09-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-09') location '/drill/testdata/md1119_parquet/2014-09-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-10') location '/drill/testdata/md1119_parquet/2014-09-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-11') location '/drill/testdata/md1119_parquet/2014-09-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-12') location '/drill/testdata/md1119_parquet/2014-09-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-13') location '/drill/testdata/md1119_parquet/2014-09-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-14') location '/drill/testdata/md1119_parquet/2014-09-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-15') location '/drill/testdata/md1119_parquet/2014-09-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-16') location '/drill/testdata/md1119_parquet/2014-09-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-17') location '/drill/testdata/md1119_parquet/2014-09-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-18') location '/drill/testdata/md1119_parquet/2014-09-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-19') location '/drill/testdata/md1119_parquet/2014-09-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-20') location '/drill/testdata/md1119_parquet/2014-09-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-21') location '/drill/testdata/md1119_parquet/2014-09-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-22') location '/drill/testdata/md1119_parquet/2014-09-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-23') location '/drill/testdata/md1119_parquet/2014-09-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-24') location '/drill/testdata/md1119_parquet/2014-09-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-25') location '/drill/testdata/md1119_parquet/2014-09-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-26') location '/drill/testdata/md1119_parquet/2014-09-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-27') location '/drill/testdata/md1119_parquet/2014-09-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-28') location '/drill/testdata/md1119_parquet/2014-09-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-29') location '/drill/testdata/md1119_parquet/2014-09-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-09-30') location '/drill/testdata/md1119_parquet/2014-09-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-01') location '/drill/testdata/md1119_parquet/2014-10-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-02') location '/drill/testdata/md1119_parquet/2014-10-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-03') location '/drill/testdata/md1119_parquet/2014-10-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-04') location '/drill/testdata/md1119_parquet/2014-10-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-05') location '/drill/testdata/md1119_parquet/2014-10-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-06') location '/drill/testdata/md1119_parquet/2014-10-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-07') location '/drill/testdata/md1119_parquet/2014-10-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-08') location '/drill/testdata/md1119_parquet/2014-10-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-09') location '/drill/testdata/md1119_parquet/2014-10-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-10') location '/drill/testdata/md1119_parquet/2014-10-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-11') location '/drill/testdata/md1119_parquet/2014-10-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-12') location '/drill/testdata/md1119_parquet/2014-10-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-13') location '/drill/testdata/md1119_parquet/2014-10-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-14') location '/drill/testdata/md1119_parquet/2014-10-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-15') location '/drill/testdata/md1119_parquet/2014-10-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-16') location '/drill/testdata/md1119_parquet/2014-10-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-17') location '/drill/testdata/md1119_parquet/2014-10-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-18') location '/drill/testdata/md1119_parquet/2014-10-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-19') location '/drill/testdata/md1119_parquet/2014-10-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-20') location '/drill/testdata/md1119_parquet/2014-10-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-21') location '/drill/testdata/md1119_parquet/2014-10-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-22') location '/drill/testdata/md1119_parquet/2014-10-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-23') location '/drill/testdata/md1119_parquet/2014-10-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-24') location '/drill/testdata/md1119_parquet/2014-10-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-25') location '/drill/testdata/md1119_parquet/2014-10-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-26') location '/drill/testdata/md1119_parquet/2014-10-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-27') location '/drill/testdata/md1119_parquet/2014-10-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-28') location '/drill/testdata/md1119_parquet/2014-10-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-29') location '/drill/testdata/md1119_parquet/2014-10-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-30') location '/drill/testdata/md1119_parquet/2014-10-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-10-31') location '/drill/testdata/md1119_parquet/2014-10-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-01') location '/drill/testdata/md1119_parquet/2014-11-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-02') location '/drill/testdata/md1119_parquet/2014-11-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-03') location '/drill/testdata/md1119_parquet/2014-11-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-04') location '/drill/testdata/md1119_parquet/2014-11-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-05') location '/drill/testdata/md1119_parquet/2014-11-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-06') location '/drill/testdata/md1119_parquet/2014-11-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-07') location '/drill/testdata/md1119_parquet/2014-11-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-08') location '/drill/testdata/md1119_parquet/2014-11-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-09') location '/drill/testdata/md1119_parquet/2014-11-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-10') location '/drill/testdata/md1119_parquet/2014-11-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-11') location '/drill/testdata/md1119_parquet/2014-11-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-12') location '/drill/testdata/md1119_parquet/2014-11-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-13') location '/drill/testdata/md1119_parquet/2014-11-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-14') location '/drill/testdata/md1119_parquet/2014-11-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-15') location '/drill/testdata/md1119_parquet/2014-11-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-16') location '/drill/testdata/md1119_parquet/2014-11-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-17') location '/drill/testdata/md1119_parquet/2014-11-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-18') location '/drill/testdata/md1119_parquet/2014-11-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-19') location '/drill/testdata/md1119_parquet/2014-11-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-20') location '/drill/testdata/md1119_parquet/2014-11-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-21') location '/drill/testdata/md1119_parquet/2014-11-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-22') location '/drill/testdata/md1119_parquet/2014-11-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-23') location '/drill/testdata/md1119_parquet/2014-11-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-24') location '/drill/testdata/md1119_parquet/2014-11-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-25') location '/drill/testdata/md1119_parquet/2014-11-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-26') location '/drill/testdata/md1119_parquet/2014-11-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-27') location '/drill/testdata/md1119_parquet/2014-11-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-28') location '/drill/testdata/md1119_parquet/2014-11-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-29') location '/drill/testdata/md1119_parquet/2014-11-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-11-30') location '/drill/testdata/md1119_parquet/2014-11-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-01') location '/drill/testdata/md1119_parquet/2014-12-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-02') location '/drill/testdata/md1119_parquet/2014-12-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-03') location '/drill/testdata/md1119_parquet/2014-12-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-04') location '/drill/testdata/md1119_parquet/2014-12-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-05') location '/drill/testdata/md1119_parquet/2014-12-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-06') location '/drill/testdata/md1119_parquet/2014-12-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-07') location '/drill/testdata/md1119_parquet/2014-12-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-08') location '/drill/testdata/md1119_parquet/2014-12-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-09') location '/drill/testdata/md1119_parquet/2014-12-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-10') location '/drill/testdata/md1119_parquet/2014-12-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-11') location '/drill/testdata/md1119_parquet/2014-12-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-12') location '/drill/testdata/md1119_parquet/2014-12-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-13') location '/drill/testdata/md1119_parquet/2014-12-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-14') location '/drill/testdata/md1119_parquet/2014-12-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-15') location '/drill/testdata/md1119_parquet/2014-12-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-16') location '/drill/testdata/md1119_parquet/2014-12-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-17') location '/drill/testdata/md1119_parquet/2014-12-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-18') location '/drill/testdata/md1119_parquet/2014-12-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-19') location '/drill/testdata/md1119_parquet/2014-12-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-20') location '/drill/testdata/md1119_parquet/2014-12-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-21') location '/drill/testdata/md1119_parquet/2014-12-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-22') location '/drill/testdata/md1119_parquet/2014-12-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-23') location '/drill/testdata/md1119_parquet/2014-12-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-24') location '/drill/testdata/md1119_parquet/2014-12-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-25') location '/drill/testdata/md1119_parquet/2014-12-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-26') location '/drill/testdata/md1119_parquet/2014-12-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-27') location '/drill/testdata/md1119_parquet/2014-12-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-28') location '/drill/testdata/md1119_parquet/2014-12-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-29') location '/drill/testdata/md1119_parquet/2014-12-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-30') location '/drill/testdata/md1119_parquet/2014-12-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2014-12-31') location '/drill/testdata/md1119_parquet/2014-12-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-01') location '/drill/testdata/md1119_parquet/2015-01-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-02') location '/drill/testdata/md1119_parquet/2015-01-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-03') location '/drill/testdata/md1119_parquet/2015-01-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-04') location '/drill/testdata/md1119_parquet/2015-01-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-05') location '/drill/testdata/md1119_parquet/2015-01-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-06') location '/drill/testdata/md1119_parquet/2015-01-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-07') location '/drill/testdata/md1119_parquet/2015-01-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-08') location '/drill/testdata/md1119_parquet/2015-01-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-09') location '/drill/testdata/md1119_parquet/2015-01-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-10') location '/drill/testdata/md1119_parquet/2015-01-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-11') location '/drill/testdata/md1119_parquet/2015-01-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-12') location '/drill/testdata/md1119_parquet/2015-01-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-13') location '/drill/testdata/md1119_parquet/2015-01-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-14') location '/drill/testdata/md1119_parquet/2015-01-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-15') location '/drill/testdata/md1119_parquet/2015-01-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-16') location '/drill/testdata/md1119_parquet/2015-01-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-17') location '/drill/testdata/md1119_parquet/2015-01-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-18') location '/drill/testdata/md1119_parquet/2015-01-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-19') location '/drill/testdata/md1119_parquet/2015-01-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-20') location '/drill/testdata/md1119_parquet/2015-01-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-21') location '/drill/testdata/md1119_parquet/2015-01-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-22') location '/drill/testdata/md1119_parquet/2015-01-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-23') location '/drill/testdata/md1119_parquet/2015-01-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-24') location '/drill/testdata/md1119_parquet/2015-01-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-25') location '/drill/testdata/md1119_parquet/2015-01-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-26') location '/drill/testdata/md1119_parquet/2015-01-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-27') location '/drill/testdata/md1119_parquet/2015-01-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-28') location '/drill/testdata/md1119_parquet/2015-01-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-29') location '/drill/testdata/md1119_parquet/2015-01-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-30') location '/drill/testdata/md1119_parquet/2015-01-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-01-31') location '/drill/testdata/md1119_parquet/2015-01-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-01') location '/drill/testdata/md1119_parquet/2015-02-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-02') location '/drill/testdata/md1119_parquet/2015-02-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-03') location '/drill/testdata/md1119_parquet/2015-02-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-04') location '/drill/testdata/md1119_parquet/2015-02-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-05') location '/drill/testdata/md1119_parquet/2015-02-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-06') location '/drill/testdata/md1119_parquet/2015-02-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-07') location '/drill/testdata/md1119_parquet/2015-02-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-08') location '/drill/testdata/md1119_parquet/2015-02-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-09') location '/drill/testdata/md1119_parquet/2015-02-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-10') location '/drill/testdata/md1119_parquet/2015-02-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-11') location '/drill/testdata/md1119_parquet/2015-02-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-12') location '/drill/testdata/md1119_parquet/2015-02-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-13') location '/drill/testdata/md1119_parquet/2015-02-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-14') location '/drill/testdata/md1119_parquet/2015-02-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-15') location '/drill/testdata/md1119_parquet/2015-02-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-16') location '/drill/testdata/md1119_parquet/2015-02-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-17') location '/drill/testdata/md1119_parquet/2015-02-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-18') location '/drill/testdata/md1119_parquet/2015-02-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-19') location '/drill/testdata/md1119_parquet/2015-02-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-20') location '/drill/testdata/md1119_parquet/2015-02-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-21') location '/drill/testdata/md1119_parquet/2015-02-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-22') location '/drill/testdata/md1119_parquet/2015-02-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-23') location '/drill/testdata/md1119_parquet/2015-02-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-24') location '/drill/testdata/md1119_parquet/2015-02-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-25') location '/drill/testdata/md1119_parquet/2015-02-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-26') location '/drill/testdata/md1119_parquet/2015-02-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-27') location '/drill/testdata/md1119_parquet/2015-02-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-02-28') location '/drill/testdata/md1119_parquet/2015-02-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-01') location '/drill/testdata/md1119_parquet/2015-03-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-02') location '/drill/testdata/md1119_parquet/2015-03-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-03') location '/drill/testdata/md1119_parquet/2015-03-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-04') location '/drill/testdata/md1119_parquet/2015-03-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-05') location '/drill/testdata/md1119_parquet/2015-03-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-06') location '/drill/testdata/md1119_parquet/2015-03-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-07') location '/drill/testdata/md1119_parquet/2015-03-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-08') location '/drill/testdata/md1119_parquet/2015-03-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-09') location '/drill/testdata/md1119_parquet/2015-03-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-10') location '/drill/testdata/md1119_parquet/2015-03-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-11') location '/drill/testdata/md1119_parquet/2015-03-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-12') location '/drill/testdata/md1119_parquet/2015-03-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-13') location '/drill/testdata/md1119_parquet/2015-03-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-14') location '/drill/testdata/md1119_parquet/2015-03-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-15') location '/drill/testdata/md1119_parquet/2015-03-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-16') location '/drill/testdata/md1119_parquet/2015-03-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-17') location '/drill/testdata/md1119_parquet/2015-03-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-18') location '/drill/testdata/md1119_parquet/2015-03-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-19') location '/drill/testdata/md1119_parquet/2015-03-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-20') location '/drill/testdata/md1119_parquet/2015-03-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-21') location '/drill/testdata/md1119_parquet/2015-03-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-22') location '/drill/testdata/md1119_parquet/2015-03-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-23') location '/drill/testdata/md1119_parquet/2015-03-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-24') location '/drill/testdata/md1119_parquet/2015-03-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-25') location '/drill/testdata/md1119_parquet/2015-03-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-26') location '/drill/testdata/md1119_parquet/2015-03-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-27') location '/drill/testdata/md1119_parquet/2015-03-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-28') location '/drill/testdata/md1119_parquet/2015-03-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-29') location '/drill/testdata/md1119_parquet/2015-03-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-30') location '/drill/testdata/md1119_parquet/2015-03-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-03-31') location '/drill/testdata/md1119_parquet/2015-03-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-01') location '/drill/testdata/md1119_parquet/2015-04-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-02') location '/drill/testdata/md1119_parquet/2015-04-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-03') location '/drill/testdata/md1119_parquet/2015-04-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-04') location '/drill/testdata/md1119_parquet/2015-04-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-05') location '/drill/testdata/md1119_parquet/2015-04-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-06') location '/drill/testdata/md1119_parquet/2015-04-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-07') location '/drill/testdata/md1119_parquet/2015-04-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-08') location '/drill/testdata/md1119_parquet/2015-04-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-09') location '/drill/testdata/md1119_parquet/2015-04-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-10') location '/drill/testdata/md1119_parquet/2015-04-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-11') location '/drill/testdata/md1119_parquet/2015-04-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-12') location '/drill/testdata/md1119_parquet/2015-04-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-13') location '/drill/testdata/md1119_parquet/2015-04-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-14') location '/drill/testdata/md1119_parquet/2015-04-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-15') location '/drill/testdata/md1119_parquet/2015-04-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-16') location '/drill/testdata/md1119_parquet/2015-04-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-17') location '/drill/testdata/md1119_parquet/2015-04-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-18') location '/drill/testdata/md1119_parquet/2015-04-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-19') location '/drill/testdata/md1119_parquet/2015-04-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-20') location '/drill/testdata/md1119_parquet/2015-04-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-21') location '/drill/testdata/md1119_parquet/2015-04-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-22') location '/drill/testdata/md1119_parquet/2015-04-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-23') location '/drill/testdata/md1119_parquet/2015-04-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-24') location '/drill/testdata/md1119_parquet/2015-04-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-25') location '/drill/testdata/md1119_parquet/2015-04-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-26') location '/drill/testdata/md1119_parquet/2015-04-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-27') location '/drill/testdata/md1119_parquet/2015-04-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-28') location '/drill/testdata/md1119_parquet/2015-04-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-29') location '/drill/testdata/md1119_parquet/2015-04-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-04-30') location '/drill/testdata/md1119_parquet/2015-04-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-01') location '/drill/testdata/md1119_parquet/2015-05-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-02') location '/drill/testdata/md1119_parquet/2015-05-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-03') location '/drill/testdata/md1119_parquet/2015-05-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-04') location '/drill/testdata/md1119_parquet/2015-05-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-05') location '/drill/testdata/md1119_parquet/2015-05-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-06') location '/drill/testdata/md1119_parquet/2015-05-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-07') location '/drill/testdata/md1119_parquet/2015-05-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-08') location '/drill/testdata/md1119_parquet/2015-05-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-09') location '/drill/testdata/md1119_parquet/2015-05-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-10') location '/drill/testdata/md1119_parquet/2015-05-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-11') location '/drill/testdata/md1119_parquet/2015-05-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-12') location '/drill/testdata/md1119_parquet/2015-05-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-13') location '/drill/testdata/md1119_parquet/2015-05-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-14') location '/drill/testdata/md1119_parquet/2015-05-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-15') location '/drill/testdata/md1119_parquet/2015-05-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-16') location '/drill/testdata/md1119_parquet/2015-05-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-17') location '/drill/testdata/md1119_parquet/2015-05-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-18') location '/drill/testdata/md1119_parquet/2015-05-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-19') location '/drill/testdata/md1119_parquet/2015-05-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-20') location '/drill/testdata/md1119_parquet/2015-05-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-21') location '/drill/testdata/md1119_parquet/2015-05-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-22') location '/drill/testdata/md1119_parquet/2015-05-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-23') location '/drill/testdata/md1119_parquet/2015-05-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-24') location '/drill/testdata/md1119_parquet/2015-05-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-25') location '/drill/testdata/md1119_parquet/2015-05-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-26') location '/drill/testdata/md1119_parquet/2015-05-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-27') location '/drill/testdata/md1119_parquet/2015-05-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-28') location '/drill/testdata/md1119_parquet/2015-05-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-29') location '/drill/testdata/md1119_parquet/2015-05-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-30') location '/drill/testdata/md1119_parquet/2015-05-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-05-31') location '/drill/testdata/md1119_parquet/2015-05-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-01') location '/drill/testdata/md1119_parquet/2015-06-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-02') location '/drill/testdata/md1119_parquet/2015-06-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-03') location '/drill/testdata/md1119_parquet/2015-06-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-04') location '/drill/testdata/md1119_parquet/2015-06-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-05') location '/drill/testdata/md1119_parquet/2015-06-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-06') location '/drill/testdata/md1119_parquet/2015-06-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-07') location '/drill/testdata/md1119_parquet/2015-06-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-08') location '/drill/testdata/md1119_parquet/2015-06-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-09') location '/drill/testdata/md1119_parquet/2015-06-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-10') location '/drill/testdata/md1119_parquet/2015-06-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-11') location '/drill/testdata/md1119_parquet/2015-06-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-12') location '/drill/testdata/md1119_parquet/2015-06-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-13') location '/drill/testdata/md1119_parquet/2015-06-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-14') location '/drill/testdata/md1119_parquet/2015-06-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-15') location '/drill/testdata/md1119_parquet/2015-06-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-16') location '/drill/testdata/md1119_parquet/2015-06-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-17') location '/drill/testdata/md1119_parquet/2015-06-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-18') location '/drill/testdata/md1119_parquet/2015-06-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-19') location '/drill/testdata/md1119_parquet/2015-06-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-20') location '/drill/testdata/md1119_parquet/2015-06-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-21') location '/drill/testdata/md1119_parquet/2015-06-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-22') location '/drill/testdata/md1119_parquet/2015-06-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-23') location '/drill/testdata/md1119_parquet/2015-06-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-24') location '/drill/testdata/md1119_parquet/2015-06-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-25') location '/drill/testdata/md1119_parquet/2015-06-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-26') location '/drill/testdata/md1119_parquet/2015-06-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-27') location '/drill/testdata/md1119_parquet/2015-06-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-28') location '/drill/testdata/md1119_parquet/2015-06-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-29') location '/drill/testdata/md1119_parquet/2015-06-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-06-30') location '/drill/testdata/md1119_parquet/2015-06-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-01') location '/drill/testdata/md1119_parquet/2015-07-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-02') location '/drill/testdata/md1119_parquet/2015-07-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-03') location '/drill/testdata/md1119_parquet/2015-07-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-04') location '/drill/testdata/md1119_parquet/2015-07-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-05') location '/drill/testdata/md1119_parquet/2015-07-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-06') location '/drill/testdata/md1119_parquet/2015-07-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-07') location '/drill/testdata/md1119_parquet/2015-07-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-08') location '/drill/testdata/md1119_parquet/2015-07-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-09') location '/drill/testdata/md1119_parquet/2015-07-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-10') location '/drill/testdata/md1119_parquet/2015-07-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-11') location '/drill/testdata/md1119_parquet/2015-07-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-12') location '/drill/testdata/md1119_parquet/2015-07-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-13') location '/drill/testdata/md1119_parquet/2015-07-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-14') location '/drill/testdata/md1119_parquet/2015-07-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-15') location '/drill/testdata/md1119_parquet/2015-07-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-16') location '/drill/testdata/md1119_parquet/2015-07-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-17') location '/drill/testdata/md1119_parquet/2015-07-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-18') location '/drill/testdata/md1119_parquet/2015-07-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-19') location '/drill/testdata/md1119_parquet/2015-07-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-20') location '/drill/testdata/md1119_parquet/2015-07-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-21') location '/drill/testdata/md1119_parquet/2015-07-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-22') location '/drill/testdata/md1119_parquet/2015-07-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-23') location '/drill/testdata/md1119_parquet/2015-07-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-24') location '/drill/testdata/md1119_parquet/2015-07-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-25') location '/drill/testdata/md1119_parquet/2015-07-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-26') location '/drill/testdata/md1119_parquet/2015-07-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-27') location '/drill/testdata/md1119_parquet/2015-07-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-28') location '/drill/testdata/md1119_parquet/2015-07-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-29') location '/drill/testdata/md1119_parquet/2015-07-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-30') location '/drill/testdata/md1119_parquet/2015-07-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-07-31') location '/drill/testdata/md1119_parquet/2015-07-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-01') location '/drill/testdata/md1119_parquet/2015-08-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-02') location '/drill/testdata/md1119_parquet/2015-08-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-03') location '/drill/testdata/md1119_parquet/2015-08-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-04') location '/drill/testdata/md1119_parquet/2015-08-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-05') location '/drill/testdata/md1119_parquet/2015-08-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-06') location '/drill/testdata/md1119_parquet/2015-08-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-07') location '/drill/testdata/md1119_parquet/2015-08-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-08') location '/drill/testdata/md1119_parquet/2015-08-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-09') location '/drill/testdata/md1119_parquet/2015-08-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-10') location '/drill/testdata/md1119_parquet/2015-08-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-11') location '/drill/testdata/md1119_parquet/2015-08-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-12') location '/drill/testdata/md1119_parquet/2015-08-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-13') location '/drill/testdata/md1119_parquet/2015-08-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-14') location '/drill/testdata/md1119_parquet/2015-08-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-15') location '/drill/testdata/md1119_parquet/2015-08-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-16') location '/drill/testdata/md1119_parquet/2015-08-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-17') location '/drill/testdata/md1119_parquet/2015-08-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-18') location '/drill/testdata/md1119_parquet/2015-08-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-19') location '/drill/testdata/md1119_parquet/2015-08-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-20') location '/drill/testdata/md1119_parquet/2015-08-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-21') location '/drill/testdata/md1119_parquet/2015-08-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-22') location '/drill/testdata/md1119_parquet/2015-08-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-23') location '/drill/testdata/md1119_parquet/2015-08-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-24') location '/drill/testdata/md1119_parquet/2015-08-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-25') location '/drill/testdata/md1119_parquet/2015-08-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-26') location '/drill/testdata/md1119_parquet/2015-08-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-27') location '/drill/testdata/md1119_parquet/2015-08-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-28') location '/drill/testdata/md1119_parquet/2015-08-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-29') location '/drill/testdata/md1119_parquet/2015-08-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-30') location '/drill/testdata/md1119_parquet/2015-08-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-08-31') location '/drill/testdata/md1119_parquet/2015-08-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-01') location '/drill/testdata/md1119_parquet/2015-09-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-02') location '/drill/testdata/md1119_parquet/2015-09-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-03') location '/drill/testdata/md1119_parquet/2015-09-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-04') location '/drill/testdata/md1119_parquet/2015-09-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-05') location '/drill/testdata/md1119_parquet/2015-09-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-06') location '/drill/testdata/md1119_parquet/2015-09-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-07') location '/drill/testdata/md1119_parquet/2015-09-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-08') location '/drill/testdata/md1119_parquet/2015-09-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-09') location '/drill/testdata/md1119_parquet/2015-09-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-10') location '/drill/testdata/md1119_parquet/2015-09-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-11') location '/drill/testdata/md1119_parquet/2015-09-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-12') location '/drill/testdata/md1119_parquet/2015-09-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-13') location '/drill/testdata/md1119_parquet/2015-09-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-14') location '/drill/testdata/md1119_parquet/2015-09-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-15') location '/drill/testdata/md1119_parquet/2015-09-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-16') location '/drill/testdata/md1119_parquet/2015-09-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-17') location '/drill/testdata/md1119_parquet/2015-09-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-18') location '/drill/testdata/md1119_parquet/2015-09-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-19') location '/drill/testdata/md1119_parquet/2015-09-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-20') location '/drill/testdata/md1119_parquet/2015-09-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-21') location '/drill/testdata/md1119_parquet/2015-09-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-22') location '/drill/testdata/md1119_parquet/2015-09-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-23') location '/drill/testdata/md1119_parquet/2015-09-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-24') location '/drill/testdata/md1119_parquet/2015-09-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-25') location '/drill/testdata/md1119_parquet/2015-09-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-26') location '/drill/testdata/md1119_parquet/2015-09-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-27') location '/drill/testdata/md1119_parquet/2015-09-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-28') location '/drill/testdata/md1119_parquet/2015-09-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-29') location '/drill/testdata/md1119_parquet/2015-09-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-09-30') location '/drill/testdata/md1119_parquet/2015-09-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-01') location '/drill/testdata/md1119_parquet/2015-10-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-02') location '/drill/testdata/md1119_parquet/2015-10-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-03') location '/drill/testdata/md1119_parquet/2015-10-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-04') location '/drill/testdata/md1119_parquet/2015-10-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-05') location '/drill/testdata/md1119_parquet/2015-10-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-06') location '/drill/testdata/md1119_parquet/2015-10-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-07') location '/drill/testdata/md1119_parquet/2015-10-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-08') location '/drill/testdata/md1119_parquet/2015-10-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-09') location '/drill/testdata/md1119_parquet/2015-10-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-10') location '/drill/testdata/md1119_parquet/2015-10-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-11') location '/drill/testdata/md1119_parquet/2015-10-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-12') location '/drill/testdata/md1119_parquet/2015-10-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-13') location '/drill/testdata/md1119_parquet/2015-10-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-14') location '/drill/testdata/md1119_parquet/2015-10-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-15') location '/drill/testdata/md1119_parquet/2015-10-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-16') location '/drill/testdata/md1119_parquet/2015-10-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-17') location '/drill/testdata/md1119_parquet/2015-10-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-18') location '/drill/testdata/md1119_parquet/2015-10-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-19') location '/drill/testdata/md1119_parquet/2015-10-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-20') location '/drill/testdata/md1119_parquet/2015-10-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-21') location '/drill/testdata/md1119_parquet/2015-10-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-22') location '/drill/testdata/md1119_parquet/2015-10-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-23') location '/drill/testdata/md1119_parquet/2015-10-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-24') location '/drill/testdata/md1119_parquet/2015-10-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-25') location '/drill/testdata/md1119_parquet/2015-10-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-26') location '/drill/testdata/md1119_parquet/2015-10-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-27') location '/drill/testdata/md1119_parquet/2015-10-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-28') location '/drill/testdata/md1119_parquet/2015-10-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-29') location '/drill/testdata/md1119_parquet/2015-10-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-30') location '/drill/testdata/md1119_parquet/2015-10-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-10-31') location '/drill/testdata/md1119_parquet/2015-10-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-01') location '/drill/testdata/md1119_parquet/2015-11-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-02') location '/drill/testdata/md1119_parquet/2015-11-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-03') location '/drill/testdata/md1119_parquet/2015-11-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-04') location '/drill/testdata/md1119_parquet/2015-11-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-05') location '/drill/testdata/md1119_parquet/2015-11-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-06') location '/drill/testdata/md1119_parquet/2015-11-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-07') location '/drill/testdata/md1119_parquet/2015-11-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-08') location '/drill/testdata/md1119_parquet/2015-11-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-09') location '/drill/testdata/md1119_parquet/2015-11-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-10') location '/drill/testdata/md1119_parquet/2015-11-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-11') location '/drill/testdata/md1119_parquet/2015-11-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-12') location '/drill/testdata/md1119_parquet/2015-11-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-13') location '/drill/testdata/md1119_parquet/2015-11-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-14') location '/drill/testdata/md1119_parquet/2015-11-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-15') location '/drill/testdata/md1119_parquet/2015-11-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-16') location '/drill/testdata/md1119_parquet/2015-11-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-17') location '/drill/testdata/md1119_parquet/2015-11-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-18') location '/drill/testdata/md1119_parquet/2015-11-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-19') location '/drill/testdata/md1119_parquet/2015-11-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-20') location '/drill/testdata/md1119_parquet/2015-11-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-21') location '/drill/testdata/md1119_parquet/2015-11-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-22') location '/drill/testdata/md1119_parquet/2015-11-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-23') location '/drill/testdata/md1119_parquet/2015-11-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-24') location '/drill/testdata/md1119_parquet/2015-11-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-25') location '/drill/testdata/md1119_parquet/2015-11-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-26') location '/drill/testdata/md1119_parquet/2015-11-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-27') location '/drill/testdata/md1119_parquet/2015-11-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-28') location '/drill/testdata/md1119_parquet/2015-11-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-29') location '/drill/testdata/md1119_parquet/2015-11-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-11-30') location '/drill/testdata/md1119_parquet/2015-11-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-01') location '/drill/testdata/md1119_parquet/2015-12-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-02') location '/drill/testdata/md1119_parquet/2015-12-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-03') location '/drill/testdata/md1119_parquet/2015-12-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-04') location '/drill/testdata/md1119_parquet/2015-12-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-05') location '/drill/testdata/md1119_parquet/2015-12-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-06') location '/drill/testdata/md1119_parquet/2015-12-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-07') location '/drill/testdata/md1119_parquet/2015-12-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-08') location '/drill/testdata/md1119_parquet/2015-12-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-09') location '/drill/testdata/md1119_parquet/2015-12-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-10') location '/drill/testdata/md1119_parquet/2015-12-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-11') location '/drill/testdata/md1119_parquet/2015-12-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-12') location '/drill/testdata/md1119_parquet/2015-12-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-13') location '/drill/testdata/md1119_parquet/2015-12-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-14') location '/drill/testdata/md1119_parquet/2015-12-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-15') location '/drill/testdata/md1119_parquet/2015-12-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-16') location '/drill/testdata/md1119_parquet/2015-12-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-17') location '/drill/testdata/md1119_parquet/2015-12-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-18') location '/drill/testdata/md1119_parquet/2015-12-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-19') location '/drill/testdata/md1119_parquet/2015-12-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-20') location '/drill/testdata/md1119_parquet/2015-12-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-21') location '/drill/testdata/md1119_parquet/2015-12-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-22') location '/drill/testdata/md1119_parquet/2015-12-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-23') location '/drill/testdata/md1119_parquet/2015-12-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-24') location '/drill/testdata/md1119_parquet/2015-12-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-25') location '/drill/testdata/md1119_parquet/2015-12-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-26') location '/drill/testdata/md1119_parquet/2015-12-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-27') location '/drill/testdata/md1119_parquet/2015-12-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-28') location '/drill/testdata/md1119_parquet/2015-12-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-29') location '/drill/testdata/md1119_parquet/2015-12-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-30') location '/drill/testdata/md1119_parquet/2015-12-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2015-12-31') location '/drill/testdata/md1119_parquet/2015-12-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-01') location '/drill/testdata/md1119_parquet/2016-01-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-02') location '/drill/testdata/md1119_parquet/2016-01-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-03') location '/drill/testdata/md1119_parquet/2016-01-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-04') location '/drill/testdata/md1119_parquet/2016-01-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-05') location '/drill/testdata/md1119_parquet/2016-01-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-06') location '/drill/testdata/md1119_parquet/2016-01-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-07') location '/drill/testdata/md1119_parquet/2016-01-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-08') location '/drill/testdata/md1119_parquet/2016-01-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-09') location '/drill/testdata/md1119_parquet/2016-01-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-10') location '/drill/testdata/md1119_parquet/2016-01-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-11') location '/drill/testdata/md1119_parquet/2016-01-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-12') location '/drill/testdata/md1119_parquet/2016-01-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-13') location '/drill/testdata/md1119_parquet/2016-01-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-14') location '/drill/testdata/md1119_parquet/2016-01-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-15') location '/drill/testdata/md1119_parquet/2016-01-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-16') location '/drill/testdata/md1119_parquet/2016-01-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-17') location '/drill/testdata/md1119_parquet/2016-01-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-18') location '/drill/testdata/md1119_parquet/2016-01-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-19') location '/drill/testdata/md1119_parquet/2016-01-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-20') location '/drill/testdata/md1119_parquet/2016-01-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-21') location '/drill/testdata/md1119_parquet/2016-01-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-22') location '/drill/testdata/md1119_parquet/2016-01-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-23') location '/drill/testdata/md1119_parquet/2016-01-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-24') location '/drill/testdata/md1119_parquet/2016-01-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-25') location '/drill/testdata/md1119_parquet/2016-01-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-26') location '/drill/testdata/md1119_parquet/2016-01-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-27') location '/drill/testdata/md1119_parquet/2016-01-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-28') location '/drill/testdata/md1119_parquet/2016-01-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-29') location '/drill/testdata/md1119_parquet/2016-01-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-30') location '/drill/testdata/md1119_parquet/2016-01-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-01-31') location '/drill/testdata/md1119_parquet/2016-01-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-01') location '/drill/testdata/md1119_parquet/2016-02-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-02') location '/drill/testdata/md1119_parquet/2016-02-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-03') location '/drill/testdata/md1119_parquet/2016-02-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-04') location '/drill/testdata/md1119_parquet/2016-02-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-05') location '/drill/testdata/md1119_parquet/2016-02-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-06') location '/drill/testdata/md1119_parquet/2016-02-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-07') location '/drill/testdata/md1119_parquet/2016-02-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-08') location '/drill/testdata/md1119_parquet/2016-02-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-09') location '/drill/testdata/md1119_parquet/2016-02-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-10') location '/drill/testdata/md1119_parquet/2016-02-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-11') location '/drill/testdata/md1119_parquet/2016-02-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-12') location '/drill/testdata/md1119_parquet/2016-02-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-13') location '/drill/testdata/md1119_parquet/2016-02-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-14') location '/drill/testdata/md1119_parquet/2016-02-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-15') location '/drill/testdata/md1119_parquet/2016-02-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-16') location '/drill/testdata/md1119_parquet/2016-02-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-17') location '/drill/testdata/md1119_parquet/2016-02-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-18') location '/drill/testdata/md1119_parquet/2016-02-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-19') location '/drill/testdata/md1119_parquet/2016-02-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-20') location '/drill/testdata/md1119_parquet/2016-02-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-21') location '/drill/testdata/md1119_parquet/2016-02-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-22') location '/drill/testdata/md1119_parquet/2016-02-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-23') location '/drill/testdata/md1119_parquet/2016-02-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-24') location '/drill/testdata/md1119_parquet/2016-02-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-25') location '/drill/testdata/md1119_parquet/2016-02-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-26') location '/drill/testdata/md1119_parquet/2016-02-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-27') location '/drill/testdata/md1119_parquet/2016-02-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-28') location '/drill/testdata/md1119_parquet/2016-02-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-02-29') location '/drill/testdata/md1119_parquet/2016-02-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-01') location '/drill/testdata/md1119_parquet/2016-03-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-02') location '/drill/testdata/md1119_parquet/2016-03-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-03') location '/drill/testdata/md1119_parquet/2016-03-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-04') location '/drill/testdata/md1119_parquet/2016-03-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-05') location '/drill/testdata/md1119_parquet/2016-03-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-06') location '/drill/testdata/md1119_parquet/2016-03-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-07') location '/drill/testdata/md1119_parquet/2016-03-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-08') location '/drill/testdata/md1119_parquet/2016-03-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-09') location '/drill/testdata/md1119_parquet/2016-03-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-10') location '/drill/testdata/md1119_parquet/2016-03-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-11') location '/drill/testdata/md1119_parquet/2016-03-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-12') location '/drill/testdata/md1119_parquet/2016-03-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-13') location '/drill/testdata/md1119_parquet/2016-03-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-14') location '/drill/testdata/md1119_parquet/2016-03-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-15') location '/drill/testdata/md1119_parquet/2016-03-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-16') location '/drill/testdata/md1119_parquet/2016-03-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-17') location '/drill/testdata/md1119_parquet/2016-03-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-18') location '/drill/testdata/md1119_parquet/2016-03-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-19') location '/drill/testdata/md1119_parquet/2016-03-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-20') location '/drill/testdata/md1119_parquet/2016-03-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-21') location '/drill/testdata/md1119_parquet/2016-03-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-22') location '/drill/testdata/md1119_parquet/2016-03-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-23') location '/drill/testdata/md1119_parquet/2016-03-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-24') location '/drill/testdata/md1119_parquet/2016-03-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-25') location '/drill/testdata/md1119_parquet/2016-03-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-26') location '/drill/testdata/md1119_parquet/2016-03-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-27') location '/drill/testdata/md1119_parquet/2016-03-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-28') location '/drill/testdata/md1119_parquet/2016-03-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-29') location '/drill/testdata/md1119_parquet/2016-03-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-30') location '/drill/testdata/md1119_parquet/2016-03-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-03-31') location '/drill/testdata/md1119_parquet/2016-03-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-01') location '/drill/testdata/md1119_parquet/2016-04-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-02') location '/drill/testdata/md1119_parquet/2016-04-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-03') location '/drill/testdata/md1119_parquet/2016-04-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-04') location '/drill/testdata/md1119_parquet/2016-04-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-05') location '/drill/testdata/md1119_parquet/2016-04-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-06') location '/drill/testdata/md1119_parquet/2016-04-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-07') location '/drill/testdata/md1119_parquet/2016-04-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-08') location '/drill/testdata/md1119_parquet/2016-04-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-09') location '/drill/testdata/md1119_parquet/2016-04-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-10') location '/drill/testdata/md1119_parquet/2016-04-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-11') location '/drill/testdata/md1119_parquet/2016-04-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-12') location '/drill/testdata/md1119_parquet/2016-04-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-13') location '/drill/testdata/md1119_parquet/2016-04-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-14') location '/drill/testdata/md1119_parquet/2016-04-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-15') location '/drill/testdata/md1119_parquet/2016-04-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-16') location '/drill/testdata/md1119_parquet/2016-04-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-17') location '/drill/testdata/md1119_parquet/2016-04-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-18') location '/drill/testdata/md1119_parquet/2016-04-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-19') location '/drill/testdata/md1119_parquet/2016-04-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-20') location '/drill/testdata/md1119_parquet/2016-04-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-21') location '/drill/testdata/md1119_parquet/2016-04-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-22') location '/drill/testdata/md1119_parquet/2016-04-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-23') location '/drill/testdata/md1119_parquet/2016-04-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-24') location '/drill/testdata/md1119_parquet/2016-04-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-25') location '/drill/testdata/md1119_parquet/2016-04-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-26') location '/drill/testdata/md1119_parquet/2016-04-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-27') location '/drill/testdata/md1119_parquet/2016-04-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-28') location '/drill/testdata/md1119_parquet/2016-04-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-29') location '/drill/testdata/md1119_parquet/2016-04-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-04-30') location '/drill/testdata/md1119_parquet/2016-04-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-01') location '/drill/testdata/md1119_parquet/2016-05-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-02') location '/drill/testdata/md1119_parquet/2016-05-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-03') location '/drill/testdata/md1119_parquet/2016-05-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-04') location '/drill/testdata/md1119_parquet/2016-05-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-05') location '/drill/testdata/md1119_parquet/2016-05-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-06') location '/drill/testdata/md1119_parquet/2016-05-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-07') location '/drill/testdata/md1119_parquet/2016-05-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-08') location '/drill/testdata/md1119_parquet/2016-05-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-09') location '/drill/testdata/md1119_parquet/2016-05-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-10') location '/drill/testdata/md1119_parquet/2016-05-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-11') location '/drill/testdata/md1119_parquet/2016-05-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-12') location '/drill/testdata/md1119_parquet/2016-05-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-13') location '/drill/testdata/md1119_parquet/2016-05-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-14') location '/drill/testdata/md1119_parquet/2016-05-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-15') location '/drill/testdata/md1119_parquet/2016-05-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-16') location '/drill/testdata/md1119_parquet/2016-05-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-17') location '/drill/testdata/md1119_parquet/2016-05-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-18') location '/drill/testdata/md1119_parquet/2016-05-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-19') location '/drill/testdata/md1119_parquet/2016-05-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-20') location '/drill/testdata/md1119_parquet/2016-05-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-21') location '/drill/testdata/md1119_parquet/2016-05-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-22') location '/drill/testdata/md1119_parquet/2016-05-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-23') location '/drill/testdata/md1119_parquet/2016-05-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-24') location '/drill/testdata/md1119_parquet/2016-05-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-25') location '/drill/testdata/md1119_parquet/2016-05-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-26') location '/drill/testdata/md1119_parquet/2016-05-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-27') location '/drill/testdata/md1119_parquet/2016-05-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-28') location '/drill/testdata/md1119_parquet/2016-05-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-29') location '/drill/testdata/md1119_parquet/2016-05-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-30') location '/drill/testdata/md1119_parquet/2016-05-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-05-31') location '/drill/testdata/md1119_parquet/2016-05-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-01') location '/drill/testdata/md1119_parquet/2016-06-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-02') location '/drill/testdata/md1119_parquet/2016-06-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-03') location '/drill/testdata/md1119_parquet/2016-06-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-04') location '/drill/testdata/md1119_parquet/2016-06-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-05') location '/drill/testdata/md1119_parquet/2016-06-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-06') location '/drill/testdata/md1119_parquet/2016-06-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-07') location '/drill/testdata/md1119_parquet/2016-06-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-08') location '/drill/testdata/md1119_parquet/2016-06-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-09') location '/drill/testdata/md1119_parquet/2016-06-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-10') location '/drill/testdata/md1119_parquet/2016-06-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-11') location '/drill/testdata/md1119_parquet/2016-06-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-12') location '/drill/testdata/md1119_parquet/2016-06-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-13') location '/drill/testdata/md1119_parquet/2016-06-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-14') location '/drill/testdata/md1119_parquet/2016-06-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-15') location '/drill/testdata/md1119_parquet/2016-06-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-16') location '/drill/testdata/md1119_parquet/2016-06-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-17') location '/drill/testdata/md1119_parquet/2016-06-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-18') location '/drill/testdata/md1119_parquet/2016-06-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-19') location '/drill/testdata/md1119_parquet/2016-06-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-20') location '/drill/testdata/md1119_parquet/2016-06-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-21') location '/drill/testdata/md1119_parquet/2016-06-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-22') location '/drill/testdata/md1119_parquet/2016-06-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-23') location '/drill/testdata/md1119_parquet/2016-06-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-24') location '/drill/testdata/md1119_parquet/2016-06-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-25') location '/drill/testdata/md1119_parquet/2016-06-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-26') location '/drill/testdata/md1119_parquet/2016-06-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-27') location '/drill/testdata/md1119_parquet/2016-06-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-28') location '/drill/testdata/md1119_parquet/2016-06-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-29') location '/drill/testdata/md1119_parquet/2016-06-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-06-30') location '/drill/testdata/md1119_parquet/2016-06-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-01') location '/drill/testdata/md1119_parquet/2016-07-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-02') location '/drill/testdata/md1119_parquet/2016-07-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-03') location '/drill/testdata/md1119_parquet/2016-07-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-04') location '/drill/testdata/md1119_parquet/2016-07-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-05') location '/drill/testdata/md1119_parquet/2016-07-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-06') location '/drill/testdata/md1119_parquet/2016-07-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-07') location '/drill/testdata/md1119_parquet/2016-07-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-08') location '/drill/testdata/md1119_parquet/2016-07-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-09') location '/drill/testdata/md1119_parquet/2016-07-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-10') location '/drill/testdata/md1119_parquet/2016-07-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-11') location '/drill/testdata/md1119_parquet/2016-07-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-12') location '/drill/testdata/md1119_parquet/2016-07-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-13') location '/drill/testdata/md1119_parquet/2016-07-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-14') location '/drill/testdata/md1119_parquet/2016-07-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-15') location '/drill/testdata/md1119_parquet/2016-07-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-16') location '/drill/testdata/md1119_parquet/2016-07-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-17') location '/drill/testdata/md1119_parquet/2016-07-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-18') location '/drill/testdata/md1119_parquet/2016-07-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-19') location '/drill/testdata/md1119_parquet/2016-07-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-20') location '/drill/testdata/md1119_parquet/2016-07-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-21') location '/drill/testdata/md1119_parquet/2016-07-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-22') location '/drill/testdata/md1119_parquet/2016-07-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-23') location '/drill/testdata/md1119_parquet/2016-07-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-24') location '/drill/testdata/md1119_parquet/2016-07-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-25') location '/drill/testdata/md1119_parquet/2016-07-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-26') location '/drill/testdata/md1119_parquet/2016-07-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-27') location '/drill/testdata/md1119_parquet/2016-07-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-28') location '/drill/testdata/md1119_parquet/2016-07-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-29') location '/drill/testdata/md1119_parquet/2016-07-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-30') location '/drill/testdata/md1119_parquet/2016-07-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-07-31') location '/drill/testdata/md1119_parquet/2016-07-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-01') location '/drill/testdata/md1119_parquet/2016-08-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-02') location '/drill/testdata/md1119_parquet/2016-08-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-03') location '/drill/testdata/md1119_parquet/2016-08-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-04') location '/drill/testdata/md1119_parquet/2016-08-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-05') location '/drill/testdata/md1119_parquet/2016-08-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-06') location '/drill/testdata/md1119_parquet/2016-08-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-07') location '/drill/testdata/md1119_parquet/2016-08-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-08') location '/drill/testdata/md1119_parquet/2016-08-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-09') location '/drill/testdata/md1119_parquet/2016-08-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-10') location '/drill/testdata/md1119_parquet/2016-08-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-11') location '/drill/testdata/md1119_parquet/2016-08-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-12') location '/drill/testdata/md1119_parquet/2016-08-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-13') location '/drill/testdata/md1119_parquet/2016-08-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-14') location '/drill/testdata/md1119_parquet/2016-08-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-15') location '/drill/testdata/md1119_parquet/2016-08-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-16') location '/drill/testdata/md1119_parquet/2016-08-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-17') location '/drill/testdata/md1119_parquet/2016-08-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-18') location '/drill/testdata/md1119_parquet/2016-08-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-19') location '/drill/testdata/md1119_parquet/2016-08-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-20') location '/drill/testdata/md1119_parquet/2016-08-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-21') location '/drill/testdata/md1119_parquet/2016-08-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-22') location '/drill/testdata/md1119_parquet/2016-08-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-23') location '/drill/testdata/md1119_parquet/2016-08-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-24') location '/drill/testdata/md1119_parquet/2016-08-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-25') location '/drill/testdata/md1119_parquet/2016-08-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-26') location '/drill/testdata/md1119_parquet/2016-08-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-27') location '/drill/testdata/md1119_parquet/2016-08-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-28') location '/drill/testdata/md1119_parquet/2016-08-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-29') location '/drill/testdata/md1119_parquet/2016-08-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-30') location '/drill/testdata/md1119_parquet/2016-08-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-08-31') location '/drill/testdata/md1119_parquet/2016-08-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-01') location '/drill/testdata/md1119_parquet/2016-09-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-02') location '/drill/testdata/md1119_parquet/2016-09-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-03') location '/drill/testdata/md1119_parquet/2016-09-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-04') location '/drill/testdata/md1119_parquet/2016-09-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-05') location '/drill/testdata/md1119_parquet/2016-09-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-06') location '/drill/testdata/md1119_parquet/2016-09-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-07') location '/drill/testdata/md1119_parquet/2016-09-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-08') location '/drill/testdata/md1119_parquet/2016-09-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-09') location '/drill/testdata/md1119_parquet/2016-09-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-10') location '/drill/testdata/md1119_parquet/2016-09-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-11') location '/drill/testdata/md1119_parquet/2016-09-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-12') location '/drill/testdata/md1119_parquet/2016-09-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-13') location '/drill/testdata/md1119_parquet/2016-09-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-14') location '/drill/testdata/md1119_parquet/2016-09-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-15') location '/drill/testdata/md1119_parquet/2016-09-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-16') location '/drill/testdata/md1119_parquet/2016-09-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-17') location '/drill/testdata/md1119_parquet/2016-09-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-18') location '/drill/testdata/md1119_parquet/2016-09-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-19') location '/drill/testdata/md1119_parquet/2016-09-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-20') location '/drill/testdata/md1119_parquet/2016-09-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-21') location '/drill/testdata/md1119_parquet/2016-09-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-22') location '/drill/testdata/md1119_parquet/2016-09-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-23') location '/drill/testdata/md1119_parquet/2016-09-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-24') location '/drill/testdata/md1119_parquet/2016-09-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-25') location '/drill/testdata/md1119_parquet/2016-09-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-26') location '/drill/testdata/md1119_parquet/2016-09-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-27') location '/drill/testdata/md1119_parquet/2016-09-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-28') location '/drill/testdata/md1119_parquet/2016-09-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-29') location '/drill/testdata/md1119_parquet/2016-09-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-09-30') location '/drill/testdata/md1119_parquet/2016-09-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-01') location '/drill/testdata/md1119_parquet/2016-10-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-02') location '/drill/testdata/md1119_parquet/2016-10-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-03') location '/drill/testdata/md1119_parquet/2016-10-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-04') location '/drill/testdata/md1119_parquet/2016-10-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-05') location '/drill/testdata/md1119_parquet/2016-10-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-06') location '/drill/testdata/md1119_parquet/2016-10-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-07') location '/drill/testdata/md1119_parquet/2016-10-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-08') location '/drill/testdata/md1119_parquet/2016-10-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-09') location '/drill/testdata/md1119_parquet/2016-10-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-10') location '/drill/testdata/md1119_parquet/2016-10-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-11') location '/drill/testdata/md1119_parquet/2016-10-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-12') location '/drill/testdata/md1119_parquet/2016-10-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-13') location '/drill/testdata/md1119_parquet/2016-10-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-14') location '/drill/testdata/md1119_parquet/2016-10-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-15') location '/drill/testdata/md1119_parquet/2016-10-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-16') location '/drill/testdata/md1119_parquet/2016-10-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-17') location '/drill/testdata/md1119_parquet/2016-10-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-18') location '/drill/testdata/md1119_parquet/2016-10-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-19') location '/drill/testdata/md1119_parquet/2016-10-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-20') location '/drill/testdata/md1119_parquet/2016-10-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-21') location '/drill/testdata/md1119_parquet/2016-10-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-22') location '/drill/testdata/md1119_parquet/2016-10-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-23') location '/drill/testdata/md1119_parquet/2016-10-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-24') location '/drill/testdata/md1119_parquet/2016-10-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-25') location '/drill/testdata/md1119_parquet/2016-10-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-26') location '/drill/testdata/md1119_parquet/2016-10-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-27') location '/drill/testdata/md1119_parquet/2016-10-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-28') location '/drill/testdata/md1119_parquet/2016-10-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-29') location '/drill/testdata/md1119_parquet/2016-10-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-30') location '/drill/testdata/md1119_parquet/2016-10-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-10-31') location '/drill/testdata/md1119_parquet/2016-10-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-01') location '/drill/testdata/md1119_parquet/2016-11-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-02') location '/drill/testdata/md1119_parquet/2016-11-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-03') location '/drill/testdata/md1119_parquet/2016-11-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-04') location '/drill/testdata/md1119_parquet/2016-11-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-05') location '/drill/testdata/md1119_parquet/2016-11-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-06') location '/drill/testdata/md1119_parquet/2016-11-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-07') location '/drill/testdata/md1119_parquet/2016-11-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-08') location '/drill/testdata/md1119_parquet/2016-11-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-09') location '/drill/testdata/md1119_parquet/2016-11-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-10') location '/drill/testdata/md1119_parquet/2016-11-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-11') location '/drill/testdata/md1119_parquet/2016-11-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-12') location '/drill/testdata/md1119_parquet/2016-11-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-13') location '/drill/testdata/md1119_parquet/2016-11-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-14') location '/drill/testdata/md1119_parquet/2016-11-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-15') location '/drill/testdata/md1119_parquet/2016-11-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-16') location '/drill/testdata/md1119_parquet/2016-11-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-17') location '/drill/testdata/md1119_parquet/2016-11-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-18') location '/drill/testdata/md1119_parquet/2016-11-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-19') location '/drill/testdata/md1119_parquet/2016-11-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-20') location '/drill/testdata/md1119_parquet/2016-11-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-21') location '/drill/testdata/md1119_parquet/2016-11-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-22') location '/drill/testdata/md1119_parquet/2016-11-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-23') location '/drill/testdata/md1119_parquet/2016-11-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-24') location '/drill/testdata/md1119_parquet/2016-11-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-25') location '/drill/testdata/md1119_parquet/2016-11-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-26') location '/drill/testdata/md1119_parquet/2016-11-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-27') location '/drill/testdata/md1119_parquet/2016-11-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-28') location '/drill/testdata/md1119_parquet/2016-11-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-29') location '/drill/testdata/md1119_parquet/2016-11-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-11-30') location '/drill/testdata/md1119_parquet/2016-11-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-01') location '/drill/testdata/md1119_parquet/2016-12-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-02') location '/drill/testdata/md1119_parquet/2016-12-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-03') location '/drill/testdata/md1119_parquet/2016-12-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-04') location '/drill/testdata/md1119_parquet/2016-12-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-05') location '/drill/testdata/md1119_parquet/2016-12-05';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-06') location '/drill/testdata/md1119_parquet/2016-12-06';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-07') location '/drill/testdata/md1119_parquet/2016-12-07';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-08') location '/drill/testdata/md1119_parquet/2016-12-08';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-09') location '/drill/testdata/md1119_parquet/2016-12-09';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-10') location '/drill/testdata/md1119_parquet/2016-12-10';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-11') location '/drill/testdata/md1119_parquet/2016-12-11';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-12') location '/drill/testdata/md1119_parquet/2016-12-12';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-13') location '/drill/testdata/md1119_parquet/2016-12-13';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-14') location '/drill/testdata/md1119_parquet/2016-12-14';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-15') location '/drill/testdata/md1119_parquet/2016-12-15';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-16') location '/drill/testdata/md1119_parquet/2016-12-16';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-17') location '/drill/testdata/md1119_parquet/2016-12-17';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-18') location '/drill/testdata/md1119_parquet/2016-12-18';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-19') location '/drill/testdata/md1119_parquet/2016-12-19';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-20') location '/drill/testdata/md1119_parquet/2016-12-20';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-21') location '/drill/testdata/md1119_parquet/2016-12-21';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-22') location '/drill/testdata/md1119_parquet/2016-12-22';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-23') location '/drill/testdata/md1119_parquet/2016-12-23';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-24') location '/drill/testdata/md1119_parquet/2016-12-24';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-25') location '/drill/testdata/md1119_parquet/2016-12-25';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-26') location '/drill/testdata/md1119_parquet/2016-12-26';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-27') location '/drill/testdata/md1119_parquet/2016-12-27';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-28') location '/drill/testdata/md1119_parquet/2016-12-28';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-29') location '/drill/testdata/md1119_parquet/2016-12-29';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-30') location '/drill/testdata/md1119_parquet/2016-12-30';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2016-12-31') location '/drill/testdata/md1119_parquet/2016-12-31';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2017-01-01') location '/drill/testdata/md1119_parquet/2017-01-01';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2017-01-02') location '/drill/testdata/md1119_parquet/2017-01-02';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2017-01-03') location '/drill/testdata/md1119_parquet/2017-01-03';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2017-01-04') location '/drill/testdata/md1119_parquet/2017-01-04';
ALTER TABLE md1119_parquet ADD PARTITION (businessdate='2017-01-05') location '/drill/testdata/md1119_parquet/2017-01-05';