Maxcompute分区表插入数据

1.创建分区表
create table aaa(id bigint,name string) partitioned by (address string);

2.创建分区字段
alter table aaa add if not exists partition (address = ‘shanghai’);

3.向分区表里插入数据
insert into aaa partition(address = ‘shanghai’) values(1,‘tinson’);

4.查询分区表数据
select * from aaa where partition=‘shanghai’;

5.利用select 语句插入数据
insert into aaa partition(address =‘shanghai’) select id ,name from bbb;