Re: Load gzip files into hive

2011-04-28 Thread wd
raw_logs table into the new table (e.g., raw_logs_rcfile) that you > have defined in the different format. > > So, this is the only way I can put data into a table defined as sequence file? Can I generate the RCFile use a unix command or some tools ? > > On Apr 27, 2011, at 9:33 PM, wd wrot

Re: Load gzip files into hive

2011-04-27 Thread Loren Siebert
RCFile table or a sequence file table or whatever, you can select from the raw_logs table into the new table (e.g., raw_logs_rcfile) that you have defined in the different format. On Apr 27, 2011, at 9:33 PM, wd wrote: > hi, > > I've tried to load gzip files into hive to save d

Load gzip files into hive

2011-04-27 Thread wd
hi, I've tried to load gzip files into hive to save disk space, but failed. hive> load data local inpath 'tmp_b.20110426.gz' into table raw_logs partition ( dt=20110426 ); Copying data from file:/home/wd/t/tmp_b.20110426.gz Copying file: file:/home/wd/t/tmp_b.20110426.gz Loa