1.增加分区
alter table tableName add if not exists partition(ds='20200623')
2.数据类型转换
cast(col as bigint)
3.动态插入
insert overwrite table tableA partition(ds) select A.其他非分区字端,20200713 as ds from tableA where ds=20200712;
alter table tableName add if not exists partition(ds='20200623')
cast(col as bigint)
insert overwrite table tableA partition(ds) select A.其他非分区字端,20200713 as ds from tableA where ds=20200712;