create table load_overwrite (key string, value string) stored as textfile location 'file:/tmp/load_overwrite';
create table load_overwrite2 (key string, value string) stored as textfile location 'file:/tmp/load2_overwrite2';

load data local inpath '../data/files/kv1.txt' into table load_overwrite;
load data local inpath '../data/files/kv2.txt' into table load_overwrite;
load data local inpath '../data/files/kv3.txt' into table load_overwrite;

show table extended like load_overwrite;
desc extended load_overwrite;
select count(*) from load_overwrite;

load data inpath '/tmp/load_overwrite/kv*.txt' overwrite into table load_overwrite2;

show table extended like load_overwrite2;
desc extended load_overwrite2;
select count(*) from load_overwrite2;

load data inpath '/tmp/load2_*' overwrite into table load_overwrite;
show table extended like load_overwrite;
select count(*) from load_overwrite;