create table worker_seq(id int,name string)
stored as sequencefile;
将从别的表查询的数据放入到seq中
insert into worker_seq
select id,name from worker_1
将查询出来的数据直接使用sequencefile保存。
create table worker_seq
stored as sequencefile
as
select *
from worker_1;
查询seq表的信息
select * from worker_seq;
将查询出来的数据直接使用orc保存。
create table worker_orc
stored as orc
as
select *
from worker_1;
将查询出来的数据直接使用parquet保存。
create table worker_par
stored as parquet
as
select *
from worker_1;