Parquet文件格式向序列文件格式的转换

Question

我将我的蜂箱表作为Parquet格式存储在HDFS中的某个位置。我能把这个位置的拼花文件转换成顺序文件格式并在上面构建蜂巢表吗？是否有任何程序来进行此转换？

Answer 1

创建新的序列文件表并使用insert select重新加载数据：

insert into sequence_table
select * from parquet_table;

Answer 2

hive> create table src (i int) stored as parquet;
OK
Time taken: 0.427 seconds
hive> create table trg stored as sequencefile as select * from src;

For @AndyReddy

create table src (i int) 
partitioned by (year int,month tinyint,day tinyint)
stored as parquet
;

create table trg (i int) 
partitioned by (year int,month tinyint,day tinyint)
stored as sequencefile
;

set hive.exec.dynamic.partition.mode=nonstrict
;

insert into trg partition(year,month,day)
select * from src
;