1.创建分区表
create table aaa(id bigint,name string) partitioned by (address string);
2.创建分区字段
alter table aaa add if not exists partition (address = ‘fujian’);
3.向分区表里插入数据
insert into aaa partition(address = ‘fujian’) values(1,‘xxd’);
4.查询分区表数据
select * from aaa where address=‘fujian’;
5.利用select 语句插入数据
insert into aaa partition(address =‘fujian’) select id ,name from bbb;