create readable external table dbgen_version_ext (like dbgen_version) location ('gpfdist://localhost:9898/tpcds/10s/dbgen_version.dat') format 'text' (delimiter '|' null as '');
create readable external table customer_address_ext (like customer_address) location ('gpfdist://localhost:9898/tpcds/10s/customer_address.dat') format 'text' (delimiter '|' null as '');
create readable external table customer_demographics_ext (like customer_demographics) location ('gpfdist://localhost:9898/tpcds/10s/customer_demographics.dat') format 'text' (delimiter '|' null as '');
create readable external table date_dim_ext (like date_dim) location ('gpfdist://localhost:9898/tpcds/10s/date_dim.dat') format 'text' (delimiter '|' null as '');
create readable external table warehouse_ext (like warehouse) location ('gpfdist://localhost:9898/tpcds/10s/warehouse.dat') format 'text' (delimiter '|' null as '');
create readable external table ship_mode_ext (like ship_mode) location ('gpfdist://localhost:9898/tpcds/10s/ship_mode.dat') format 'text' (delimiter '|' null as '');
create readable external table time_dim_ext (like time_dim) location ('gpfdist://localhost:9898/tpcds/10s/time_dim.dat') format 'text' (delimiter '|' null as '');
create readable external table reason_ext (like reason) location ('gpfdist://localhost:9898/tpcds/10s/reason.dat') format 'text' (delimiter '|' null as '');
create readable external table income_band_ext (like income_band) location ('gpfdist://localhost:9898/tpcds/10s/income_band.dat') format 'text' (delimiter '|' null as '');
create readable external table item_ext (like item) location ('gpfdist://localhost:9898/tpcds/10s/item.dat') format 'text' (delimiter '|' null as '');
create readable external table store_ext (like store) location ('gpfdist://localhost:9898/tpcds/10s/store.dat') format 'text' (delimiter '|' null as '');
create readable external table call_center_ext (like call_center) location ('gpfdist://localhost:9898/tpcds/10s/call_center.dat') format 'text' (delimiter '|' null as '');
create readable external table customer_ext (like customer) location ('gpfdist://localhost:9898/tpcds/10s/customer.dat') format 'text' (delimiter '|' null as '');
create readable external table web_site_ext (like web_site) location ('gpfdist://localhost:9898/tpcds/10s/web_site.dat') format 'text' (delimiter '|' null as '');
create readable external table store_returns_ext (like store_returns) location ('gpfdist://localhost:9898/tpcds/10s/store_returns.dat') format 'text' (delimiter '|' null as '');
create readable external table household_demographics_ext (like household_demographics) location ('gpfdist://localhost:9898/tpcds/10s/household_demographics.dat') format 'text' (delimiter '|' null as '');
create readable external table web_page_ext (like web_page) location ('gpfdist://localhost:9898/tpcds/10s/web_page.dat') format 'text' (delimiter '|' null as '');
create readable external table promotion_ext (like promotion) location ('gpfdist://localhost:9898/tpcds/10s/promotion.dat') format 'text' (delimiter '|' null as '');
create readable external table catalog_page_ext (like catalog_page) location ('gpfdist://localhost:9898/tpcds/10s/catalog_page.dat') format 'text' (delimiter '|' null as '');
create readable external table inventory_ext (like inventory) location ('gpfdist://localhost:9898/tpcds/10s/inventory.dat') format 'text' (delimiter '|' null as '');
create readable external table catalog_returns_ext (like catalog_returns) location ('gpfdist://localhost:9898/tpcds/10s/catalog_returns.dat') format 'text' (delimiter '|' null as '');
create readable external table web_returns_ext (like web_returns) location ('gpfdist://localhost:9898/tpcds/10s/web_returns.dat') format 'text' (delimiter '|' null as '');
create readable external table web_sales_ext (like web_sales) location ('gpfdist://localhost:9898/tpcds/10s/web_sales.dat') format 'text' (delimiter '|' null as '');
create readable external table catalog_sales_ext (like catalog_sales) location ('gpfdist://localhost:9898/tpcds/10s/catalog_sales.dat') format 'text' (delimiter '|' null as '');
create readable external table store_sales_ext (like store_sales) location ('gpfdist://localhost:9898/tpcds/10s/store_sales.dat') format 'text' (delimiter '|' null as '');

insert into dbgen_version select * from dbgen_version_ext;
drop external table dbgen_version_ext;
insert into customer_address select * from customer_address_ext;
drop external table customer_address_ext;
insert into customer_demographics select * from customer_demographics_ext;
drop external table customer_demographics_ext;
insert into date_dim select * from date_dim_ext;
drop external table date_dim_ext;
insert into warehouse select * from warehouse_ext;
drop external table warehouse_ext;
insert into ship_mode select * from ship_mode_ext;
drop external table ship_mode_ext;
insert into time_dim select * from time_dim_ext;
drop external table time_dim_ext;
insert into reason select * from reason_ext;
drop external table reason_ext;
insert into income_band select * from income_band_ext;
drop external table income_band_ext;
insert into item select * from item_ext;
drop external table item_ext;
insert into store select * from store_ext;
drop external table store_ext;
insert into call_center select * from call_center_ext;
drop external table call_center_ext;
insert into customer select * from customer_ext;
drop external table customer_ext;
insert into web_site select * from web_site_ext;
drop external table web_site_ext;
insert into store_returns select * from store_returns_ext;
drop external table store_returns_ext;
insert into household_demographics select * from household_demographics_ext;
drop external table household_demographics_ext;
insert into web_page select * from web_page_ext;
drop external table web_page_ext;
insert into promotion select * from promotion_ext;
drop external table promotion_ext;
insert into catalog_page select * from catalog_page_ext;
drop external table catalog_page_ext;
insert into inventory select * from inventory_ext;
drop external table inventory_ext;
insert into catalog_returns select * from catalog_returns_ext;
drop external table catalog_returns_ext;
insert into web_returns select * from web_returns_ext;
drop external table web_returns_ext;
insert into web_sales select * from web_sales_ext;
drop external table web_sales_ext;
insert into catalog_sales select * from catalog_sales_ext;
drop external table catalog_sales_ext;
insert into store_sales select * from store_sales_ext;
drop external table store_sales_ext;