input1:

create external table db.emp(id int,name string)
row formatted fields terminated by ','
location 'hadfs:.../';

create external table db.emp1(id int,name string)
row formatted fields terminated by ','
location 'hadfs:.../';
input2:

create table db.emp(id int,name string)
location 'hadfs:.../';;
create table db.emp1(id int,name string)
location 'hadfs:.../';
requeried output:

create external table db.emp(id int,name string)
row formatted fields terminated by ','
location 'hadfs:.../';
create table db.emp(id int,name string)
location 'hadfs:.../';
these two files stored under file1.hql

create external table db.emp1(id int,name string)
row formatted fields terminated by ','
location 'hadfs:.../';
create table db.emp1(id int,name string)
location 'hadfs:.../';
These two files stored under file2.hql and so on