Hive 表的存储格式

create table if not exists record_orc ( 
rid string, 
uid string, 
bid string, 
price int, 
source_province string, 
target_province string, 
site string, 
express_number string, 
express_company string, 
trancation_date date 
) 
stored as orc;

-- 查看建表信息
show create table record_orc; 


-- 另一种建表方式
create table record_parquet like record_orc stored as parquet;

insert into table record_orc select * from record; 

hdfs dfs -ls /warehouse/mydb.db/record
hdfs dfs -ls /warehouse/mydb.db/record_parquet
hdfs dfs -ls /warehouse/mydb.db/record_orc