blob: e4034186409c79329d9654e08ec8671b2e46506d [file] [log] [blame]
set hive.test.mode=true;
set hive.test.mode.prefix=;
set hive.test.mode.nosamplelist=exim_department_n6,exim_employee;
set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider;
create table exim_department_n6 ( dep_id int) stored as textfile;
load data local inpath "../../data/files/test.dat" into table exim_department_n6;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_department/test;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
export table exim_department_n6 to 'ql/test/data/exports/exim_department';
drop table exim_department_n6;
create database importer;
use importer;
set hive.security.authorization.enabled=true;
grant Create on database importer to user hive_test_user;
import from 'ql/test/data/exports/exim_department';
set hive.security.authorization.enabled=false;
select * from exim_department_n6;
drop table exim_department_n6;
drop database importer;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;