1. 建表, 存储格式为 ORC 格式

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;

2. 导入数据

insert into table record_orc select * from record;

3. 查看 hdfs 文件所占空间的大小

hdfs dfs -ls /warehouse/mydb.db/recordhdfs dfs -ls /warehouse/mydb.db/record_parquethdfs dfs -ls /warehouse/mydb.db/record_orc