动态分区功能实例

 

 

create table pz_business_search (
interface_name     string comment'接口名称',
interface_param_in string comment'接口入参',
interface_type string comment'接口类型',
invoke_time        string comment'调用时间'
)
ROW FORMAT DELIMITED 
 FIELDS TERMINATED BY ','---数据列分隔符 
STORED AS TEXTFILE;

其基本数据如下：
interface1  param1  1 2018-12-19
interface2  param2  1 2018-12-19
interface3  param3  1 2018-12-19
interface4  param4  1 2018-12-19
interface1  param1  1 2018-12-20
interface2  param2  1 2018-12-20
interface3  param3  1 2018-12-20
interface4  param4  1 2018-12-20

create table pz_business_search_partition (
interface_name     string comment'接口名称',
interface_param_in string comment'接口入参'
)
partitioned by (interface_type string, invoke_time string)  分区表：两个分区
ROW FORMAT DELIMITED 
 FIELDS TERMINATED BY ','---数据列分隔符 
STORED AS TEXTFILE;

实现动态分区：
insert overwrite table pz_business_search_partition partition (interface_type='1',invoke_time)
select interface_name,interface_param_in,invoke_time from pz_business_search;