记录常用的分区表操作: 查看分区删除分区插入分区数据 查看分区 show partitions tmp.order; 删除分区 ALTER TABLE tmp.order DROP IF EXISTS PARTITION (dt='20200520'); 复写分区 INSERT overwrite TABLE tmp.order partition (dt) SELECT * FROM tmp.order_test WHERE dt>=20200101 and dt<=20200110; 2020-08-28 于南京市九龙湖