ql/src/test/queries/clientpositive/exim_12_external_location.q

set hive.test.mode=true;
set hive.test.mode.prefix=;
set hive.test.mode.nosamplelist=exim_department_n8,exim_employee;

create table exim_department_n8 ( dep_id int comment "department id") 	
	stored as textfile	
	tblproperties("creator"="krishna");
load data local inpath "../../data/files/test.dat" into table exim_department_n8;		
dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/ql/test/data/exports/exim_department/temp;
dfs -rmr ${system:test.tmp.dir}/ql/test/data/exports/exim_department;
export table exim_department_n8 to 'ql/test/data/exports/exim_department';
drop table exim_department_n8;

create database importer;
use importer;

dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/ql/test/data/tablestore/exim_department/temp;
dfs -rmr ${system:test.tmp.dir}/ql/test/data/tablestore/exim_department;

import external table exim_department_n8 from 'ql/test/data/exports/exim_department' 
	location 'ql/test/data/tablestore/exim_department';
describe extended exim_department_n8;
dfs -rmr ${system:test.tmp.dir}/ql/test/data/exports/exim_department;
select * from exim_department_n8;
dfs -rmr ${system:test.tmp.dir}/ql/test/data/tablestore/exim_department;
select * from exim_department_n8;
drop table exim_department_n8;

drop database importer;