load data local inpath '/home/hadoop/tempdata/webfb.access.log'
into table default.web_log_src;
创建子表
drop table if exists default.web_log_comm;
create table IF NOT exists default.web_log_comm(
remote_addr string,
time_local string,
request string,
http_referer string
)
row format delimited FIELDS terminated BY '\t'
STORED AS orc tblproperties ("orc.compress"="SNAPPY");
为子表导入数据
INSERT into TABLE default.web_log_comm SELECT remote_addr,time_local,request,http_referer
FROM default.web_log_src;