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
Loading data to table default.raw_logs partition (dt=20110426)
Failed with exception Wrong file format. Please check the file's format.
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.MoveTask

The raw_logs table is created by:
create table raw_logs ( ............)  partitioned by ( dt int ) STORED AS
SEQUENCEFILE;

Is there something wrong? The error is same both in hive 0.5 and 0.7.

Reply via email to