建表语句:
create table cm_subs_base_info_seqfile_table
(
servnumber string
,subsid string
,custid string
,acctid string
,applyoid string
,prodid string
,rec_time timestamp
)
COMMENT 'This is test load data seqfile_table'
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS sequencefile
LOCATION '/user/hive/warehouse/seqfile_table';
set hive.exec.compress.output=true;
set mapred.output.compress=true;
set mapred.output.compression.codec=org.apache.hadoop.io.compress.GzipCodec;
set io.compression.codecs=org.apache.hadoop.io.compress.GzipCodec;
SET io.seqfile.compression.type=BLOCK;
insert overwrite table cm_subs_base_info_seqfile_table select * from cm_subs_base_info;
报错,如图,请帮忙看看?
数据如图:
|