常见用法
1.动态分区表创建
CREATE TABLE qing_city (
city_name STRING
)
PARTITIONED BY (province_id string,province_name string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY'\t';
2.设置动态分区参数
set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions.pernode=600000;
set hive.exec.max.dynamic.partitions=6000000;
set hive.exec.max.created.files=6000000;
set mapreduce.job.queuename=root.datagroup.dw;
3.写入数据到动态表
use zhidao;
insert overwrite table qing_city partition(province_id,province_name)
select
city_name,
province_id,
province_name
from dim_zhidao_city limit 2;
4. cascade强制执行
坑一:修改字段类型后更新数据不成功
坑二:增加字段后更新数据不成功
alter修改表结构时,可以强制刷表数据。