Greenplum create table

create table sanguozhi (id bigint, name varchar(32), country varchar(8), url varchar(128), ip varchar(16), uuid varchar(36), agent varchar(128), detail varchar(512), birthday date) WITH (appendonly=true) distributed by (id) partition by range(birthday) (START('0200-01-01') END('0300-01-01') EVERY('0001-00-00'), DEFAULT PARTITION sgz_partition);

appendonly 表不能有unique index，主键是一种primary key，所以不能有。

 

如果有主键，则不能是appendonly 表，为了追求查询性能，因为用外部表导入的话，插入不是问题了。

 

create table sanguozhi (id bigint, name varchar(32), country varchar(8), url varchar(128), ip varchar(16), uuid varchar(36), agent varchar(128), detail varchar(512), birthday date,primary key(id,birthday)) WITH  distributed by (id) partition by range(birthday) (START('0200-01-01') END('0300-01-01') EVERY('0001-00-00'), DEFAULT PARTITION sgz_partition);