drop table insert1;
drop table insert2;
create table insert1(key int, value string) stored as textfile;
create table insert2(key int, value string) stored as textfile;
insert overwrite table insert1 select a.key, a.value from insert2 a WHERE (a.key=-1);
drop table insert1;
drop table insert2;