Hive动态分区

set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.dynamic.partition=true;

insert overwrite table msys_messagevaclog partition(log_month,log_day) select t.*,substr(log_time,1,6),substr(log_time,1,8) from msys_messagevaclog_no_partition t where substr(t.log_time,1,8)='${var_log_day}';