hive：分区表

CREATE TABLE dbname.tablename ( center_code STRING, owner_code STRING, ....... storage_type STRING, wh_code STRING)PARTITIonED BY ( 自定义分区字段 STRING ---不在字段列表中，文件夹前缀名)STORED AS PARQUET;

添加分区alter table dbname.tablename add partition ( 分区字段名='2021-01-05') ;