HQL动态分区

DROP TABLE IF EXISTS dwd_activity_info_full;
CREATE EXTERNAL TABLE dwd_activity_info_full
(
    `id`            STRING COMMENT '活动id',
    `activity_name` STRING COMMENT '活动名称',
    `activity_type` STRING COMMENT '活动类型',
    `activity_desc` STRING COMMENT '活动描述',
    `end_time`      STRING COMMENT '结束时间',
    `create_time`   STRING COMMENT '创建时间'
) COMMENT '活动信息表'
    PARTITIONED BY (`start_time` STRING)
    ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
    NULL DEFINED AS ''
    LOCATION '/warehouse/gmall/dwd/dwd_activity_info_full/';

set hive.exec.dynamic.partition.mode=nonstrict;
insert overwrite table dwd_activity_info_full partition (start_time)
select
   `id`  ,
    activity_name,
    activity_type,
    activity_desc,
    end_time,
    create_time,
    date_format(`start_time`,'yyyy-MM-dd') start_time
from ods_activity_info_full;