sql/hive/src/test/resources/ql/src/test/queries/clientnegative/exim_23_import_exist_authfail.q


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

set hive.test.mode=true;
set hive.test.mode.prefix=;

create table exim_department ( dep_id int) stored as textfile;
load data local inpath "../../data/files/test.dat" into table exim_department;
dfs ${system:test.dfs.mkdir} target/tmp/ql/test/data/exports/exim_department/temp;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;
export table exim_department to 'ql/test/data/exports/exim_department';
drop table exim_department;

create database importer;
use importer;

create table exim_department ( dep_id int) stored as textfile;
set hive.security.authorization.enabled=true;
import from 'ql/test/data/exports/exim_department';

set hive.security.authorization.enabled=false;
drop table exim_department;
drop database importer;
dfs -rmr target/tmp/ql/test/data/exports/exim_department;