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') ;