How to merge multiple files of Hive into one?

#1

I have a table table1 in Hive in which I have loaded 100s of files. I want to create a single file out of this table?

#2

CREATE TABLE mysf_table_int2
(col1 varchar(100) , col2 varchar(100), col3 varchar(100) , col4 varchar(100), col5 varchar(100), col6 varchar(100), col7 varchar(100), col8 varchar(100), col9 varchar(100) )
STORED AS SequenceFile;

insert into mysf_table_int2
select * from table1 order by col1;