hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 王洋 <wangyang....@gmail.com>
Subject How to merge the output file when insert data into a table
Date Thu, 28 Aug 2014 14:45:04 GMT
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 !

Mime
View raw message