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 external table db.emp(id int,name string)
row formatted fields terminated by ','
location 'hadfs:.../';;
create table db.emp1(id int,name string)
row formatted fields terminated by ','
location 'hadfs:.../';
requeried output:create external table db.emp(id int,name string)
row formatted fields terminated by ','
location 'hadfs:.../';
create external table db.emp(id int,name string)
row formatted fields terminated by ','
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 external table db.emp(id int,name string)
row formatted fields terminated by ','
location 'hadfs:.../';
these two files stored under file2.hql and so on i tried with:
filenames = ['in1.txt', 'in2.txt']
with open('result.txt', 'w') as outfile:
for fname in filenames:
with open(fname) as infile:
content = infile.read().replace('\n', '')
outfile.write(content) but i didn't get requeried output. Please give me a hint how to achieve this.
... View more
