记录常用的分区表操作:
查看分区
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 于南京市九龙湖