CREATE EXTERNAL TABLE database
.table_name
(
id
string comment ‘id’
)
COMMENT ‘table_name’
PARTITIONED BY(
day
string comment ‘日期’
) ROW FORMAT SERDE ‘org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe’ WITH SERDEPROPERTIES (
“field.delim”=“\u0001”,“serialization.format”=“\u0001”)
STORED AS INPUTFORMAT ‘org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat’ OUTPUTFORMAT ‘org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat’
LOCATION ‘hdfs路径’
创建成功后,需要手动更新分区信息 alter table add partition(day=‘2023-01-01’)