静态和动态分区表差不多一样,只不过在导入数据时需要加上条件:
insert overwrite table p_user partition(occupationid) select id,gender,age,zip,occupationid from user;
insert overwrite table p_user partition(occupationid=22) select id,gender,age,zip,occupationid from user;
静态和动态最大的区别是动态能根据occupationid的不同而创建不同的分区表,而静态则是指定创建occupationid某个值的分区,上面是occupation=22