静态分区和动态分区的sql

动态分区

insert overwrite table dwd_comment_info partition (dt)
select id,
       user_id,
       sku_id,
       spu_id,
       order_id,
       appraise,
       create_time,
       date_format(create_time, 'yyyy-MM-dd')
from ods_comment_info
where dt = '2020-06-14';

静态分区

insert overwrite table dwd_comment_info partition (dt = '2020-06-15')
select id,
       user_id,
       sku_id,
       spu_id,
       order_id,
       appraise,
       create_time
from ods_comment_info
where dt = '2020-06-15'