--非分区表
USE ODS;
DROP TABLE IF EXISTS s01_t_sys_file;
CREATE TABLE s01_t_sys_file (
id STRING COMMENT '自增长列id',
biz_name STRING COMMENT '业务名称',
biz_id STRING COMMENT '业务关联id',
ETL_TIME STRING COMMENT '操作日期'
)COMMENT '文件存储表' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' STORED AS TEXTFILE;
--分区表
USE ODS;
DROP TABLE IF EXISTS s01_t_sys_file;
CREATE TABLE s01_t_sys_file (
id STRING COMMENT '自增长列id',
biz_id STRING COMMENT '业务关联id',
content_type STRING COMMENT '存放的内容格式'
)COMMENT '文件存储表' PARTITIONED BY (ETL_TIME STRING COMMENT '操作日期') ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' STORED AS TEXTFILE;