常用组合:parquet 格式 + snappy 压缩
set parquet.compression=snappy;
CREATE TABLE db_name.tb_name(
id STRING
)
PARTITIONED BY (date_str STRING ,hour_str STRING )
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS PARQUET;
常用组合:ORC 格式 + snappy 压缩
CREATE TABLE db_name.tb_name(
id STRING
)
PARTITIONED BY (date_str STRING ,hour_str STRING )
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS ORC
TBLPROPERTIES ("orc.compress"="SNAPPY") ;