Hello,
     I have two table ,one is stored as textfile for loading data from
local data, the other is stored as rcfile for compressing data。
     when I execute the following sql two times

*     insert into table tablename1 select * from tablename2*

     I find that there are two files in the warehouse

      *hadoop fs -ls /user/hive/warehouse/**tablename2**/*
*      Found 2 items*
*     -rwxrwxrwt   3 root supergroup        423 2014-08-28 21:09
/user/hive/warehouse/**tablename2**/000000_0*
*     -rwxrwxrwt   3 root supergroup        423 2014-08-28 21:11
/user/hive/warehouse/**tablename2**/000000_0_copy_1*

   I need to merge the two files to reduce the small file, is there have
some way to merge the files?
   thank you !

Reply via email to